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

Leave a Reply

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

Menu