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

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

1 Answer 1

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

 
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.