Monday, February 20, 2012

performance monitoring

i m performing performance testing of application which uses SQL server as backend. can any body say what all the things we basically monitor while we do performance monitoring? As of now sql server shows instantaneous spike in cpu utilization.I m looking for what all things we need to monitor so that we can pinpoint the problem in increase in CPU utilization!can any tell me?Hi,
Have a look into the below link to get the useful performance monitor
counters to identify the bottleneck:-
http://www.computerperformance.co.uk/HealthCheck/SQL.htm
Thanks
Hari
MCDBA
"Sham" <Sham@.discussions.microsoft.com> wrote in message
news:D3BFB6EF-479B-479E-A774-C9AFE184DBD5@.microsoft.com...
> i m performing performance testing of application which uses SQL server as
backend. can any body say what all the things we basically monitor while we
do performance monitoring? As of now sql server shows instantaneous spike in
cpu utilization.I m looking for what all things we need to monitor so that
we can pinpoint the problem in increase in CPU utilization!can any tell me?

No comments:

Post a Comment