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
No, SQL Server is not Load Balance aware. Even with clustering does not
provide Load Balancing.
You could have load balance your web servers, and have individual web
servers accessing different dedicated SQL Servers.
SQL Server 2005 does provide Peer to Peer replication which will keep a
group of SQL Servers aggregated for scale out read and write performance in
sync. But it does not provide load balancing, but a piece of the
functionality required by it.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Floris" <meNOSPAM@.here_my_place.nl> wrote in message
news:OG3UGVSjFHA.2904@.tk2msftngp13.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
>