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]