Friday, March 23, 2012

Installing SQL Server on a Cluster

Hello All,
If SQL Server is installed on a cluster will it be able to utilize the CPU and memory of all of the servers that are part of the cluster. For example, currently we run SQL Server on one server and at certain peak time the server CPU is maxed out. Will a cluster environment allow SQL Server to utilize mutiple servers for processing eliminating this problem?
Thanks, Gary

There are lots of clustering technologies but typically you're probably talking about a fail-over cluster. These are, to all intensive purposes, separate machines and there is no load balancing across them. That's not to say you could try and partion across the databases but that's not a free feature you get from the cluster.
sql

No comments:

Post a Comment