Investigate failed logins with the SQL Server error log and a focused Extended Events session, then group attempts and decide what to do.
Why Queries Recompile
Why queries recompile becomes clearer when you capture Extended Events causes and check schema changes, statistics, SET options, and temp tables.
Exchange Spill: When Parallel Streams Write to tempdb
Tempdb writes during a parallel query, with no sort warning in sight? Here is a demo that spills every time, and how to find the operator.
Intra-Query Parallel Deadlock: When One Query Blocks Itself
No error, no deadlock graph, just a report that is slow on some runs. Here is a demo where one query deadlocks with itself, and how to fix it.
Troubleshooting Cube Performance: Three Checks
Diagnose cube performance by comparing the same MDX query, processing changes and resource pressure before choosing a repair.
STARTUP_STATE: Check Whether an Extended Events Session Is Running
STARTUP_STATE controls automatic startup after SQL Server starts, while current session state tells whether an Extended Events session is running now. Compare both states and verify an event-file capture before assuming that a setting started the session.
Replaying a Production Workload After Distributed Replay
Capture a production workload with Extended Events and replay it on a restored copy using WorkloadTools or ostress after Distributed Replay.







