Resources
SQL Server Problems, with the Query to Run and the Warning You Could Have Had
Each guide takes one problem that pages a SQL Server DBA: what the error says, the queries that show who or what caused it, the fixes in the order that does not make it worse, and how Radar Engine reports it before the error. The SQL runs on SQL Server 2017 or later with VIEW SERVER STATE.
Space
- Transaction log full: error 9002
The reason in log_reuse_wait_desc, the transaction or the replica that holds the log, and the fix for each reason. - tempdb full
Temp tables, spills or the version store: which of the three uses it, which session, and the fix without a restart.
Load
- Blocking: find the head blocker
The session at the head of the chain, what it holds, the sleeping session with an open transaction, and the fix in order. - Deadlocks: error 1205
The deadlock graphs the server already keeps, how to read one, the four usual patterns, and the fix for each.
High availability
- Always On availability group lag
The log send queue and the redo queue, what each one costs in a failover, and why a secondary falls behind.
Watch every instance for these
Scops runs 30 Radar detectors on every SQL Server instance and reports each of these problems while there is still time to act, with no agent on the server and a login that is not sysadmin. See SQL Server monitoring with Scops.