SQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)

Perfmon counters are great for measuring workload, but choosing which counter to baseline can be confusing.

The Transactions/sec counter has big blind spots

Watch a quick 5 minute demo showing that the SQL Statistics\Batch Requests/sec counter sees more of your workload than the Databases(_Total)\Transactions/sec counter does.

Want more perfmon tips for SQL Server?

Check out my YouTube playlist of perfmon tips here.

Trackbacks/Pingbacks

  1. SQLServer:Databases(_Total)Transactions/sec vs SQL StatisticsBatch Requests/sec (video) – SQLServerSource.com - May 9, 2017

    […] Perfmon counters are great for measuring workload, but choosing which counter to baseline can be confusing. The Transactions/sec counter has big blind spots Watch a quick 5 minute demo showing that the SQL StatisticsBatch Requests/sec counter sees more of your workload than the Databases(_Total)Transactions/sec counter does. Want more perfmon tips for #SQLServer? Check out my YouTube […] #Performance #Statisticshttps://littlekendra.com/2017/05/08/sqlserverdatabases_totaltransactionssec-vs-sql-statisticsbatch-r… […]

Leave a Reply