Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com Nov 26 '10 at 3:43

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

add comment

2 Answers

up vote 1 down vote accepted

Replication may be an option for you: http://technet.microsoft.com/en-us/library/bb500346.aspx

share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.