on May 8, 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 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.