Q
Problem solve Get help with specific problems with your technologies, process and projects.

Query performance using clustering services

What is the expected impact (if any) on SQL Server 2000 query performance running SQL Server in a two-node, active-passive cluster using Microsoft clustering services? Can you please share your experiences with me?

There is zero performance impact when running a single instance cluster. The SQL Server runs on one of the hardware resources in the cluster, when it fails, it moves to the other hardware resource. The SQL Server has absolutely no clue that it is running on a cluster and unless someone told you, you would have no way of knowing you were connecting to a SQL Server running on a cluster or one running on a single machine. It's transparent and is supposed to be that way.

 

For More Information

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close