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

Load

High availability

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.

Other engines