Health Check

SQL Server Tool: Check Your SQL Server Health

sp_CheckHealth

Coming soon!

Checks Performed

Alerts

Auto close

Auto create statistics

Auto shrink

Backup history not purged

Change Data Capture

Change Tracking

Compatibility level

Cost threshold for parallelism

Database corruption

Database file growth

Database files best practice

Database log file size

Database offline

Database page verification

Database snapshot

Database with multiple log files

Default file path

Delayed durability

Evaluation Edition

Extended events

Forced parameterization

Instance configuration

Instant File Initialization

Lock pages in memory

Max degree of parallelism

Memory best practices

Memory dumps

Missing integrity checks

Number of SQL Server error log files

Offline CPU schedulers

Power plan

Recursive triggers

Replication

Resource Governor

Server level triggers

SQL Agent job schedule

SQL Agent offline

SQL Server has been online for over 180 days

Suspect status

Trace flags

Unsupported versions and builds

Unusual database state

Virtual log files

Sign Up for Updates

Sign up for our newsletter to receive updates about new blog posts, webinars, DBA tools, and more.