Home Forums SQL Server 2014 Administration - SQL Server 2014 any way get get buffer cache hit ratio without usage dm_os_performance_counters RE: any way get get buffer cache hit ratio without usage dm_os_performance_counters

  • August 16, 2017 at 7:55 am

    #1955490

    tazzman - Wednesday, August 16, 2017 4:17 AM

    You can also collect values directly from windows performance monitor: https://www.red-gate.com/simple-talk/sql/performance/collecting-performance-data-into-a-sql-server-table/

    It could probably be used as a test to make sure it's an issue with the counters, which seems highly likely.
    If the counters didn't load for whatever reason, they would be missing from both PerfMon and sys.dm_os_performance_counters since both use the server counters to get the data.

    Sue