Every administrator starts collecting scripts or procedures on how to accomplish their tasks. After asking himself “Where did that script go?” Steve Stedman (twitter @sqlEmt) decided to put all his knowledge into an application and the Database Health Tool was created. Since 2010, Steve has been working on this tool as he can to help both our customers and those how need a visual way to look at how their SQL Servers are performing.
In 2016, Steve teamed up with Carlos Chacon to help increase the awareness of the tool and provide direction on how the tool can help the most people. Steve and Carlos currently present sessions and give webinars to help as many as possible understand how to get the best performance out of their servers.
Knowing All Environments
One of the common issues administrators face is the inability to get a monitoring tool to help collect metrics and as a result, there can be real performance issues in the lower environments. The Database Health Monitor changes all of that. A free tool, the monitor can be used on lower environments to get a better sense of what is going on with every SQL Server instance so you don’t have to guess or make assumptions about your environments.
The SQL Server community is made up of passionate people who want to help others. Both Steve and Carlos have been recipients of this generosity and we put everything we learn into this tool so others can best serve their customers.
It is our way of giving back and we hope you enjoy using the tool.
- January 2, 2017 – Version 2.4.5 released. New logos, icons and branding, plus several fixes.
- October 3, 2016 – Version 2.4.4 released.
- June 1, 2016 – Version 2.4 Released. New reports, new features and several bug fixes.
- March 20, 2016 – Version 2.3 Released.
- December 5, 2015 – Version 2.2 Released.
- July 3, 2015 – Version 2.0 Released.
- June 1, 2015 – Beta 10.2 Released. Improved performance on historic reporting. Allows for multiple connections to different reporting database. Automatically detects if a server is already configured for historic reporting.
- May 6, 2015 – Beta 10.1 Released. Removed the crowd funding, and added a couple new reports, the Error Log Report and the Suspect Pages Report. Many bug fixes.
- January 21, 2105 – Beta 10 Released. New icon, crow funding links, added filegroup and partitioning key into the partitioning report. Many bug fixes.
- December 21, 2014 – Beta 9.4 Release, improved overall threading and background processing.
- December 14, 2014 – Beta 9.3 Release, more bug fixes and more new Partitioned tables reports.
- December 7, 2014 – Beta 9.2 Release, more bug fixes and more new reports.
- November 30, 2014 – Beta 9.1 Release, more bug fixes and more new reports.
- November 23, 2014 – Beta 9 Release, bug fixes and a couple of new reports.
- October 5, 2014 – Beta 8.2 Release.
- January 19, 2014 – Beta 8.1 Release – bug fixing.
- December 29th, 2013 – Beta 8 Release – most of the charts rewritten, eliminating extra components.
- Sept 5th, 2013 – Second Release of Beta 7 with a new feature to filter technical debt by debt type.
- Sept 2nd, 2013 – Release of Beta 7 including SQL Technical Debt Analysis, and many performance improvements.
- July- August 2013 – Working on Beta 7 – Adding Technical Debt Reporting.
- June 3rd, 2013 – Released Beta 6 of the Database Health Reports.
- May 21st, 2013 – 600th download of the Database Health Reports. Going strong, thanks everyone.
- April 29th, 2013 – 500th download of Database Health Reports, lots of great feedback.
- March 27th, 2013 – The 400th download of the Database Health Reports. Thanks everyone who is using the product.
- March 3rd, 2013 – Beta 5 Released with a new report for Big Clustered Indexes.
- February 17th, 2013 – The 300th download of the Database Health Reports. Thanks everyone who is using the product.
- January 10th, 2013 – Beta 4 of the Database Health Reports released.
- November 18, 2012 – Release of the historic waits reporting, in Beta 3.
- November 1, 2012 – Cleanup on the historic waits reporting, preparing for Beta 3.
- October 29, 2012 – Refined the 5 dimensions of drilldown, making it work smoother.
- October 28, 2012 – Overall performance tuning on the database health application, getting cleaned up for Beta 3.
- October 27, 2012 – Added the 5 dimensions of drill down into the historic charting.
- October 24, 2012 – Spending some time fixing a few reports that crashed on SQL Server 2005. I think we are good with SQL Server 2005 now.
- October 20, 2012 – Added wait time monitoring, focusing on the queries that have the most waits.
- October 14, 2012 – Finally have the preliminary historic reporting working.
- October 11, 2012 – Major re-design of the application to focus now on historic reporting, rather than just the real time snapshot.
- September 30, 2012 – Release of Beta 2. First download 15 minutes after posting.
- September 23, 2012 – Additional feedback from beta testers. More fixes and adding the Connections Advisor as part of Beta 2.
- September 4, 2012 – First round of feedback from the beta testers. So far so good, doing what I can to fix everything and add new features.
- September 3, 2012 – Started working on the new features that will eventually be part of the Beta 2 release of the Database Health reports application.
- September 2, 2012 – First International download of the Beta 1 release of the Database Health reports application 20 minutes after release. It was downloaded from France.
- September 1, 2012 – First download of the Beta 1 release of the Database Health reports application 20 minutes after release.
- September 1, 2012 – Beta 1 release of the Database Health reports application.
- August 2012 – Final testing on the Database Health reports application and final prep for the beta release.
- July 2012 – Started testing on the Database Health reports application internally and preparing for the beta release.
- April 2012 – Gave up on the SSRS version of the database health reports and began working on an the full Database Health application.
- March 18, 2012 – Added 2 new reports Top Cache Queries and Top CPU Queries.
- March 16, 2012 – A little more clean up and final polishing for SQL Saturday Vancouver tomorrow.
- March 11, 2012 – Minor UI Fixup. Added included columns into the Exact Duplicate Indexes report. Overall cleanup preparing for the SQL Saturday presenation of the SQL Server Health Reports next weekend.
- March 03, 2012 – Major UI Fixup. Standard header on all pages, linking from any report to any other, ability to change the database from within the report, Updated help links, added Top IO report, fixed several bugs.
- January 08, 2012 – Fixed some layout issues in the Index Fragmentation Report, and cleaned up some general layout issues in the rest of the reports.
- December 10, 2011 – Fixed a couple of bugs in the backup set report with the line sizes in the chart. Added the newStatistics report.
- December 08, 2011 – Released the backup set report
- December 07, 2011 – Released the database size report
- December 03, 2011 – Added CPU Utilization Report
- November 27, 2011 – Added Duplicate Index Report and Exact Duplicate Index Report
- November 26, 2011 – Added Long Running Queries Report
- November 19, 2011 – Created Initial Version using SSRS reports
- February to October 2011 – Initial planning – determining what queries would be useful in the Database Health Reports.