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?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Daniel,

What do you mean by maxed out. Is it "maxed out" on I/O, memory, CPU? Run a trace in Performance Monitor using the following counters and once you've identified the bottlenecks act accordingly, i.e. add more memory or more/faster disks or RAID, fix application problems (if you're getting blocking situations), remove other apps on the server etc. etc. But before you take action you need inform yourself on what the problem really is.


a. LogicalDisk (All Counters and All Instances)
b. Memory (All Counters)
c. Paging File (All Counters and All Instances)
d. PhysicalDisk (All Counters and All Instances)
e. Processor (All Counters and All Instances)
f. SQLServer:Access Methods (All Counters)
g. SQLServer:Buffer Manager (All Counters)
h. SQLServer:Buffer Node (All Counters and All Instances)
i. SQLServer:Buffer Partition (All Counters and All Instances)
j. SQLServer:Databases (All Counters and All Instances)
k. SQLServer:General Statistics (All Counters)
l. SQLServer:General Latches (All Counters)
m. SQLServer:General Locks (All Counters and All Instances)
n. SQLServer:General Memory Manager (All Counters)
o. SQLServer:General Plan Cache (All Counters and All Instances)
p. SQLServer:General Transactions (All Counters)
q. SQLServer:General Wait Statistics (All Counters and All Instances)
r. Thread (All Counters and All Instances)


Jonathan


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?


.

Relevant Pages

  • Re: Large Memory Footprint for Simple .NET Apps
    ... Memory counters have a name,f.i.Taskmanager shows 'Mem Usage' and 'VM Size' ... The Performance monitor has a whole bunch of named Memory ... > the Task Manager. ...
    (microsoft.public.dotnet.general)
  • Re: Lock-free reference counting
    ... adjacent in memory to the object they count. ... thoughout memory, but in every case, their counters are adjacent. ... Even swapping a pair of reference counted smart pointers in an array over ...
    (comp.programming)
  • Re: Allocated memory alerts and changed threshold still doesnt si
    ... When I add the other counters I get a ... I understand that you receive performance alert emails ... know, SBS is a higher integrated Server including Exchange, SQL and ISA. ... have to check which process used high CPU and Memory utilization. ...
    (microsoft.public.windows.server.sbs)
  • Re: Windows Server 2008 Memory Questions
    ... One of the counters I was running (I think it ... The memory utilization is running in the high 90's. ... logical drives c=system partition, d=store, ... We have had some outlook users complain about slow response time (not ...
    (microsoft.public.windows.server.general)
  • Re: VERILOG and VHDL
    ... For more sophisticated counters ... configuration memory which means the programmed device is 'stand alone'. ... Altera do produce chips which have both the Flash ... and boot loader integrated in one device but these work out much more ...
    (sci.electronics.design)