Re: 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?
- From: "Tom Moreau" <tom@xxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 20 Jul 2007 15:09:03 -0400
Based on your limited description, it is hard to say. There are many
questions to ask (and answer). Some of them are:
* How big are the DB's?
* What hardware are you using?
* What version/edition of SQL Server are you using?
* What queries are you running?
* Are all queries bad or just some?
* Are queries blocking each other?
* Did you trace with the profiler?
* Did you trace with PerfMon?
BTW, this is the security newsgroup. This type of question would be best
posted in the server newsgroup.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Daniel" <softwareengineer98037@xxxxxxxxx> wrote in message
news:OmRXlBwyHHA.988@xxxxxxxxxxxxxxxxxxxxxxx
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?
.
- References:
- Prev by Date: 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?
- Next by Date: What type of certificate?
- Previous by thread: 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?
- Next by thread: What type of certificate?
- Index(es):
Relevant Pages
|
|
