FREE CHECKLIST
Get my free 25-point SQL Server Health Check Checklist and find out in minutes:
25 checks. One page. Find the gaps in your backups, integrity checks and performance settings in about 15 minutes.
You get a one-page, 25-point SQL Server Health Check Checklist as a PDF you can print or share with your team.
Backups & Recovery: 6 checks
Corruption & Data Integrity: 5 checks
Performance: 7 checks
Capacity & Configuration: 5 checks
Security & Monitoring: 2 checks
A simple scoring guide tells you whether your server is in good shape, has real gaps, or is at risk of an outage or data loss.
Most SQL Server outages and data loss events trace back to a handful of basics that were never checked: backups that were never test-restored, integrity checks that stopped running, a drive that quietly filled up, or settings left at their defaults. This checklist walks you through those basics in about 15 minutes.
You will check whether your backups can really get you back online and how long a recovery would take. You will confirm that DBCC CHECKDB, page verification and corruption alerts are in place. You will review the settings behind most slow queries, including memory, parallelism, tempdb, indexes and statistics. You will also spot disk space, growth and patching problems before they turn into an outage.
Use it on one server or on all of them. Check each item off, add up your score, and fix the backup and corruption items first.
Want the same checks done automatically? Database Health Monitor from Stedman Solutions is free to download, and our team can manage your SQL Servers for you.