↓ Skip to Main Content

Secondary Navigation

Database Health Monitor

Main Navigation

  • Home
  • 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
      • 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 Lookups
      • Understanding SQL Page Reads
      • Understanding SQL Page Writes
      • Understanding SQL Recompilations
      • Understanding SQL Target Memory
      • Understanding SQL Total Memory
      • Understanding SQL Transactions
    • 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_EX wait type
      • PAGEIOLATCH_XX Wait
      • 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
      • 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
      • SQL CPU by Hour of Day
      • 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
      • 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
    • Index Fragmentation
      • Fragmented Index Advisor
      • Index Defragmentation Script
      • TSQL To Find Fragmented Indexes
    • 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
    • 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
  • About
    • Data Transmission
    • Feedback Survey
    • Licensing Agreement
    • Privacy Policy
    • Raving Fans
    • Steve Stedman
    • Shared Scripts
    • Tips
      • Free 90 Day Trial
      • Instant File Initialization (IFI)
      • No tempdb Backups
      • Removing the Monitoring Database
      • SQL Server Compatibility Levels Requirements
      • User Permissions

Monitoring TempDB

Here is a short video that describes how to use Database Health Monitor to track tempdb usage.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!

Contact Info

Stedman Solutions, LLC.
PO Box 3175
Ferndale WA 98248

Phone: (360)610-7833

  • Our Contact Info Page
  • Our Privacy Policy
download as a pdf file Download this page in PDF format

Database Health Monitor October 2024 Release

October 2024 Version

Now Available

The October 2024 Database Health Monitor Version 1074 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