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?  
Author Message
jaxitis





PostPosted: Fri Jul 20 14:09:45 CDT 2007 Top

SQL Server >> 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?

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?

SQL Server277  
 
 
Aaron





PostPosted: Fri Jul 20 14:09:45 CDT 2007 Top

SQL Server >> 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? Can you define "maxed out"? And what are the actual symptoms?

--
Aaron Bertrand
SQL Server MVP






> 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?
>


 
 
Roy





PostPosted: Fri Jul 20 14:12:41 CDT 2007 Top

SQL Server >> 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? On Fri, 20 Jul 2007 12:01:39 -0700, "Daniel"


>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 don't post the same question to multiple groups. If you must
send one to two groups, but BOTH groups on the SAME copy so that
replies are seen in both places. (It helps if you use the Subject for
a short Subject too.)

I'm no cluster expert, but when the experts get here they will have
some questions. You might want to have answers ready.

What is maxing out? Disk space? CPU utilization? Memory? The
network?

What does high-end mean in this instance? How many servers, how many
and what type processors, how muchy memory, what sort of disk system?

What is the structure of the cluster? How many machines, running what
operating system/version, running what SQL Server
version(s)/instances? What is the failover arrangement?

Generally the smallest unit of SQL Server that can be moved without
re-writing something is a database. Tables fall within databases. A
question about moving tables sounds like you are a system
administrator but not a DBA. With a high-end cluster that is maxing
out you need the hands-on attention of a DBA.

Roy Harvey
Beacon Falls, CT