Performance Monitors in SQL 2005

  • There are two system tables/view which provide perfmonitoring info: [select

    * from sys.dm_os_performance_counters] and [select * from sys.sysperfinfo]. These both appear to return the same data, and have the same column structures. First: does it make any difference whatsoever which call is used? Secondly, does anyone know how these tables are populated? (eg, is the data refreshed only when a query is run against them?, or is SQL Server actually grabbing 'live' data and stats from PerformanceMonitor?) My reason for the second question is -- obviously -- I want to make sure I've got up-to-date readings on my selected monitors.

    Joseph

    Adam: I'm using both since we are in transition from 2000 to 2005, and will be for some time. I appreciate the 'knowledge' you supply ... wouldn't happen to know where I can 'document' that for my supervisor, would you? If not ... thanks much for the information!

     

  • sys.dm_os_performance_counters is the dynamic management view that replaces sysperfinfo.  sysperfinfo is there for backwards compatibility (since that's all there was in SQL 2000).  Use the DMV going forward. 

    As for the data being updated, it reflects the real time stats. 

     



    A.J.
    DBA with an attitude

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

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