Download
The latest release of Database Health Monitor now available. Download Database Health Monitor today.
- Download the zip file
- Open the zip file, and run DatabaseHealthSetup.exe.
If you have been using a previous version of Database Health Monitor, just download and install this version over the previous one.
Thank you for using Database Health Monitor.
What People Are Saying About Database Health Monitor
- “I installed Database Health Monitor on many of my client’s SQL servers and believe it’s the best tool out there for SQL monitoring.” – Charles Ray – March 2022
- This is a great application for SQL Server DBAing. We have a web based product but this one is so comprehensive, both high level and detailed. So much is available right at the click of a button, it is amazing! I am so grateful for the application, for the effort to build it, and the decision to share it. I know it has made me a better DBA, my organization has benefited from it, and I deeply appreciate all of that! Thank you! – Jesse – October 2021
- Thank you a lot for this excellent application. I loved the “missing indexes” and “Statistics” section, it helps me to save time and effort for the weekly maintenance.
Best Regards November 2019 - Database Health is the first tool that I pull up when someone calls and complains about slow performance in their applications, that be Dynamics NAV, Dynamics AX or even the webpages running slow. It saves me a lot of time finding the queries, missing indexes or what be it, causing the problem. This is by far the easiest and most effective tool to use, when searching for problems that need instant resolution. Thanx a million for your contribution to the SQL world. September 2019.
- This is an awesome tool to find issues and fix them or improve performance in areas that I didn’t even know we can.
- I would like to thank you for sharing this product with us free. I have installed and using health monitor on my production DB. very very nice…. Thank you so very much. I hope you will keep adding more features in this product. Well done (Rohit)
- Outstanding app. Already referred it to several friends in the field. Well I do have to say the changes you have made (regarding version 2.5), seems to have made everything in the interface much snappier. Your work here is quite impressive. (Frank from Texas)
- Outstanding! Besides enjoying the layout of your app, one thing I really like about the Quick Scan Report is each entry has a corresponding link that discusses the finding so I can go back and review recommendations, cautions, etc. (Michael)
February 2025 Release – Version 1118 Release Notes
Bug Fixes
- Fixed the Last known good CheckDB report to run on RDS SQL Servers.
- Fixed the Databases By Size Report to run on RDS SQL Servers.
- Fixed the File Utilization report to work on RDS SQL Servers.
- Fixed a conversion bug in the Connections Advisor.
New Features
- New Reports and tracking for Deadlocks.
- Deadlock tracking added to every 15 minute job.
- Database level Deadlocks by hour report added to show the times of the day or week that deadlocking is occurring.
- Database level Deadlocks by object report added to show what database objects have the most deadlocks.
- Database level Deadlock History report to see the running history of deadlocks for a given database.
- Deadlock Advisor to show specific details on a given deadlock to help diagnose deadlocks.
- Instance report Deadlocks to show users a history of recent deadlocks.
- Instance report Deadlocks by database to see which databases are having the most deadlocks.
- Instance report Deadlocks by hour to show a server level report of the times that deadlocking is occurring.
- Added a new tool “SQL Server Email Alerting” accessible by right clicking an instance name in the tree menu. Learn more about it here: https://databasehealth.com/EmailAlertingAdvisor
- New “Related:” link in the top of the instance reports to make it easier to jump around from instance report to instance report.
- New Instance Report Email Alert Log added to show a history of all email alerts that are triggered as well as an overview of any recently active alerts.
- Moved the startup licensed user check to a new server for a more reliable licensing check. Too many outages on the old server.
- Added a menu item in Database Health Monitor that links to SchemaDrift, along with SchemaDrift now coming installed with Database health Monitor.
- Created a new report called the SQL Server Health Report that will summarize most of the important instance level reports and allows for exporting to HTML and to a Word Document.
- Added a new instance report “Replication Publishers and Subscribers” to monitor replication on your SQL Server instance.
- Added a new instance report “Disk Latency by Hour” to show a historic overview of disk latency.
- Double clicking on rows in the Active Queries and Blocking reports bring up the Connection Advisor allowing users to kill problematic sessions.
- Users can now copy all Session ID’s with a right click option on the Blocking Queries instance and database reports.
- Server overview real time charts can now be moved to be adjusted to user preference. Access this option by right clicking on a chart.
March 2025 Release – Version 1122 Release Notes
Bug Fixes
- Fixed a bug in the Long Running Query advisor where returns and line breaks were not being shown correctly. The queries look much better in this report now.
- Fixed a bug in the Job Schedule Instance Report that was preventing jobs from showing up properly.
- Fixed a bug in the Email Alerting Dialog that prevented Duplicate Alerts from being configured.
- Fixed a bug in Email Alert 5002 that would alert on offline databases.
- Fixed a recursion bug that was occurring in the Instance level Blocking Queries Real Time Chart.
New Features
- Modified the What is Active report to include snapshot details when running on SQL Server 2022 with Snapshot or RSCI Isolation levels.
- Added a new right click menu item to the Blocking Queries report “Kill all blocking and blocked session IDs” to use as an emergency report when you have massive amounts of blocking, but before you may consider restarting your instance.
- Added CTRL + MouseWheel roll for most of the lists and some of the text areas to resize the fonts.
- New database level “Table Use” Report that shows when tables were last queried.
- New “Related:” link in the top of some of the database level reports to make it easier to jump around from report to report.
- Adding Video links into the related links section to link to specific Youtube videos that are related to the current report.
- Added check #236 for linked servers configured without data access as a warning.
- Added a new Cardinality Report to provide more context on the cardinality of suggested index columns. This is accessible through a right click option in the Missing Indexes Report.
- New “TDE Status” Instance Report that shows an in depth overview of TDE statuses on your databases.
January 2025 Release – Version 1084 Release Notes
Bug Fixes
- Fixed a bug in the blocking queries report where it was crashing when there were more than 100 levels deep of blocking, due to the MAXRECURSION default on CTE’s.
- Fixed a bug in the Indexing page where changing between dark and light mode wasn’t functioning properly.
- Fixed an overflow error in the Schema Search page.
New Features
- Added a revitalized version of SchemaDrift into the Database Health Monitor install. Look in the Stedman Solutions program folder for SchemaDrift, our tool to track database changes and to compare schema between databases.
- Added the option to jump to the VLF report in the File Utilization context menu for log files.
- Added a filtering option to Schema Search, you can now filter Schema Search by object type and database.
December 2024 Release – Version 1080 Release Notes
Bug Fixes
- Fixed a resize bug, causing resizing issues across Database Health Monitor.
New Features
- Added New Server Tree “VLFs” Users can now visualize their log file and shrink the file size with the push of a button.
- Added New Instance Report “Schema Search” Search and compare schema across all databases in an instance.
- Added New Instance Report “SQL CPU Schedulers” to monitor SQL Servers CPU usage.
- Added new Instance Report “Deprecated Features” Utilizes new report type, bubble tree map chart.
- Historic Report “File Size Over Time” is now displayed using a line graph.
- Added Average Page Life Expectancy chart to the “Performance History” Instance report.
- When adding other waits to hide in Historic Waits, the Ignore Waits advisor will now provide a drop down list of all wait types.
October 2024 Release – Version 1074 Release Notes
Bug Fixes
- Corrected old icon on the historic waits advisor dialogs.
- Fixed Error on Quickscan Check 227
New Features
- Adding additional wait documentation into the historic waits advisor for some common wait types.
- PREEMPTIVE_OS_PIPEOPS
- PREEMPTIVE_OS_QUERYREGISTRY
- PAGELATCH_EX
- Added Blocking Queries chart to database level Real Time Overview. Clicking on chart takes user to Database level Blocking real time page.
- Added Active Queries chart to database level Real Time Overview. Clicking on chart takes user to Database level Active Queries real time page.
- Quickscan report check 233: Checks if a SQL Server Agent job has been configured but not scheduled
- Added Instance Report “Performance History”
- Added New Server Tree Historic Report “File Size Over Time”
- Color Blind mode has been added to alter chart colors for accessibility.
September 2024 Release– Version 1073 Release Notes
Bug Fixes
- Fixed Error on Quickscan Checks 91 and 228
- Fixed Error whilst running Quickscan on a instance without DBHealthHistory Database
September 2024 Release– Version 1072 Release Notes
Bug Fixes
- Added Read Uncommitted to the trackTempDBUsage procedure. This was causing too main waits.
- Fixed QuickScan check 91
- Changed Dark Modes background color for ease of use.
- Added Dark Mode persistence between sessions.
New Features
- QuickScan report add a check for large differential backups(221).
- QuickScan report add a check for usage of UPDLOCK where it causes blocking and excessive wait times(222,223).
- Quickscan report check 224: Looks for User defined assemblies in each database
- Quickscan report check 225: Looks at database snapshots and how many
- Quickscan report check 226: Finds database snapshots that are older than 60 days
- Quickscan report check 227: Finds database snapshots that are greater than 250mb and greater than 50% of original database.
- Quickscan report check 228: Check for Very low disk space on system (<5%)
- Quickscan report check 229: Checks for a specific error related to SQL 2019 CU 27
- Quickscan report check 230: Checks to see if the remote query timeout is below the default
- Quickscan report check 231: Checks to see if SA has active connections
- Quickscan report check 232: Checks to see if TDE encryption has been enabled on any db’s. If yes, checks to make sure no other db’s were missed.
- Added Blocking Queries chart to actively monitor any blocking queries. Clicking on chart takes you to Blocking Queries Instance Report.
- Added Active Queries chart to actively monitor any active queries. Clicking on chart takes you to the What is Active Instance Report.
- Updated Instance report panel to include 3 new sections
- New drop down for selecting any available instance report
- Most used section for all your go to instance reports
- Recommended section for fresh installs
- Added Instance report for Active SA connections
- Added Index Report for Large Objects existing in the Column field
- Added Instance Report for Large Objects existing in the Column field
July 2024 Release– Version 1067 Release Notes
Bug Fixes
- Fixing bug with sorting of dates in the grids throughout Database Health Monitor. Improved formatting on the text version of date times.
- Fixed bug in the inventory report where SQL Server 2022 was being reported as an unknown version.
- Bug fixed with a period or other wacky characters in the filename for shrinking and expanding vlfs. Vlf Advisor.
- Increased security level for internally encrypted items to use a more secure option. Removed 3DES.
- Bug fixed where certain reports were still accessible, but failing even though the user had incorrect permissions
- Fixed potential security exploit introduced in the system.txt.json version 8.0.3 by upgrading to 8.0.4
New Features
- Added tracking of all database file sizes over time as part of the historic monitoring. Currently it is just tracking it, next step will be to add a report to show the size over time
- Added check #220 into the QuickScan report to check for the CommandLog table (from Ola Hallagren’s scripts) growing too large and not being purged.
- Updated the historic reporting jobs to cleanup from the CPU table to delete at 60 days if there is no purge date specified to keep unlimited growth from occurring.
- Added a report that finds large tables that contain images that could be compressed to free up disk space.
Mid February 2024 – Version 1055 Release Notes
New Features
- Added Upgrade Recommendations instance report.
- Added double click event on the TempDB High Usage Usage report to show the full query.
- Added double click event on the What is Active report to show the full query.
General Maintenance
- Adjusted the heat map colors for the tempdb usage report to have to be above 2gb before showing red. Thus making low usage tempdb never show red.
Performance Improvements
- Reduced the startup time by more than 90% when starting Database Health Montior with many SQL Servers connected. Even more so when your SQL Servers have many databases. The first time you click on a database is may take a moment longer, but the startup time is dramatically reduced. If you are using just 3 or 4 SQL Servers you may not notice the difference, but anyone connecting to more than 10 SQL Servers, or to SQL Servers with dozens or hundreds of database should see a significant improvement. For instance on a production system connected to 34 sql servers at varying locations the startup time was about 1 minute and 15 seconds. Now it is about 4 seconds.
See the Release Notes page for details on updates in older versions.
Leave a Reply