Load balancing

#1

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

#2

"Space is not available in TempDB"
<SpaceisnotavailableinTempDB (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

Is it possible to use windows NLB for Sql 2000 enterprise edition servers.

No.

Quote:

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.

Quote:

Thanks
Murali

#3

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 (AT) discussions (DOT) microsoft.com> wrote

Quote:

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 (AT) dis... microsoft.com> wrote in message
news:FB6ABB56-D877-47E4-8C44-B79BD593CA20 (AT) microsoft (DOT) 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Load balancing

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Load balancing - 08-12-2004 , 07:03 AM

Re: Load balancing - 08-12-2004 , 07:27 AM

Re: Load balancing - 08-13-2004 , 10:23 AM