Extended Events (XEvents)
Production-grade reference for SQL Server Extended Events — lightweight, highly-scalable event-driven diagnostics replacing legacy SQL Trace and Profiler. Configure event sessions, capture deadlock graphs, monitor query performance, and build wait statistics pipelines.
Capture real-time query execution performance metrics using the sp_statement_completed Extended Event — duration, CPU, reads, writes, and row counts for every completed statement within a stored procedure or batch.
Comprehensive reference on SQL Server's built-in system_health Extended Events session — how to query, interpret, and export session data for root-cause analysis of critical server events.
Architect a high-precision wait statistics monitoring pipeline using Extended Events — capture wait_type, wait_time, and blocking_session_id at per-wait granularity without the overhead of sys.dm_os_wait_stats polling.
Production-grade techniques for capturing, querying, and analyzing SQL Server deadlock graphs using the xml_deadlock_report Extended Event, including system_health extraction and dedicated event session setup.