Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.
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.