↓ Skip to Main Content
Database Health Monitor

Main Navigation

  • Home
  • SQL Consulting
    • SQL Server Health Check Report
  • SQL Performance Tuning
    • Load Testing with Query Loading Ramp
    • Performance Tuning SQL Server PDF
    • SQL Server Performance Monitor Tool
    • SQL Server Performance Tips
    • Types of Performance Tuning in SQL Server
  • Subscription Options
  • Download
    • Buy
    • Frequently Asked Questions
    • Pricing
    • Release Notes
    • SchemaDrift Download
    • Support Request
    • Survey
  • Database Health Reports
    • Webinar Training Events
    • Command Line Parameters
    • DBAssistant
    • Keyboard and Command Palette
    • Product Registration
    • Request a Feature
      • Requested Features
    • SQL Server Email Alerting
    • Submit Bug Report
    • Welcome Page
    • 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
    • Blocking by Hour by Day
    • Configure Historic Database Connection
    • CPU by Hour by Day
    • Deadlock Objects for a Database
    • Deadlocks by Hour
    • Disk Latency by Hour by Day
    • File Size Over Time
    • Historic Database Rebuild
    • Historic Waits
      • Historic Waits Advisor
        • PAGELATCH_UP
    • Long Running by Hour by Day
    • Long Running History
    • TempDB Use by Hour by Day
    • What is your baseline?
  • Server Overview
    • SQL Server Quick Scan Report
      • A data or log file cannot grow any further
      • A large heap is being updated
      • A transaction has been open far too long
      • Availability Group database is not healthy
      • Availability Group send or redo queue backlog
      • Command Log Cleanup
      • Database Connections As SA
      • Database Health Monitor Log File Size
      • Database is not online or not in multi user mode
      • Database set to Autoshrink
      • DBCC CHECKDB Corruption Errors Found
      • DBHealthHistory data file is too large
      • DBHealthHistory log file max size is too large
      • Default Location on the C Drive
      • Default Maintenance Plan Check Integrity Task
      • Default Maintenance Plan Defragment Index Task
      • Default Maintenance Plan Reindex Task
      • Default Maintenance Plan Shrink Database
      • Default Maintenance Plans
      • Disabled Indexes
      • Error log history in DBHealthHistory
      • Error Log Issues
      • Excessive sysmail_allitems
      • Failed login auditing is switched off
      • Historic monitoring referencing obsolete code
      • Large tables in DBHealthHistory database
      • Linked Server with No Data Access
      • Locks Set To Something Besides 0
      • Log shipping secondary is behind its threshold
      • Log truncation is blocked
      • Max degree of parallelism is higher than a NUMA node has cores
      • Memory Dumps
      • Memory grants are queuing
      • Not Enough Disk Space Leading to Restore Delays
      • Not Using TDE
      • Quick Scan Report – Alerts
        • Database Mail Agent Notifications
        • Merge Replication Conflicts
        • TempDB files too small.
        • TempDB with excessive files
      • 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
        • Quick Scan Report – Slow or No 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 – Data and Log Files on the Same Drive
      • 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 – Fill Factor
      • Quick Scan Report – Full or Bulk Logged Recovery Model with No Backups
      • Quick Scan Report – Instant File Initialization (IFI)
        • Database Instant File Initialization
        • Perform Volume Maintenance Tasks
      • 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 – Ola Scripts Installed but Not Running
      • 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 2012 End of Life
      • Quick Scan Report – SQL Server 2014 End of Life
      • 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 – TempDB Version Store Usage
      • 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
      • Remote Query Timeout Setting
      • Replication Synchronization Delay
      • Serious errors in log
      • Serious recent errors.
      • Service Broker Not Enabled for MSDB
      • SQL Agent Hot Spot
      • SQL logins with blank passwords or policy turned off
      • SQL Server 2019 Long Async API Call
      • SQL Server 2025 Version Numbers
      • SQL Server Agent Jobs and Schedules
      • SQL Server Express Core Limit
      • SQL Server running as local system and not a domain or local user
      • SQL Server Standard Edition Core Limit
      • SSIS Installed but not used
      • Suspected Corruption
      • TempDB Sized Differently
      • TempDB Version Store bloated
      • Understanding SQL Server Backups: When to Perform Full Backups
      • Understanding Target Recovery Time in SQL Server
      • Untrusted Check Constraints
      • Untrusted Foreign Keys
      • Untrusted Foreign Keys
      • Veeam or other backup system stomping on transaction logs
      • Worker threads are running out
    • 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
      • Availability Groups
      • Backup Status
        • Backup History in SQL Server
        • Script to Check Backup Status in SQL Server
      • Blocking Tree
      • Bottleneck Mix by Database
      • Configuration Values
      • Connections for an Instance
      • CPU by Database
      • CPU Load for Hour
      • Database Use
      • Databases by Size
      • DBCC CheckDB Last Known Good
        • CheckDB Advisor
      • Deadlock Objects
      • Deadlocks
        • Deadlocks Advisor
      • Deadlocks by Database
      • Disk Space
      • Disk Space Forecast
      • Email Alert Log
      • Error Log
      • Failed Jobs
      • Failed Jobs Report
      • Failover Compatibility
      • File Utilization Report
      • I/O by Database
      • I/O By Drive
      • Index LOB Columns Report
      • Inventory Report
      • Job History
      • Job Schedules
      • Large Tables
      • Last DBCC CheckDB Known Good
      • Linked Servers
      • Log Shipping
      • Memory Grants and Spills
      • Memory Usage
      • Migration Planner
      • Open Transactions
      • Optimized Locking
      • Optimizer Effort
      • Orphan Users
      • Page Reads and Page Writes by Database
      • Parallelism Calibration
      • Problem Indexes
      • Quick Scan
      • Replication
      • Replication Publishers and Subscribers
      • Schema Search Report
      • Security
      • Security Posture
      • Sessions
      • Sessions by DB Name
      • Sessions by Login
      • SQL CPU Schedulers
      • Structure Change Log
      • TempDB Consumers
      • TempDB Metadata Contention
      • Trace Flags Report
      • Upgrade Recommendations
      • Waits
      • What Changed
      • 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
    • Agent Activity
    • Agent Security
    • Agent Settings
    • Alerts and Operators
    • Backup Ledger
    • Backup Size
    • Backup Speed
    • Backup Time Frames
    • Backups
      • Backup Advisor
    • Big Clustered Indexes
    • Blocking Queries
    • Buffer Pool by Object
    • Columnstore Health
    • Connections
      • Connections Advisor
    • CPU By Query
      • CPU By Query Advisor
    • Data Collector
    • Database Mail History
    • Database Mail Setup
    • 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
    • Growth from Backups
    • Identity Column Usage
    • Index Contention
    • Index Scan Drift
    • Index Usage Trend
    • Inefficient Indexes
    • IO by Hour by Day
    • Job Commands
    • Job Step Failures
    • LOB Column Indexes
    • LOB Columns
    • Long Running Queries
      • Long Running Queries Advisor
    • Mail Content
    • Mail Recipients
    • Maintenance Plans
    • Maintenance Window Finder
    • master Backup and Rebuild Readiness
    • master Change Ledger
    • master Credentials
    • master Database Properties
    • master Endpoints
    • master File Map
    • master Footprint
    • master Keys and Certificates
    • master Overview
    • master Resource Governor
    • master Server Audits
    • master Server Permissions
    • master Server Triggers
    • master Service Facts
    • master Startup Procedures
    • master User Objects
    • Missed Runs
    • Missing Indexes
      • Cardinality Report
      • Missing Index Advisor
    • Most Used Indexes
    • msdb Space and Retention
    • One Time Use Queries
      • One Time Use Queries Advisor
    • Package Store
    • Page Reads and Page Writes by Query
    • Partitioned Tables
    • Plan Cache
    • Plan Regressions
    • Plan Warnings
    • Policy Evaluation
    • Queries Needing Params
      • Queries Needing Params Advisor
    • Query Advisor
    • Recovery Exposure
    • Restore History
    • Scalar UDF Inlining
    • 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)
    • SSIS Catalog Health
    • SSIS Catalog Inventory
    • SSIS Completion Trend
    • SSIS Connection Reach
    • SSIS Critical Path
    • SSIS Data Flow
    • SSIS Dumps and Runtime
    • SSIS Environments
    • SSIS Inside the Package
    • SSIS Job Disagreement
    • SSIS Overrides
    • SSIS Package Failures
    • SSIS Package Map
    • SSIS Package Speed
    • SSIS Packages Run
    • SSIS Reruns
    • SSIS Running Now
    • SSIS Schedule
    • SSIS Self Contention
    • SSIS Who Fills It
    • SSRS Overview
    • SSRS Report Speed
    • SSRS Report Users
    • SSRS Reports Run
    • Statistics
      • Statistics Advisor
    • Subsystem Load
    • Table Sizes
      • Table Size Advisor
    • Table Space Breakdown
    • Tables With Triggers
    • Technical Debt
    • TempDB Allocation
    • TEMPDB High Use
    • TempDB Use By Hour By Day
    • Third Party Objects
    • Unclustered Tables
    • Untrusted Constraints
    • Unused Indexes
      • Indexing Overview
      • Unused Indexes Advisor
    • Waits by Query
  • 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? We’ve Got You Covered
    • Pricing Requests
    • Privacy Policy
    • Raving Fans
    • Steve Stedman
    • Shared Scripts
    • Tips
      • Free 90 Day Trial
      • No tempdb Backups
      • Removing the Monitoring Database
      • SQL Server Compatibility Levels Requirements
      • User Permissions
