Our high end SQL server cluster is maxed out, how else to ..

softwareengine · External Since: Dec 21, 2004 Posts: 25

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?

Roger Abell MVP · External Since: Apr 12, 2004 Posts: 671

Please try a relevant SQL server newsgroup.

In my experience and depending on specifics of "maxed out"
one can often resolve much by profiling what use is made of
the databases on the system and optimizing around that (update
statistics, rearrange filegroups, define new and drop unused
indices, etc.)

Roger

"Daniel" <softwareengineer98037.DeleteThis@yahoo.com> wrote in message
news:epr5%23BwyHHA.6028@TK2MSFTNGP04.phx.gbl...
> 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?
>