How to Trace Trigger Executions with Query Store and Extended Events
Triggers can be tricky to observe in SQL Server. When you need to understand exactly what a trigger is doing and what it impacts, Query Store and …
Read MoreSQLServer:Databases(_Total)\Transactions/sec vs SQL Statistics\Batch Requests/sec (video)
Category:
query-performance
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.
RELATED POSTS
