↓ Skip to Main Content

Database Health Monitor

Main Navigation

  • Home
  • SQL Consulting
    • SQL Server Health Check Report
  • SQL Performance Tuning
    • Performance Tuning SQL Server PDF
    • SQL Server Performance Monitor Tool
    • SQL Server Performance Tips
    • Types of Performance Tuning in SQL Server
  • Download
    • Buy
    • Frequently Asked Questions
    • Pricing
    • Release Notes
    • SchemaDrift Download
    • Support Request
    • Survey
  • Database Health Reports
    • Webinar Training Events
    • Command Line Parameters
    • Product Registration
    • Request a Feature
      • Requested Features
    • SQL Server Email Alerting
    • Submit Bug Report
    • SchemaDrift
    • Tech Debt
      • Object Selector
      • Settings Dialog
      • Technical Debt Object Viewer
      • Technical Debt Overview
        • = NULL Should Be IS NULL
        • Columns missing table reference
        • Cursor In Stored Procedure
        • Keywords Not Uppercase
        • Line Too Long
        • NOLOCK Hint
        • Stored Procedure Length Exceeds Threshold
        • Using Old Join Syntax
    • Registration Form
  • Wait Monitoring
    • Configure Historic Database Connection
    • Historic Waits
      • Historic Waits Advisor
        • PAGELATCH_UP
    • What is your baseline?
  • Server Overview
    • SQL Server Quick Scan Report
      • Command Log Cleanup
      • Database Health Monitor Log File Size
      • Default Location on the C Drive
      • Default Maintenance Plans
      • Disabled Indexes
      • Fill Factor
      • Linked Server with No Data Access
      • Locks Set To Something Besides 0
      • Memory Dumps
      • Not Using TDE
      • Quick Scan Report – Alerts
        • Database Mail Agent Notifications
        • Merge Replication Conflicts
      • Quick Scan Report – Backup Messages In Log
      • Quick Scan Report – Backup To NUL
      • Quick Scan Report – Backups On the Same Drive As Your Database
      • Quick Scan Report – CHECKSUM on backups
      • Quick Scan Report – Cost Threshold For Parallelism
      • Quick Scan Report – Database Auto Close
      • Quick Scan Report – Database Ownership
      • Quick Scan Report – DBCC CheckDB Never Run
      • Quick Scan Report – DBCC CheckDB Not Run Recently
      • Quick Scan Report – Error Log
        • Slow Error Log Access
      • Quick Scan Report – Error Log Retention
      • Quick Scan Report – Excessive Backup History
      • Quick Scan Report – Excessive Log Shipping History
      • Quick Scan Report – Extended Backup History
      • Quick Scan Report – Extended Sysmaintplan_logdetail
      • Quick Scan Report – Failed Database Mail
      • Quick Scan Report – File Growth Too Small
      • Quick Scan Report – High VLF Count
      • Quick Scan Report – Job Without Failure Notify
      • Quick Scan Report – Leftover DTA Tables
      • Quick Scan Report – Log File Slow IO
      • Quick Scan Report – Log Files Larger Than Database
      • Quick Scan Report – Master Database Not in Simple Recovery Mode
      • Quick Scan Report – Max Degree Of Parallelism
      • Quick Scan Report – Max Server Memory
      • Quick Scan Report – Missing Primary Keys
      • Quick Scan Report – No Database Owner
      • Quick Scan Report – No Recent Backups
      • Quick Scan Report – Not Using Compressed Backups
      • Quick Scan Report – Obsolete Torn Page Detection
      • Quick Scan Report – Optimize for Ad Hoc Workloads
      • Quick Scan Report – Orphan Database Users
      • Quick Scan Report – Percent Autogrowth Enabled
      • Quick Scan Report – Percent Growth
      • Quick Scan Report – Power Settings
      • Quick Scan Report – Priority Boost
      • Quick Scan Report – Remote DAC
      • Quick Scan Report – Server Side Trace Running
      • Quick Scan Report – Slow Disk Reads
      • Quick Scan Report – SQL Agent Not Running
      • Quick Scan Report – SQL Server 2005 End of Life
      • Quick Scan Report – TempDB on Same Drive As Data Files
      • Quick Scan Report – TempDB on the C Drive
      • Quick Scan Report – TempDB only has a single data file
      • Quick Scan Report – TempDB Showing Growth
      • Quick Scan Report – User Databases on C Drive
      • Quick Scan Report – User Tables In master
      • Quick Scan Report – User Tables in MSDB
      • Quick Scan Report – Using obsolete TORN_PAGE_DETECTION
      • Quick Scan Report – Version Updates Available
        • SQL Server 2005 Version Numbers
        • SQL Server 2008 Version Numbers
        • SQL Server 2008R2 Version Numbers
        • SQL Server 2012 Version Numbers
        • SQL Server 2014 Version Numbers
        • SQL Server 2016 Version Numbers
        • SQL Server 2017 Version Numbers
        • SQL Server 2019 Version Numbers
        • SQL Server 2022 Version Numbers
      • Quick Scan Report – xp_sqlmaint
      • Quick Scan Report – Agent Job Active But Not Scheduled
      • Quick Scan Report – Agent Jobs that Run at Startup
      • Quick Scan Report – Auto Create Statistics Not Enabled
      • Quick Scan Report – Backup Without Checksum
      • Quick Scan Report – Backups to an unusual location
      • Quick Scan Report – Dangerous Versions of SQL Server
      • Quick Scan Report – Database Mail Not Configured
      • Quick Scan Report – Database Snapshots
      • Quick Scan Report – Deadlocks
      • Quick Scan Report – Error Log Maximum Size
      • Quick Scan Report – Failed SQL Server Agent Jobs
      • Quick Scan Report – Full or Bulk Logged Recovery Model with No Backups
      • Quick Scan Report – Large Differentials
      • Quick Scan Report – Large Error Log Files
      • Quick Scan Report – Lightweight Pooling
      • Quick Scan Report – Login With Bad Default Database
      • Quick Scan Report – Low Disk Space
      • Quick Scan Report – Missing Backup Files
        • Grandfather-Father-Son Backup Strategy
      • Quick Scan Report – More Than One Instance
      • Quick Scan Report – Multiple Log Files
      • Quick Scan Report – No Operators
      • Quick Scan Report – Not Using All Cores
      • Quick Scan Report – Page Verify Options
      • Quick Scan Report – Reindexing During the Day
      • Quick Scan Report – Resource Governor Configuration
      • Quick Scan Report – Running at older compatibility level
      • Quick Scan Report – SERIALIZABLE ISOLATION LEVEL
      • Quick Scan Report – SQL 2008 and SQL 2008 R2 End of Life
      • Quick Scan Report – SQL Express Approaching File Limitation
      • Quick Scan Report – SQL Server Express Edition
      • Quick Scan Report – SQL Server Recent Restart
      • Quick Scan Report – TDE Certificate Backups
      • Quick Scan Report – TempDB Slow IO
      • Quick Scan Report – Too Many Log Files
      • Quick Scan Report – UPDLOCK Hint
      • Quick Scan Report – User Tables in Model
      • Quick Scan Report – User-Defined Assemblies
      • Replication Synchronization Delay
      • Service Broker Not Enabled for MSDB
      • SQL Agent Hot Spot
      • SQL Express Core Limit
      • SQL Server 2012 End of Life
      • SQL Server Agent Jobs and Schedules
      • SQL Server running as local system and not a domain or local user
      • SQL Server Standard Edition Core Limit
      • TempDB Sized Differently
      • Understanding SQL Server Backups: When to Perform Full Backups
      • Untrusted Foreign Keys
    • Connections By Database
    • Logins
    • Monitoring TempDB
    • Page Reads By Database
    • Page Writes By Database
    • Performance Dashboard
    • Performance History
      • Understanding SQL Batch Requests
      • Understanding SQL Cache Hit Ratio
      • Understanding SQL Compilations
      • Understanding SQL Deadlocks
      • Understanding SQL Memory Grants Pending
      • Understanding SQL Page Life Expectancy
      • Understanding SQL Page Lookups
      • Understanding SQL Page Reads
      • Understanding SQL Page Writes
      • Understanding SQL Recompilations
      • Understanding SQL Server Transactions per Second
      • Understanding SQL Target Memory
      • Understanding SQL Total Memory
    • Plan Cache By Database
    • Queries Needing Params By Database
    • Waits by Type
      • ASYNC_IO_COMPLETION Wait
      • ASYNC_NETWORK_IO Wait
      • BACKUPBUFFER Wait
      • BACKUPIO Wait
      • BACKUPTHREAD Wait
      • CLR Wait Types
      • CXPACKET and CXCONSUMER Wait
      • HADR_FILESTREAM_IOMGR_IOCOMPLETION
      • HADR_SYNC_COMMIT wait type
      • IO_ Waits
        • IO_COMPLETION Wait
      • LATCH_EX Wait
      • LCK_M_ Waits
        • LCK_M_IX Wait Type
        • LCK_M_X Wait Type
      • LCK_M_S Wait
      • OLEDB Wait
      • PAGEIOLATCH Wait
      • PAGEIOLATCH_EX wait type
      • PAGELATCH_EX Wait Type
      • PARALLEL_REDO_WORKER_WAIT_WORK
      • PREEMPTIVE Waits on SQL Server
        • PREEMPTIVE_OLEDBOPS
        • PREEMPTIVE_OS_COMOPS Wait
        • PREEMPTIVE_OS_GETPROCADDRESS wait type
        • PREEMPTIVE_XE_DISPATCHER
      • PREEMPTIVE_OS_PIPEOPS Wait type
      • PREEMPTIVE_OS_QUERYREGISTRY
      • QDS_ASYNC_QUEUE
      • QDS_SHUTDOWN_QUEUE Wait Type
      • RESOURCE_SEMAPHORE Wait
      • RESOURCE_SEMAPHORE_QUERY_COMPILE
      • Scheduler Wait Types
        • SOS_SCHEDULER_YIELD
      • Service Broker Wait Types
        • BROKER_EVENTHANDLER Wait
      • SOS_WORK_DISPATCHER Wait
      • SQLTRACE Waits
        • TRACEWRITE Wait
      • WRITELOG Wait
      • Wait Types to Ignore
    • SQL Server Instance Level Reports
      • Backup Status
        • Backup History in SQL Server
        • Script to Check Backup Status in SQL Server
      • Blocking By Hour of Day
      • Configuration Values
      • CPU Used By Database
      • Databases by Size
      • DBCC CheckDB Last Known Good
        • CheckDB Advisor
      • Deadlocks
        • Deadlocks Advisor
      • Deadlocks by Database
      • Disk Latency by Hour
      • Disk Space
      • Email Alert Log
      • Failed Jobs
      • File Utilization Report
      • I/O by Database
      • I/O By Drive
      • Index LOB Columns Report
      • Inventory
      • Job History
      • Job Schedule
      • Linked Servers
      • Memory Used By Database
      • Replication Publishers and Subscribers
      • Schema Search Report
      • Security
      • Sessions by DB Name
      • Sessions by Login
      • SQL CPU by Hour of Day
      • SQL CPU Schedulers
      • Trace Flags Report
      • Upgrade Recommendations
      • What is Active
      • Error Log Report
      • Suspect Pages Report
  • Database Overview
    • Database Warnings
      • AutoShrink Set to On
      • Data Or Log On C Drive
      • Database Collation Does Not Match TempDB Collation
      • Low Cache Hit Ratio
      • msdb.dbo.backupset Slow (msdb..backupset)
      • No full backups in 24 hours
      • Obsolete Page Verify Option
      • Unusually Large Log File
      • Veeam Stomping on SQL Backups
    • Active Queries
    • Backups
      • Backup Advisor
    • Big Clustered Indexes
    • Blocking Queries
    • Connections
      • Connections Advisor
    • CPU By Query
      • CPU By Query Advisor
    • Database Overview Reports
      • Page Reads by Query
      • Page Writes by Query
      • Stored Procs by Logical Writes
      • Table Use Report
      • TDE Status Report
    • Deadlock History for Database
    • Deadlocks By Hour For Database
    • Deadlocks by Object
    • Duplicate Indexes
      • Duplicate Indexes Advisor
    • Files Report
    • Identity Column Usage
    • Inefficient Indexes
    • IO by Hour by Day
    • LOB Column Indexes
    • Long Running Queries
      • Long Running Queries Advisor
    • Missing Indexes
      • Cardinality Report
      • Missing Index Advisor
    • Most Used Indexes
    • One Time Use Queries
      • One Time Use Queries Advisor
    • Partitioned Tables
    • Plan Cache
    • Queries Needing Params
      • Queries Needing Params Advisor
    • Query Advisor
    • SQL Index Fragmentation Report
      • Deep Dive into Fragmentation in SQL Server
      • Fragmentation In SQL Server
      • Fragmented Index Advisor
      • Index Defragmentation Script
      • TSQL To Find Fragmented Indexes
    • SQL Virtual Log Files (VLFs)
    • Statistics
      • Statistics Advisor
    • Table Sizes
      • Table Size Advisor
    • Tables With Triggers
    • TEMPDB High Use
    • TempDB Use By Hour By Day
    • Unclustered Tables
    • Unused Indexes
      • Indexing Overview
      • Unused Indexes Advisor
  • Blog Posts
    • Blog – Archive by Month
    • Blog Archive by Year
    • Blog Calendar
    • SQL Server Monitoring Videos
  • About
    • Data Transmission
    • Feedback Survey
    • Licensing Agreement
    • Need Help with Database Health Monitor
    • Privacy Policy
    • Raving Fans
    • Steve Stedman
    • Shared Scripts
    • Tips
      • Free 90 Day Trial
      • Instant File Initialization (IFI)
        • Database Instant File Initialization
        • Perform Volume Maintenance Tasks
      • No tempdb Backups
      • Removing the Monitoring Database
      • SQL Server Compatibility Levels Requirements
      • User Permissions

