Post reply

sys.dm_os_performance_counters

  • June 10, 2011 at 12:20 am

    #239716

    In sql server there is a dmv, called sys.dm_os_performanceh _counters

    I know if I set up a performance counter then it will record the activity.

    But how is the counter set up? is it like SQL server defaut trace?

    It runs automatically in background by design?

  • June 10, 2011 at 4:07 am

    #1336865

    those counters can be accessed through TSQL Queries. There is no set-up required. The Windows OS is maintaining that data for you all the time. Running the query simply accesses what is already there.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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