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 …
SQLServer: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
