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 want to be sure something about sql server 2008 fail over clustering. I heard that when i set two sql servers as failover cluster servers i can set load level of sql servers. for examples i have SQL-A and SQL-B as failovered sql servers. SQL-A will process requests. SQL-B will wait. when SQL-A reached to %80 CPU load SQL-B will start to answer requests. Is that correct? this feature is sql server's feature or windows server's?

share|improve this question
up vote 3 down vote accepted

Someone has terribly misinformed you. MS clustering is only failover : that means that if A is active, it owns the cluster resources : storage, IP, and database services. B just sits there, twiddling its thumbs, until A dies. Then, B will take over the resources.

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.