Load balancing

Hi,
Is it possible to use windows NLB for Sql 2000 enterprise edition servers.
We are using 300gb database in one server and the performance is very slow.
Any how we can't get load balancing in SQL clustering, If it is possible
with NLB please let me know how to configure it.
We are planning to put the database in SAN ,so both the servers will use
central database instead of individual one.
Thanks
Murali
"Space is not available in TempDB"
<SpaceisnotavailableinTempDB@.discussions.microsoft .com> wrote in message
news:FB6ABB56-D877-47E4-8C44-B79BD593CA20@.microsoft.com...
> Hi,
> Is it possible to use windows NLB for Sql 2000 enterprise edition servers.
No.

> We are using 300gb database in one server and the performance is very
slow.
> Any how we can't get load balancing in SQL clustering, If it is possible
> with NLB please let me know how to configure it.
> We are planning to put the database in SAN ,so both the servers will use
> central database instead of individual one.
This wont' work. Each instance of SQL server needs access to its own copy
of the database files.
What you can try is log-shipping or replication from one server to another.

> Thanks
> Murali
|||Hi,
Thanks for your response .
log shipping may not suitable to our requirement.
we are using on CRM application , from the application server through odbc
it will contact the sql server.
We can't specify multiple servers in odbc connection for sqlserver even if
we use log shipping.
Please give some other resolution which will distribute the load between 2
servers.
Thanks
Murali
"Greg D. Moore (Strider)" wrote:

> "Space is not available in TempDB"
> <SpaceisnotavailableinTempDB@.discussions.microsoft .com> wrote in message
> news:FB6ABB56-D877-47E4-8C44-B79BD593CA20@.microsoft.com...
> No.
> slow.
> This wont' work. Each instance of SQL server needs access to its own copy
> of the database files.
> What you can try is log-shipping or replication from one server to another.
>
>
>
|||Buy a bigger server. NLB will split the query load between several servers,
but there is no way to coalesce the changes on the back end. Each server
instance has a unique, independant set of databases that are only accessable
through that instance. In a clustered environment, eacn instance can move
between hosts, but can only live on one host at a time. SQL scales up, not
out.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Space is not available in TempDB"
<SpaceisnotavailableinTempDB@.discussions.microsoft .com> wrote in message
news:90501899-D509-4B25-AB9F-8021E0F90350@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for your response .
> log shipping may not suitable to our requirement.
> we are using on CRM application , from the application server through odbc
> it will contact the sql server.
> We can't specify multiple servers in odbc connection for sqlserver even if
> we use log shipping.
> Please give some other resolution which will distribute the load between 2
> servers.
> Thanks
> Murali
> "Greg D. Moore (Strider)" wrote:
servers.[vbcol=seagreen]
possible[vbcol=seagreen]
use[vbcol=seagreen]
copy[vbcol=seagreen]
another.[vbcol=seagreen]

little server icon in the Enterprise Manager had a red squiggly mark next

Hi,
I have observed some errors in my sql server. I dont know
whether it makes any problems or not.
"little server icon in the Enterprise Manager had a red
squiggly mark next to it."
Can anyone tell me what is this.
Regards
RajIt just indicates that you are logged on to the SQL Server. It is a good
thing.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Raj" <anonymous@.discussions.microsoft.com> wrote in message
news:03e601c3bfdb$f25c63b0$a001280a@.phx.gbl...
> Hi,
> I have observed some errors in my sql server. I dont know
> whether it makes any problems or not.
> "little server icon in the Enterprise Manager had a red
> squiggly mark next to it."
> Can anyone tell me what is this.
> Regards
> Raj
>|||Raj wrote:
> Hi,
> I have observed some errors in my sql server. I dont know
> whether it makes any problems or not.
> "little server icon in the Enterprise Manager had a red
> squiggly mark next to it."
> Can anyone tell me what is this.
> Regards
> Raj
It is NOT an error, it just tells you you're connected to that server. Try
rightclickingon the server and choose disconnect to see it dissapear

List of tables

Hi,
Is there any command to find all the tables(including system tables) in SQLserver(I do not want to use enterprise manager).
Regards,Originally posted by sursujmad
Hi,

Is there any command to find all the tables(including system tables) in SQLserver(I do not want to use enterprise manager).

Regards,

You can use a sql request like this

select * from sysobjects where type = 's' or type = 'u'|||--Try
exec sp_tables
select user_name(uid)+'.'+name from sysobjects where xtype in ('U','S')
select * from information_schema.tables

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....
One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....
|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager
|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager

List of 3rd Party Enterprise monitoring tools for SQL

I am trying to compile a list of 3rd part monitoring applications for SQL.
We have about 30 SQL servers that we need to do more in-depth enterprise
monitoring of all aspects of each system. I just need to compile a short
list of possible contenders so any recommendations would be appreciated.
e.g.
HP Open View, MOM, Prognosis, etc....One tool you should definitely look at is SQL Sentry. www.sqlsentry.net
Andrew J. Kelly SQL MVP
"DB" <DB@.discussions.microsoft.com> wrote in message
news:B7EE5EB6-4609-4833-969A-5FAB28F6334C@.microsoft.com...
>I am trying to compile a list of 3rd part monitoring applications for SQL.
> We have about 30 SQL servers that we need to do more in-depth enterprise
> monitoring of all aspects of each system. I just need to compile a short
> list of possible contenders so any recommendations would be appreciated.
> e.g.
> HP Open View, MOM, Prognosis, etc....|||my list so far..
SQL Server Management Pack for MOM
Integrated Research : PROGNOSIS
Quest : Solutions for Microsoft SQL Server
HP OpenView : Smart Plug-in for Microsoft SQL Server
NetIQ : SQL Server Management
SQLSentry
Idera - SQL diagnostic manager|||Here's one you don't have on the list (that I really want, but my employer
doesn't want to buy me--yet):
www.compactdba.com
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"DB" <DB@.discussions.microsoft.com> wrote in message
news:56685BF3-5A6C-4C4D-B5FA-06AACFCCF467@.microsoft.com...
> my list so far..
> SQL Server Management Pack for MOM
> Integrated Research : PROGNOSIS
> Quest : Solutions for Microsoft SQL Server
> HP OpenView : Smart Plug-in for Microsoft SQL Server
> NetIQ : SQL Server Management
> SQLSentry
> Idera - SQL diagnostic manager