Post reply

SQL Table to get system or memory page lock counters

  • February 5, 2015 at 3:10 am

    #314922

    Hi Guys,

    As we know the sys.dm_os_performance_counters is limited to SQL Server counters, so if you want system,

    physical disk, network interface card, etc. you need to run performance monitor to capture these counters.

    So I just want to know there is any work around to get these counter values using the sql sys tables or joining

    couple of OS related DMVs

    For example what all sql DMV or sys tables we can refer to get values for below few system counters with out using permon

    \Memory \Available Bytes

    \Processor(*)\% Processor Time

    Pages / sec

  • April 17, 2015 at 8:25 am

    #1791700

    This might have good information of where to start trying to find this information.

    <Download SQL Server 2008 System Views Map from Official Microsoft Download Center>

    http://www.microsoft.com/en-us/download/details.aspx?id=9301

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]

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

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