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 MorePerfmon: Batch Requests/sec counts whole batches, not statements
Category:
perfmon
, sql-server
The name of the “SQL Statistics \ Batch Requests/sec” counter is confusing: exactly what is a request? The request is the WHOLE batch. See a demo of this counter in this quick 5 minute video.
Video Demo
RELATED POSTS