Database Health Monitor

Off Canvas Menu

  • Home
  • SQL Consulting
    • SQL Server Health Check Report
  • SQL Performance Tuning
    • Load Testing with Query Loading Ramp
    • Performance Tuning SQL Server PDF
    • SQL Server Performance Monitor Tool
    • SQL Server Performance Tips
    • Types of Performance Tuning in SQL Server
  • Subscription Options
  • Download
    • Buy
    • Frequently Asked Questions
    • Pricing
    • Release Notes
    • SchemaDrift Download
    • Support Request
    • Survey
  • Database Health Reports
    • Webinar Training Events
    • Command Line Parameters
    • DBAssistant
    • Keyboard and Command Palette
    • Product Registration
    • Request a Feature
      • Requested Features
    • SQL Server Email Alerting
    • Submit Bug Report
    • Welcome Page
    • 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
    • Blocking by Hour by Day
    • Configure Historic Database Connection
    • CPU by Hour by Day
    • Deadlock Objects for a Database
    • Deadlocks by Hour
    • Disk Latency by Hour by Day
    • File Size Over Time
    • Historic Database Rebuild
    • Historic Waits
      • Historic Waits Advisor
        • PAGELATCH_UP
    • Long Running by Hour by Day
    • Long Running History
    • TempDB Use by Hour by Day
    • What is your baseline?
  • Server Overview
    • SQL Server Quick Scan Report
      • A data or log file cannot grow any further
      • A large heap is being updated
      • A transaction has been open far too long
      • Availability Group database is not healthy
      • Availability Group send or redo queue backlog
      • Command Log Cleanup
      • Database Connections As SA
      • Database Health Monitor Log File Size
      • Database is not online or not in multi user mode
      • Database set to Autoshrink
      • DBCC CHECKDB Corruption Errors Found
      • DBHealthHistory data file is too large
      • DBHealthHistory log file max size is too large
      • Default Location on the C Drive
      • Default Maintenance Plan Check Integrity Task
      • Default Maintenance Plan Defragment Index Task
      • Default Maintenance Plan Reindex Task
      • Default Maintenance Plan Shrink Database
      • Default Maintenance Plans
      • Disabled Indexes
      • Error log history in DBHealthHistory
      • Error Log Issues
      • Excessive sysmail_allitems
      • Failed login auditing is switched off
      • Historic monitoring referencing obsolete code
      • Large tables in DBHealthHistory database
      • Linked Server with No Data Access
      • Locks Set To Something Besides 0
      • Log shipping secondary is behind its threshold
      • Log truncation is blocked
      • Max degree of parallelism is higher than a NUMA node has cores
      • Memory Dumps
      • Memory grants are queuing
      • Not Enough Disk Space Leading to Restore Delays
      • Not Using TDE
      • Quick Scan Report – Alerts
        • Database Mail Agent Notifications
        • Merge Replication Conflicts
        • TempDB files too small.
        • TempDB with excessive files
      • 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
        • Quick Scan Report – Slow or No 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 – Data and Log Files on the Same Drive
      • 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 – Fill Factor
      • Quick Scan Report – Full or Bulk Logged Recovery Model with No Backups
      • Quick Scan Report – Instant File Initialization (IFI)
        • Database Instant File Initialization
        • Perform Volume Maintenance Tasks
      • 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 – Ola Scripts Installed but Not Running
      • 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 2012 End of Life
      • Quick Scan Report – SQL Server 2014 End of Life
      • 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 – TempDB Version Store Usage
      • 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
      • Remote Query Timeout Setting
      • Replication Synchronization Delay
      • Serious errors in log
      • Serious recent errors.
      • Service Broker Not Enabled for MSDB
      • SQL Agent Hot Spot
      • SQL logins with blank passwords or policy turned off
      • SQL Server 2019 Long Async API Call
      • SQL Server 2025 Version Numbers
      • SQL Server Agent Jobs and Schedules
      • SQL Server Express Core Limit
      • SQL Server running as local system and not a domain or local user
      • SQL Server Standard Edition Core Limit
      • SSIS Installed but not used
      • Suspected Corruption
      • TempDB Sized Differently
      • TempDB Version Store bloated
      • Understanding SQL Server Backups: When to Perform Full Backups
      • Understanding Target Recovery Time in SQL Server
      • Untrusted Check Constraints
      • Untrusted Foreign Keys
      • Untrusted Foreign Keys
      • Veeam or other backup system stomping on transaction logs
      • Worker threads are running out
    • 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
      • Availability Groups
      • Backup Status
        • Backup History in SQL Server
        • Script to Check Backup Status in SQL Server
      • Blocking Tree
      • Bottleneck Mix by Database
      • Configuration Values
      • Connections for an Instance
      • CPU by Database
      • CPU Load for Hour
      • Database Use
      • Databases by Size
      • DBCC CheckDB Last Known Good
        • CheckDB Advisor
      • Deadlock Objects
      • Deadlocks
        • Deadlocks Advisor
      • Deadlocks by Database
      • Disk Space
      • Disk Space Forecast
      • Email Alert Log
      • Error Log
      • Failed Jobs
      • Failed Jobs Report
      • Failover Compatibility
      • File Utilization Report
      • I/O by Database
      • I/O By Drive
      • Index LOB Columns Report
      • Inventory Report
      • Job History
      • Job Schedules
      • Large Tables
      • Last DBCC CheckDB Known Good
      • Linked Servers
      • Log Shipping
      • Memory Grants and Spills
      • Memory Usage
      • Migration Planner
      • Open Transactions
      • Optimized Locking
      • Optimizer Effort
      • Orphan Users
      • Page Reads and Page Writes by Database
      • Parallelism Calibration
      • Problem Indexes
      • Quick Scan
      • Replication
      • Replication Publishers and Subscribers
      • Schema Search Report
      • Security
      • Security Posture
      • Sessions
      • Sessions by DB Name
      • Sessions by Login
      • SQL CPU Schedulers
      • Structure Change Log
      • TempDB Consumers
      • TempDB Metadata Contention
      • Trace Flags Report
      • Upgrade Recommendations
      • Waits
      • What Changed
      • 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
    • Agent Activity
    • Agent Security
    • Agent Settings
    • Alerts and Operators
    • Backup Ledger
    • Backup Size
    • Backup Speed
    • Backup Time Frames
    • Backups
      • Backup Advisor
    • Big Clustered Indexes
    • Blocking Queries
    • Buffer Pool by Object
    • Columnstore Health
    • Connections
      • Connections Advisor
    • CPU By Query
      • CPU By Query Advisor
    • Data Collector
    • Database Mail History
    • Database Mail Setup
    • 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
    • Growth from Backups
    • Identity Column Usage
    • Index Contention
    • Index Scan Drift
    • Index Usage Trend
    • Inefficient Indexes
    • IO by Hour by Day
    • Job Commands
    • Job Step Failures
    • LOB Column Indexes
    • LOB Columns
    • Long Running Queries
      • Long Running Queries Advisor
    • Mail Content
    • Mail Recipients
    • Maintenance Plans
    • Maintenance Window Finder
    • master Backup and Rebuild Readiness
    • master Change Ledger
    • master Credentials
    • master Database Properties
    • master Endpoints
    • master File Map
    • master Footprint
    • master Keys and Certificates
    • master Overview
    • master Resource Governor
    • master Server Audits
    • master Server Permissions
    • master Server Triggers
    • master Service Facts
    • master Startup Procedures
    • master User Objects
    • Missed Runs
    • Missing Indexes
      • Cardinality Report
      • Missing Index Advisor
    • Most Used Indexes
    • msdb Space and Retention
    • One Time Use Queries
      • One Time Use Queries Advisor
    • Package Store
    • Page Reads and Page Writes by Query
    • Partitioned Tables
    • Plan Cache
    • Plan Regressions
    • Plan Warnings
    • Policy Evaluation
    • Queries Needing Params
      • Queries Needing Params Advisor
    • Query Advisor
    • Recovery Exposure
    • Restore History
    • Scalar UDF Inlining
    • 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)
    • SSIS Catalog Health
    • SSIS Catalog Inventory
    • SSIS Completion Trend
    • SSIS Connection Reach
    • SSIS Critical Path
    • SSIS Data Flow
    • SSIS Dumps and Runtime
    • SSIS Environments
    • SSIS Inside the Package
    • SSIS Job Disagreement
    • SSIS Overrides
    • SSIS Package Failures
    • SSIS Package Map
    • SSIS Package Speed
    • SSIS Packages Run
    • SSIS Reruns
    • SSIS Running Now
    • SSIS Schedule
    • SSIS Self Contention
    • SSIS Who Fills It
    • SSRS Overview
    • SSRS Report Speed
    • SSRS Report Users
    • SSRS Reports Run
    • Statistics
      • Statistics Advisor
    • Subsystem Load
    • Table Sizes
      • Table Size Advisor
    • Table Space Breakdown
    • Tables With Triggers
    • Technical Debt
    • TempDB Allocation
    • TEMPDB High Use
    • TempDB Use By Hour By Day
    • Third Party Objects
    • Unclustered Tables
    • Untrusted Constraints
    • Unused Indexes
      • Indexing Overview
      • Unused Indexes Advisor
    • Waits by Query
  • 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? We’ve Got You Covered
    • Pricing Requests
    • Privacy Policy
    • Raving Fans
    • Steve Stedman
    • Shared Scripts
    • Tips
      • Free 90 Day Trial
      • No tempdb Backups
      • Removing the Monitoring Database
      • SQL Server Compatibility Levels Requirements
      • User Permissions

