Am I interpreting perfmon counter values properly? (SQL server)
Was hoping soemone might tell me if I'm interpreting this perfmon graph properly,
as it related to SQL server counters..
In the following graphic, you can see the 2 counters I'm capturing, for purposes of seeing SQL server I/O for Reads/Writes needing to go to Disk, instead of getting them from buffer memory.
My question is, since I've set the vertical scale to 100, and the counters are both displaying in ms, is it correct to say the Avg Disk sec/Write(in RED) is mostly
staying below 10ms?
and the Reads(in BLUE) are mainly above 10ms, even going off the chart a few times..?
In this
as it related to SQL server counters..
In the following graphic, you can see the 2 counters I'm capturing, for purposes of seeing SQL server I/O for Reads/Writes needing to go to Disk, instead of getting them from buffer memory.
My question is, since I've set the vertical scale to 100, and the counters are both displaying in ms, is it correct to say the Avg Disk sec/Write(in RED) is mostly
staying below 10ms?
and the Reads(in BLUE) are mainly above 10ms, even going off the chart a few times..?
In this
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Actually those counters show values in Seconds in millisecond precision and because the values can be between 1 millisec and 10 000 millisec (10 seconds) so displaying it in a linear scale is almost impossible.
So you should use another counter: https://blogs.technet.micr
So you should use another counter: https://blogs.technet.micr
ASKER
here's what those counters look like.. any thoughts?
why does the read counter appear to go downward?
and are they both well over the 1 or 2 you mentioned, much of the time?
why does the read counter appear to go downward?
and are they both well over the 1 or 2 you mentioned, much of the time?
If you're trying to analyze a disk performance I would recommend you to check the %Disk Time (% Disk Read Time, % Disk Write Time) counters. The returned values will be more easy to read as they are percentages, so between 0 and 100.
Capture also the Disk Transfers/sec (Disk Reads/sec, Disk Writes/sec) counters. Together with the %Disk Time, you should have a better look of the disk performance.
ASKER
sigh..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks fellas.
ASKER
Can we then focus on the question of graph / scale/ interpretation?
To restate even more plainly: how can I best display the graph to show counters that
output in milliseconds, where I'm looking to show say, values from 0 to 100ms?