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.

Previous Post
Should I Get Certified as a DBA? (Dear SQL DBA Episode 41)
Next Post
Batch Mode Hacks in SQL Server (Dear SQL DBA Episode 42)

Related Posts

No results found

1 Comment. Leave new

  • […] 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… […]

    Reply
  • Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Menu