Baseline Archives - SQL Server Science

Home » Baseline

Performance Counters Over Time: Making sys.dm_os_performance_counters Tell the Truth

2026-06-26 · by Hannah Vernon · in performance

Run this query on any SQL Server and look at the number it gives you for Batch Requests/sec:

SELECT
      [counter_name]
    , [cntr_value]
FROM
    [sys].[dm_os_performance_counters]
WHERE
    [counter_name] = N'Batch Requests/sec';

SELECT

[counter_name]

, [cntr_value]

FROM

[sys].[dm_os_performance_counters]

WHERE

[counter_name] = N'Batch Requests/sec';

On a server that has been up for a few weeks you will get something like…