August 21, 2008 at 6:35 am
Hi, world:
I'm investigating about monitoring SQL 2005 Performance using Dynamic Management Views and I have found a problem.
I think that sys.dm_os_performance_counters would be a good approach in order to obtain daily statistics for my server's performance, and it looks well. But I don't know what are the meanings of the distinct values of the cntr_type column, and I think that they are important in order to well-understand the value of the column cntr_value.
Can anybody tell me where I could find the meaning of the distinct values of the cntr_type column?
Thanks in advance for you help!
August 21, 2008 at 7:33 am
You may be better off monitoring that via perfmon. The os_performance_counters in the table version of all the counters that SQL Server exposes to perfmon. The counters are better explained through the perfmon interface, as there's an 'Explain' button available that shows a short description of each one.
You probably shouldn't monitor allof the counters. It's information overload. Pick the ones that are meaningful and monitor those.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply