load balancing in sql server

5 pts.
Tags:
Load balancing
SQL Server
SQL Server 2005
SQL Server clustering
SQL Server performance
Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?

Answer Wiki

Thanks. We'll let you know when a new response is added.

SQL 2005 does not offer internal load balancing but you can have multiple processors on a single machine and set their affinity. Some other solutions you might find interesting are here:

http://technet.microsoft.com/en-us/magazine/cc160974.aspx

If you need to scale out your SQL Server installation you have a couple of options.

1. You can use a federated database which stores part of the database on each server. Then the load used to query each part is isolated on each server.

2. You can use merge replication between a couple of SQL Servers so that you can write to either SQL Server and the data will be replicated to the other server within a few seconds.

3. You can setup a multi-tier database farm where you write to a single server, and setup transactional replication from that server to a set of read only servers which you can then load balance behind a load balancer.

4. You can use the new peer to peer replication technology to create a pool of servers.

When selecting which technique to use to keep in mind that any replication technique which has more than one SQL Server which you are writing to can have data problems if your unique identifier is not an identity field (such as a username for example).

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,010 pointsBadges:
    report
  • RASHMIMB
    hi, You said about setup a multi-tier database farm where you write to a single server, and setup transactional replication from that server to a set of read only servers which you can then load balance behind a load balancer.......can u please elaborate it as i want to impliment it in sql 2005.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following