Performance counter types

Learning about Performance Counters

How do you interpret the value you get back for any particular performance counter?

Here’s a way to look at performance counter at the server level, which is easier to comprehend, by labeling their “cntr_type”

http://madebysql.blogspot.com/2011/01/how-to-use-performance-counters-in.html

http://troubleshootingsql.com/2011/03/03/what-does-cntr_type-mean/

 

select object_Name, counter_Name, Instance_name, cntr_value,

case cntr_type

when 537003264 then ‘BASE_divide by’

when 1073874176 then ‘BASE_divide by’

when 1073939712 then ‘BASE divide into’

when 65792 then ‘PointInTime’

when 65536 then ‘PointInTime’

when 272696576 then ‘PerSec cumulative get comp’

else convert(varchar(200),cntr_type) end as Cntr_Type

from sys.dm_os_performance_counters

where object_name <> ‘MSSQL$I1A:Databases’ and

object_name <> ‘MSSQL$I1A:Broker Activation’ and

object_name not like ‘MSSQL$I1A:catalog metadata%’ or

(object_name like ‘MSSQL$I1A:Catalog Metadata%’ and instance_name = ‘_Total’) or

(object_name like ‘MSSQL$I1A:Broker Activation%’ and cntr_value <> 0)

order by object_name, cntr_type

Leave a Reply

Your email address will not be published.