Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need complete tutorial about MSSQL 2008 Database mirroring for load balancing

i want to load balance my SQL workload

all database insert update and delete queries will be mirrored

all select queries will be load balanced

sql servers will run at windows server 2008r2 at different computers (VPS)

share|improve this question

migrated from Nov 26 '10 at 3:43

This question came from our site for professional and enthusiast programmers.

up vote 1 down vote accepted

Replication may be an option for you:

share|improve this answer

Database mirroring is not load balancing: it's high availability.

You can not load balance SELECT queries.

What you can do it create database snapshots of the mirror and then use this for reporting. However, the snapshot is fixed in time and does not receive any updates.

What kind of volumes do you have that you think this will help? Normally stuffing more RAM into a 64 bit installation works a treat.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.