Load Balancing -- sql server replication

Floris
7/20/2005 12:00:00 AM

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

Hilary Cotter
7/20/2005 10:38:46 AM

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
[quoted text, click to view]

sql server replication : Load Balancing