Skip to content

sys.dm_os_performance_counters: Part 3

August 27, 2009

5. Cntr_Type = 1073874176

This last counter type is the trickiest of all, as it combines properties of the previous two types. It is both cumulative, similar to 272696576 and a ratio, similar to 537003264. To get the true value for one of these counters, you need to poll both the counter value and the base value (counter type 1073939712), wait, then poll both again and divide the differences between the two counters to get the final result.

For example … let’s say that at the first poll you measure counter value cv1 and base value bv1. Wait 15 seconds, and poll both again to obtain counter value cv2 and base value bv2. To get the true counter value in a measure of units per second, use this formula:

UnitsPerSec = (cv2 – cv1) / (bv2 – bv1) / 15.0

Advertisements

From → PerfCounter DMV

Comments are closed.

%d bloggers like this: