Performance

Confused about what kind of performance counter you have…
SELECT [counter_name] AS ‘Description’
, [cntr_value] AS ‘Current Value’,
case cntr_type
when 537003264 then ‘curOFbase’
when 1073939712 then ‘BASE’
when 65792 then ‘PointInTime’
when 272696576 then ‘BySecNeed2’
else ‘unk’ end
from sys.dm_os_performance_counters

Leave a Reply...Really! I'll listen!