Dynamic management views for performance monitoring

  • 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!

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply