Database Health Monitor is a robust SQL Server monitoring tool developed by Stedman Solutions, designed to assist SQL Server administrators in monitoring and maintaining their SQL Server environments. Its primary purpose is to provide insights into database performance, detect potential problems, and offer actionable recommendations for optimization. With a user-friendly interface and a comprehensive set of features, it helps DBAs manage their databases more effectively, reducing downtime and enhancing overall performance.
The tool offers a wide range of features, including real-time monitoring of SQL Server health metrics, such as wait statistics, database fragmentation, and query performance. It also includes tools for identifying common issues like missing indexes, excessive index fragmentation, and long-running queries. Additionally, Database Health Monitor generates detailed reports and dashboards, making it easier to spot trends and address problems proactively. These capabilities make it an indispensable asset for SQL Server administrators seeking to ensure their environments remain healthy and performant.
Database Health Monitor is ideal for both small organizations and large enterprises. It’s particularly useful for detecting and addressing issues that can impact performance, such as excessive blocking, deadlocks, or resource-intensive queries. The tool also provides in-depth analysis for capacity planning, helping teams anticipate storage needs and prevent unexpected failures. By integrating Database Health Monitor into their workflows, DBAs can save valuable time and focus on strategic tasks rather than firefighting database problems.
Developed by SQL Server experts with decades of experience, including insights from the challenges of managing real-world databases, Database Health Monitor reflects a deep understanding of what DBAs need. Unlike other monitoring tools, it’s free to use, yet offers many features typically found in premium solutions. For organizations seeking expert assistance or wanting to extend their monitoring capabilities, it works seamlessly with the Managed Services from Stedman Solutions. Learn more and download Database Health Monitor at DatabaseHealth.com. It’s a game-changer for anyone looking to simplify SQL Server management while improving reliability and performance.
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be… Read More »Finding tables that don’t have a clustered index.
Over the last 4 years I have been working on the Database Health Monitor. I am about a week away from releasing Version 2, which will finally be out of the beta process. In preparation for the release I am sharing some of the history of this program.
In 2011 version 1 was released as a set of my favorite monitoring queries that had been formatted and made available through SSRS. As people started to try it out in late 2011 and early 2012, I quickly discovered that the process for distributing shared queries via SSRS reports wasn’t very easy for the people trying to use them. Many people quickly discovered the difficulty of installing these reports. The set of reports looked something like this.
There were 10 reports that were linked from the top panel in the SSRS user interface. Although SSRS has some great features, it was challenging to switch database connections and monitor multiple servers.
In April of 2012 I gave up on the concept of using SSRS reports, and converted all the queries into a windows application and started enhancing the program. In September of 2012, I finally had the Beta 1 release of Database Health Reports out. It was a bit rough in the beginning, but from 2012 to 2015 through a series of almost 20 beta releases labeled names like Beta 1, Beta 8.2, Beta 10.1, and so forth I kept enhancing the program. Here is an early screenshot of somewhere around Beta 1 or Beta 2.
Today I have released beta 9 of the Database Health Monitor. It has been 27 months since the release of Database Health Beta 1, and… Read More »Database Health Reports Beta 9 – Released
Today I presented on Advanced CTEs at SQL Saturday Denver. Here are my slides and sample code for download: Advanced CTEs Denver Thanks to everyone… Read More »Advanced CTEs Slides and Samples
One of the ideas behind Scrum software development is the idea of “Release early, Release Often and Get Customer Feedback.” After the release of Beta… Read More »Beta 7+ Filter Technical Debt by Debt Type
As I get ready for Beta 7 to launch I have decided that for Beta 8 I will focus on feature suggestions from the users… Read More »Suggest An Idea for Database Health Reports
As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical… Read More »SQL Server Technical Debt
Today marks the 1000th download of the Database Health Reports in the last 11 months since Beta 1 was released. I thought this would be… Read More »One Thousandth Download of Database Health Reports
As part of my contribution back to the SQL Server community I am adding a new feature into the free Database Health Reports application. I am currently… Read More »Working on the T-SQL Technical Debt feature in the Database Health Reports
I received this rave today about the Database Health Reports. It has been posted on the Raving Fans page. 7/17/2013 – Beta 6 Rave The… Read More »New Raving Fan for Database Health Reports