November 19, 2008 at 11:34 am
Hi, does anybody have any information on Counters and Objects to be measured using System Monitor? I'm looking for information on essential metrics like:
Memory, Processor, Disk, and SQL Objects/Counters
Which counters are essential to measure, and more specific what are out of range measurements, ie CPU utilization above 60%, etc. for each Object/Counter that could indicate a problem?
Thanks!
November 19, 2008 at 1:53 pm
There is no magic set or magic numbers on the counters. You will find all kinds of different articles about what values are valid. The real way is to baseline your system with acceptable performance and then track and trend changes to understand growth and future needs.
Some common counters.
Memory Pages Per Second (varies.. but less then 20)
Disk Queue Lenght (Under 2 per disk)
% Processor Time (80% or less)
Buffer Cache Hit Ratio (98% or better)
Disk Writes /Read (depends on drive array, type, size, etc)
Microsoft has some documentation on this with suggested values.
November 22, 2008 at 6:30 am
Go to Control Panel, Administrative Tools, Performance, System Moniter
Three types of reports, graph, histogram, report
Memory Pages Per Second (varies.. but less then 20)
Disk Queue Lenght (Under 2 per disk)
% Processor Time (80% or less)
Buffer Cache Hit Ratio (98% or better)
Disk Writes /Read (depends on drive array, type, size, etc)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply