Re: Load Balancing
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Wed, 20 Jul 2005 10:38:46 -0400
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@xxxxxxxxxxxxxxxx> wrote in message
news:OG3UGVSjFHA.2904@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>
.
- References:
- Load Balancing
- From: Floris
- Load Balancing
- Prev by Date: Replicated Table cannot alter
- Next by Date: Re: SQL Server 2000 Merge Replication
- Previous by thread: Load Balancing
- Next by thread: Replicated Table cannot alter
- Index(es):
Relevant Pages
|
