How to Filter RPC_Completed Events in Extended Events: SQL Server Guide
The rpc_completed event in Extended Events is useful when troubleshooting SQL Server performance. It captures detailed information about Remote …
Perfmon: 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
