Our high end SQL server cluster is maxed out, how else to expand? Will it help to move tab

Daniel,
This is a question for the .clustering group, so I added it to the list of
groups. Hope you get answer there.
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/
"Daniel" <softwareengineer98037@.yahoo.com> wrote in message
news:OJBAfBwyHHA.3848@.TK2MSFTNGP03.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?
>
You can do a node-swap, where you replace each node with a more powerful
one. However, I find chasing performance with hardware is a losing battle.
Find out what resource is maxed out and why. Fix the underlying problem by
rewriting or re-architecting the resource hogs. I usually start a project
like this with a complete assessment and analysis of the existing system so
I can identify likely fixes and present a prioritized list to the client.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:%23f7V971yHHA.5980@.TK2MSFTNGP04.phx.gbl...
> Daniel,
> This is a question for the .clustering group, so I added it to the list of
> groups. Hope you get answer there.
> --
> Dejan Sarka
> http://blogs.solidq.com/EN/dsarka/
> "Daniel" <softwareengineer98037@.yahoo.com> wrote in message
> news:OJBAfBwyHHA.3848@.TK2MSFTNGP03.phx.gbl...
>
sql