Database Health Monitor

Database Health Monitor 4.1625: 29 New Reports, 12 New Alerts and a Redesigned Performance Dashboard
Database Health Monitor

Database Health Monitor 4.1625: 29 New Reports, 12 New Alerts and a Redesigned Performance Dashboard

Steve Stedman Sep 29, 2026

Version 4.1625 adds 29 reports, 12 built-in alerts plus custom T-SQL alerts, a rebuilt performance dashboard, sensitive data discovery and 934 fixes. Here is the complete tour, report by report.

Read more →

msdb Is Too Big? Here’s What’s Actually Filling It
Database Health Monitor

msdb Is Too Big? Here’s What’s Actually Filling It

Steve Stedman Sep 28, 2026

msdb is too big because backup history, job history, and mail logs pile up forever. See what’s filling it and how many days each source holds.

Read more →

Finding the Statement Inside a Loop in SQL Server
Database Health Monitor

Finding the Statement Inside a Loop in SQL Server

Steve Stedman Sep 26, 2026

Spot the statement inside a loop running thousands of times inside a busy procedure, using Query Store data compared within its own module.

Read more →

Is Your SQL Server Response Time Target Being Met?
Database Health Monitor

Is Your SQL Server Response Time Target Being Met?

Steve Stedman Sep 25, 2026

