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:

Latest news

November 2014 – Database Health Reports has over 1500 installs worldwide.

Details

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.

31 comments

  • Its free but it expires in 90 days what gives?

    • Steve Stedman

      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.

  • 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.

  • IT would be great if you could type in the window credentials versus passing them through.

    Great tool, thanks so much!

  • New version is great but I get an error every time I try to minimize it.

  • 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)

    • Steve Stedman

      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!

  • 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()

  • 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)

  • 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?

  • Steve,
    Good work. I have just downloaded and started playing with it. It’s really helpful and handy specially for naïve DBAs who doesn’t know how to play with DMVs. As a production DBA I always want to see the current running queries and their execution plans. I use the following SQL to get the details; I would love to see if this can be integrated with the tool.

    select *,percent_complete,OBJECTID,dbid,SESSION_ID,blocking_session_id,wait_time,wait_type,( SELECT TOP 1 SUBSTRING(s2.text, statement_start_offset / 2, ( (CASE WHEN statement_end_offset = -1 THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2) ELSE statement_end_offset END) – statement_start_offset) / 2) ), (SELECT query_plan FROM sys.dm_exec_query_plan (plan_handle)) from
    sys.dm_exec_requests s1 CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2

    Cheers,
    Yusuf.

  • Hi Steve – Great product, but unfortunately, version 8.1 has expired and the download link from the software does not seem to be working. Are you releasing a new version anytime soon, or if not, can you just please take the expiry checking out?

  • I’ve been working with the tool now since beta 5 and I must say great improvements! When is beta 8.2 or 9.0 to be released?

    Keep up the good work!

  • I really like this product. In many ways, it is much better than others that we would end up spending thousands of dollars on. Any chance that there can be a release that won’t time out or even be purchased?

  • Hi, I have using your app. and find it very useful. It has timed out and will not run. Is there a way to continue to use it?

  • Nice Monitor!!! For some reasons, after the upgrade, when i click on “connections” It’s shows no connection to the database. Even though i’m connected. Also, when i click the restore chain, ‘show script’ . Nothing was showing up. Advice pls.

Leave a Reply

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

Powered by sweet Captcha