Database Health Monitor

Who Gets SQL Server Email? Nobody Can Tell You

Who gets SQL Server email? Operators are only part of the answer. Learn how to find every address, the leavers and the dead mailboxes.

Is this index still used? A lifetime read count cannot say. Here is how a per-index trend line catches an index that went silent weeks… Read More »Is This Index Still Used? Read the Trend, Not the Total

Most SQL Server maintenance window schedules are typed in once and never checked. Here is how to measure the quiet hours instead of guessing at… Read More »Your SQL Server Maintenance Window Is a Guess. Measure It

Why is one execution plan slower than another for the same SQL Server query? See which Query Store measures explain the gap, not just duration.

See offline database files, growth settings, and volumes for every database on an instance, even ones that are offline, restoring, or suspect.

A password protected SSIS package can stall a migration for days. Here is how to find every one hiding inside msdb first.

A management data warehouse can stop updating while its Agent jobs still show green. Here’s where SQL Server keeps the real failure text.

SQL Server index health is more than a fragmentation percentage: one score with its reasons, backed by ten indexing reports rolled into cards.

SQL Server index fragmentation percentage can be misleading. Here is the number that actually predicts what a rebuild will buy you, and where to find… Read More »SQL Server Index Fragmentation: Stop Chasing the Percent

SQL Server LOB columns in indexes duplicate data on disk. Here’s how to find every one, measure the cost, and know which are safe to… Read More »SQL Server LOB Columns in Indexes Are Costing You Disk