Wednesday, March 28, 2012

Load Balancing

Hi,
In windows 2003 server you have NLB (Network Load Balancing).
Can i use this to load balance my traffic to our sql server?
I know you also have "Microsoft Cluster Service" but that's only available
with Windows Server 2003 Enterprise Edition.
So is it possible to load balance my traffic from our webservers to our sql
servers?
And i will create a replication on the background between the 2 sql servers
so they will both serve the same data.
I hope someone has an answer for me.
Thanks in advance.
Floris
SQL Server does not support load balancing of the databases with NLB.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.itsummitseries.com/experts/fournier.htm - Cluster Summit
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message
news:OyIKCVSjFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Hi,
> In windows 2003 server you have NLB (Network Load Balancing).
> Can i use this to load balance my traffic to our sql server?
> I know you also have "Microsoft Cluster Service" but that's only available
> with Windows Server 2003 Enterprise Edition.
> So is it possible to load balance my traffic from our webservers to our
> sql servers?
> And i will create a replication on the background between the 2 sql
> servers so they will both serve the same data.
> I hope someone has an answer for me.
> Thanks in advance.
> Floris
>
sql

No comments:

Post a Comment