Database Health was created by Steve Stedman (twitter @sqlEmt).

This is a beta version, and is available for free to anyone who wants to use it.

If you have not already registered, please register on my website, http://SteveStedman.com and you will be informed when a newer version is available.

Timeline:

• February to October 2011 – Initial planning – determining what queries would be useful in the Database Health Reports.
• November 19, 2011 – Created Initial Version using SSRS reports
• November 26, 2011 – Added Long Running Queries Report
• November 27, 2011 – Added Duplicate Index Report and Exact Duplicate Index Report
• December 03, 2011 – Added CPU Utilization Report
• December 07, 2011 – Released the database size report
• December 08, 2011 – Released the backup set report
• December 10, 2011 – Fixed a couple of bugs in the backup set report with the line sizes in the chart.  Added the newStatistics report
• 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.
• 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 Updated.
• 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 16, 2012 –  A little more clean up and final polishing for SQL Saturday Vancouver tomorrow.
• March 18, 2012 – Added 2 new reports Top Cache Queries and Top CPU Queries.
• April 2012 – Gave up on the SSRS version of the database health reports and began working on an the full Database Health application.
• July 2012 – Started testing on the Database Health reports application internally and preparing for the beta release.
• August 2012 – Final testing on the Database Health reports application and final prep for the beta release.
• September 1, 2012 – Beta 1 release of the Database Health reports application.
• September 1, 2012 – First download of the Beta 1 release of the Database Health reports application 20 minutes after release.
• 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 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 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 23, 2012 – Additional feedback from beta testers.  More fixes and adding the Connections Advisor as part of Beta 2.
• September 30, 2012 – Release of Beta 2.  First download 15 minutes after posting.
• October 11, 2012 – Major re-design of the application to focus now on historic reporting, rather than just the real time snapshot.
• October 14, 2012 – Finally have the preliminary historic reporting working.
• October 20, 2012 – Added wait time monitoring, focusing on the queries that have the most waits.
• 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 27, 2012 – Added the 5 dimensions of drill down into the historic charting.
• October 28, 2012 – Overall performance tuning on the database health application, getting cleaned up for Beta 3.
• October 29, 2012 – Refined the 5 dimensions of drilldown, making it work smoother.
• November 1, 2012 – Cleanup on the historic waits reporting, preparing for Beta 3.
• November 18, 2012 – Release of the historic waits reporting, in Beta 3.
• January 10th, 2013 – Beta 4 of the Database Health Reports released.
• February 17th, 2013 – The 300th 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.
• March 27th, 2013 – The 400th download of the Database Health Reports.  Thanks everyone who is using the product.

Download this page in PDF format