Blog Archive by Year

  • Blog – Latest
  • Archive by Month
  • Archive by Year
  • Calendar
  • Stedman Solutions
  • 2025 (75)
  • 2024 (172)
  • 2023 (23)
  • 2019 (1)

Database Health Monitor May 2025 Release

May 2025 Version

Now Available

The May 2025 Database Health Monitor Version 1139 is available on the download page.

Licensing Options Explained
Stedman Solutions Services

Quick Scan Report Links

  • Alerts
  • Backup Messages In Log
  • Backups On the Same Drive As Your Database
  • CHECKSUM on backups
  • Cost Threshold For Parallelism
  • Database Auto Close
  • DBCC CheckDB Never Run
  • DBCC CheckDB Not Run Recently
  • Error Log
  • Excessive Backup History
  • Extended Backup History
  • Extended Sysmaintplan_logdetail
  • Failed Database Mail
  • Full or Bulk Logged Recovery Model with No Backups
  • Log File Slow IO
  • Log Files Larger Than Database
  • Master Database Not in Simple Recovery Mode
  • Max Degree Of Parallelism
  • Max Server Memory
  • No Database Owner
  • No Recent Backups
  • Not Using Compressed Backups
  • Obsolete Torn Page Detection
  • Optimize for Ad Hoc Workloads
  • Orphan Database Users
  • Percent Autogrowth Enabled
  • Percent Growth
  • Priority Boost
  • Remote DAC
  • Slow Disk Reads
  • SQL Agent Not Running
  • TempDB on Same Drive As Data Files
  • TempDB on the C Drive
  • TempDB only has a single data file
  • TempDB Showing Growth
  • User Databases on C Drive
  • Using obsolete TORN_PAGE_DETECTION
  • Version Updates Available
    • SQL Server 2005 Version Numbers
    • SQL Server 2008 Version Numbers
    • SQL Server 2008R2 Version Numbers
    • SQL Server 2012 Version Numbers
    • SQL Server 2014 Version Numbers
    • SQL Server 2016 Version Numbers
  • Quick Scan Report – TempDB Slow IO
Copyright © 2025 Database Health Monitor | Powered by Responsive Theme
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
SettingsAccept
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT

Getting Help from Steve and the Stedman Solutions Team

We are ready to help. Steve and the team at Stedman Solutions are here to help with your SQL Server needs. Get help today by contacting Stedman Solutions through the free 30 minute consultation form.

Contact Info for Stedman Solutions, LLC.
PO Box 3175, Ferndale WA 98248, Phone: (360)610-7833
Our Privacy Policy