With the updated release of Database Health Monitor yesterday, here is the updated list of documentation on the Quick Scan Report. All of the following (plus a few more) are checked from the Database Health Monitor Quick Scan report.
The Quick Scan report checks some common problems that can cause grief on your SQL Server database, and reports on those, with detailed documentation on each of the checks.
- Full or Bulk Logged Recovery Model with No Backups
- Quick Scan Report – Alerts
- Quick Scan Report – Backup Messages In Log
- 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 – DBCC CheckDB Never Run
- Quick Scan Report – DBCC CheckDB Not Run Recently
- Quick Scan Report – Error Log
- Quick Scan Report – Excessive Backup History
- Quick Scan Report – Extended Backup History
- Quick Scan Report – Extended Sysmaintplan_logdetail
- Quick Scan Report – Failed Database Mail
- 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 – Priority Boost
- Quick Scan Report – Remote DAC
- Quick Scan Report – Slow Disk Reads
- Quick Scan Report – SQL Agent Not Running
- 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 – Using obsolete TORN_PAGE_DETECTION
- Quick Scan Report – Version Updates Available
- Quick Scan Report – TempDB Slow IO
More from Stedman Solutions:
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!