Making SQL Server go Faster!

Database Health Reports program is a powerful performance monitoring and diagnostics solution that alerts administrators to health, performance or availability problems within their SQL Server environment, all from a central console.

The Database Health Reports project is provide free of charge by Steve Stedman to the SQL Server community.

Download it now and enjoy:

The Database Health Reports are now available.    Just click the download link for the release notes and the zip file.

Beta7-SQLDebtCallout
Historic Waits2
Historic Waits Advisor2
SliderDuplicateIndexes
SliderUnusedIndexes
SliderParamQueries
SliderFragIndexes
DatabaseOverviewBeta1
<< >>

Save time database tuning with the Database Health Reports.

Database overview including backups, disk space, duplicate indexes, index fragmentation, long running queries, one time use queries, plan cache, queries needing params, statistics, stored procs with the most logical writes, and unused indexes.

The server overview includes connections by database, CPU usage, page reads by database, page writes by database, plan cache by database, queries needing params, and waits.

19 comments on “

    • It is free, but the current beta expires at some point. I wouldn’t want anyone running old code. About ever 90 to 120 days I come out with a new beta. Yes its free, and yes you need to upgrade to the new free version to keep it running.

      This way old bugs that I created last year are no longer being used. The new beta is intended to fix those old bugs.

  1. Awesome!
    I have one suggestion… It would be great if this tool was somehow expandable by adding your own queries.

    Thanks for the good work.

  2. Just found this tool and am loving it. Two comments, one a request and the other a possible bug.
    Request: For the Technical debt, it would be nice if one could add additional items.
    Possible Bug: Your query for Big Clustered indexes returns multiples for nvarchar columns. I believe this is due to the query’s inner join between sys.all_columns and sys.types. Sys.types has two entries for system_type_id=231 (nvarchar and sysname)

    • Thanks for the feedback. I will look into the big clustered indexes.

      I have been thinking about ways to add additional items to the technical debt. This may be available in a future version.

      Thanks!

  3. Steve
    Also just received this error from the latest beta version

    See the end of this message for details on invoking
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    at DatabaseHealth2.PieChart.drawPieBitmaps()

  4. Steve…is there any way to take the charts and graphs as well as the data as shown in the gui and simply (via a job) direct them to a folder (say on sharepoint)

  5. As I have said before GREAT PRODUCT. Is there a way to take the outstanding reports shown in the gui and simply drive them as is to a file or sharepoint?

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