SQL Server Health

The SQL Server Health reports has been replaced with the Database Health Application.

Please visit http://DatabaseHealth.com for more details.

The free SQL Server Health report evaluates a number of areas of your database, and provides details on problems and what can be done to fix them.

 

One question that comes up is “what do I need to install on my SQL Server?”  The answer is NOTHING, the Database Health Reports is an application that can install on your SQL Server, or it can be installed on your desktop.

Here are some screen shots:

Inefficient Indexes Report

DBHealth_Inefficient_Indexes

Index Fragmentation Report

Index_Fragmentation_Report

Wait Monitoring Report

HistoricWaitsHourByMinute

Downloads:

After downloading and attempting to use the report, you will need to configure the datasource to connect to your server.  See the help page for more details.

SQL Server Health Reports History

11/19/2011 – Created Initial Version
11/26/2011 – Added Long Running Queries
11/27/2011 – Added Duplicate Indexes
12/03/2011 – Added CPU Utilization Report
12/07/2011 – Released the database size report
12/08/2011 – Released the Backup Set Report
12/10/2011 – Fixed a couple of bugs in the Backup Set report with the line sizes in the chart.  Added the new Statistics report.
01/08/2012 – Fixed some layout issues in the Index Fragmentation Report, and cleaned up some general layout issues in the rest of the reports.
03/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.
03/11/2012 – Minor UI Fixup.  Added included columns into the Duplicate Indexes
03/16/2012 –  A little more clean up and final polishing for SQL Saturday Vancouver tomorrow.
03/18/2012 – Added 2 new reports Top Cache Queries and top CPU Queries.

22 Responses to SQL Server Health

  1. Pingback: » New – SQL Server Health report Steve Stedman

  2. Pingback: » Free – Long Running Queries Report Created Steve Stedman

  3. Pingback: » Determining free disk space with TSQL Steve Stedman

  4. Pingback: » Database Size report added to SQL Health Reports Steve Stedman

  5. Pingback: » Index Statistics Report added to the FREE SQL Server Health Reports Steve Stedman

  6. Pingback: » 2 Sessions Accepted for SQL Saturday 114 in Vancouver Steve Stedman

  7. Pingback: » Update available for the SQL Server Health Reports Steve Stedman

  8. Pingback: » Sessions Submitted for SQL Saturday #120 Orange County CA Steve Stedman

  9. Pingback: » SQL Server Health Report Updated – Top IO added Steve Stedman

  10. Pingback: » SSRS – Using a subreport for navigation Steve Stedman

  11. Pingback: » SQL Server Health Reports Updated Steve Stedman

  12. Pingback: » SQL Server Health Reports – Updated Steve Stedman

  13. Pingback: Had an amazing time at SQL Saturday in Vancouver! | Scott Mattie's blog

  14. anitha says:

    I tried opening up this package in BI and it says missing databse value . Where should I populate the database value . Do Advice

    • SteveStedman SteveStedman says:

      Yes instead of running in preview mode, just hit Run or F5 in Business Intelligence Studio or Visual Studio, and that will run the reports.

  15. Pingback: » SQL Server Health Reports — Working on Version 2 Steve Stedman

  16. Pingback: » Making Progress on the Server Health Re-write Steve Stedman

  17. MT says:

    How do I correctly define a data source? I’ve added one via “shared data sources” but each time I run it I recieve “The report definition for report /chooseserver has not been specified.

    • SteveStedman SteveStedman says:

      MT – Distributing the SSRS reports for server health has proven to be a challenge, specifically relating to the shared datasources. I have been working on Version 2.0 of the health reports, which should be available as a beta in September 2012. The new health reports allow for multiple databases, and for much easier datasource configuration.

      If you are interested in being a beta user just register on this site (if you haven’t done so already), and you will be notified when the beta is available.

      • Alberto says:

        I also get that error. Is there anything we can look at on our side to resolve this or should i just sign up and test the beta?

        • Alberto says:

          I was actually able to resolve the issue by simply copying the “chooseServer” and “Header” rdl’s into the Bin\Debug directory. After that everything worked fine. The first time it ran after doing that it did give me an error but it seemed to compile some more files in that directory and ran fine the second time. Hope this helps.

  18. SteveStedman SteveStedman says:

    The best option would be to go for the new Beta of the Database Health Reports located at http://DatabaseHealth.SteveStedman.com. The new version eliminates the configuration options of the RDLs.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweet Captcha