Your SQL Server response time target means nothing until you can see what share of executions actually meet it, and which queries don’t.

Read more →

Is a SQL Server Query Regression Statistically Significant?
Database Health Monitor

Is a SQL Server Query Regression Statistically Significant?

Steve Stedman Sep 23, 2026

See whether it is a SQL Server query regression statistically significant, or just noise from Query Store, before you tune anything.

Read more →

Inside Database Health Monitor 4.1540: 63 New Reports, 25 Features and 515 Fixes
Database Health Monitor

Inside Database Health Monitor 4.1540: 63 New Reports, 25 Features and 515 Fixes

Steve Stedman Sep 22, 2026

Database Health Monitor 4.1540 adds a 25 report Query Store suite, a 15 report SSRS suite, 23 new Azure SQL Health Monitor reports, 25 new features and 515 bug fixes. Here is what changed and why it matters.

Read more →

Is This Query Slower Than Normal? Ask Its Own History
Database Health Monitor

Is This Query Slower Than Normal? Ask Its Own History

Steve Stedman Sep 21, 2026

Is this query slower than normal? Learn how per-query limits from Query Store history separate a real slowdown from ordinary wobble.

Read more →

master Backup Out of Date? Here’s How to Check It
Database Health Monitor

master Backup Out of Date? Here’s How to Check It

Steve Stedman Sep 16, 2026

A master backup out of date can pass every check and still miss logins, role grants, and linked servers created since it ran. Here’s how to see the gap.

Read more →

SQL Server Job Slow When Others Run? Here’s Why
Database Health Monitor

SQL Server Job Slow When Others Run? Here’s Why

Steve Stedman Sep 14, 2026

A job slow when others run isn’t a broken package. See how Database Health Monitor’s Subsystem Load report finds the Agent worker limit causing it.

Read more →

Why Autogrowth in Percent Slows SQL Server Down
Database Health Monitor

Why Autogrowth in Percent Slows SQL Server Down

Steve Stedman Sep 13, 2026

Autogrowth in percent compounds: every growth event takes longer than the last. Here’s how to spot it and fix it before it slows down SQL Server.

Read more →

Posts pagination

1 2 Next
Copyright © 2026 Database Health Monitor | Powered by Responsive Theme
Copyright © 2026 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