↓ Skip to Main Content

Secondary Navigation

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
    • Support Request
    • Survey
  • Database Health Reports
    • Webinar Training Events
    • Command Line Parameters
    • Product Registration
    • Request a Feature
      • Requested Features
    • 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
      • Agent Jobs that Run at Startup
      • Auto Create Statistics Not Enabled
      • Backup Without Checksum
      • Backups to an unusual location
      • Dangerous Versions of SQL Server
      • Database Health Monitor Log File Size
      • Database Mail Not Configured
      • Default Maintenance Plans
      • Fill Factor
      • Full or Bulk Logged Recovery Model with No Backups
      • Login With Bad Default Database
      • Missing Backup Files
        • Grandfather-Father-Son Backup Strategy
      • More Than One Instance
      • Multiple Log Files
      • No Operators
      • Not Using All Cores
      • Quick Scan – Large Error Log Files
      • Quick Scan – SQL Express Approaching File Limitation
      • Quick Scan Report – Alerts
        • Database Mail Agent Notifications
      • 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 – 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
      • Quick Scan Report – xp_sqlmaint
      • Quick Scan Report – TempDB Slow IO
      • Resource Governor Configuration
      • Running at older compatibility level
      • SERIALIZABLE ISOLATION LEVEL
      • SQL 2008 and SQL 2008 R2 End of Life
      • SQL Agent Hot Spot
      • SQL Server 2012 End of Life
      • SQL Server Agent Jobs and Schedules
      • SQL Server Logs – maximum size
      • SQL Server running as local system and not a domain or local user
      • TDE Certificate Backups
      • TempDB Sized Differently
      • Too Many Log Files
      • Understanding SQL Server Backups: When to Perform Full Backups
      • Untrusted Foreign Keys
    • Connections By Database
    • CPU Used By Database
    • Memory Used By Database
    • 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
    • TempDB Use By Hour By Day
    • Waits by Type
      • RESOURCE_SEMAPHORE_QUERY_COMPILE
      • 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
      • 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 Report
        • Script to Check Backup Status in SQL Server
      • Blocking By Hour of Day
      • Databases by Size
      • DBCC CheckDB Last Known Good
        • CheckDB Advisor
      • File Utilization Report
      • I/O by Database
      • I/O By Drive
      • Linked Servers
      • Schema Search Report
      • SQL CPU by Hour of Day
      • SQL CPU Schedulers Report
      • SQL Virtual Log Files (VLFs)
      • Trace Flags Report
      • 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
    • Duplicate Indexes
      • Duplicate Indexes Advisor
    • Files Report
    • Identity Column Usage
    • Inefficient Indexes
    • Long Running Queries
      • Long Running Queries Advisor
    • Missing Indexes
      • 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
    • Statistics
      • Statistics Advisor
    • Stored Procs by Logical Writes
    • Table Sizes
      • Table Size Advisor
    • Tables With Triggers
    • Unclustered Tables
    • Unused Indexes
      • 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
    • 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

Feedback Survey

Please help us by completing our survey about Database Health Monitor.

Quick Database Health Monitor Survey.

 

 

Database Health Monitor December 2024 Release

December 2024 Version

Now Available

The December 2024 Database Health Monitor Version 1080 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 © 2024 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