Our high end SQL server cluster is maxed out, how else to expand? Will it
help to move tables off of the cluster onto other clusters or will that just
create processing bottleneck on the cluster running SQL server?
Please provide additional details about your SQL cluster (hardware, SQL
server version, configuration, etc.) and what constitutes "maxed out". Where
is the bottleneck -- memory, disk, cpu, network? Performance monitor can
help narrow this down.
Also, moving tables off of one cluster to another may make sense under
certain circumstances but it requires knowing the data and how it is accessed
in the very least to be able to give any informative advice. SQL Server 2005
provides some nice functionality along this line.
"Daniel" wrote:
> Our high end SQL server cluster is maxed out, how else to expand? Will it
> help to move tables off of the cluster onto other clusters or will that just
> create processing bottleneck on the cluster running SQL server?
>
>
Wednesday, March 21, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment