Select Page

Download

The January 2017 download of Database Health Monitor now available (January 2, 2017). Download today and use it for Free.

Download Database Health Monitor

January 2, 2017- Version 2.4.5 (885):  DatabaseHealthInstall_January2017.zip  <<– Download Link

  • Download the zip file
  • Open the zip file, and run setup.exe.

If you have been using a previous version of Database Health Monitor, just download and install this version over the previous one.

Thank you for using Database Health Monitor.  Give us your thoughts by filling out our User Survey.

Version 2.4.5 Release Notes – January 2017.

Version 2.4.5 is the January 2017 release of Database Health Monitor.

New Features in 2.4.5

  • Added color coding to the disk space report to show drives with less than 10% free in red.
  • New logos and branding on the splash screen.
  • New application icon.
  • Added color coding to the disk space report to show disks with less than 10% free in red.
  • Updated version checks to the latest service pack and cumulative update levels for SQL Server versions. Updated the web site documentation for SQL Server versions.

Bug Fixes in 2.4.5

  • Performance improvements on the Deep Scan report.
  • Fixed bug with duplicates in the blocking report. Adding a column for the blocking path that shows the blocking chain for each blocked item.
  • Fixed bug with connecting to an instance with historic monitoring that is monitoring itself.
  • Fixed bug with the decimal calculation on the disk space report.

Version 2.4.4 Release Notes – October 2016.

Version 2.4.4 is October 2016 release of Database Health Monitor.

New Features in 2.4.4

  • Updated version numbers in the quick scan report and the updates available messages to match the latest SQL Server releases.
  • Adding a right click menu option to the Quick Scan Report for warnings about no recent DBCC CheckDB to include a menu item to jump right to the DBCC CheckDB report.
  • Added a right click menu option to the Quick Scan Report for error log messages to jump directly to the error log report.
  • Added addition details and documentation for wait types into the Waits Advisor.
  • Updated the What is Active report to have a seconds column to not just show the active query, but to also show the whole batch that it came from. For instance if one query in a stored procedure was what was currently running, you can see that in one column, and the entire stored procedure in another column.

Bug Fixes in 2.4.4

  • Queries in the historic monitoring were being truncated when longer than 4000 characters. Now they are not truncated.
  • Quickscan now ignores the alert warnings when the database is a SQL Express database (with no agent).
  • Fixed bugs in the duplicate index reports around indexes on tables with the same name in different schemas.
  • Fixed bug with the historic monitoring not being able to monitor an instance with a name greater than 20 characters.

Database Health Monitor

 

34 Comments

  1. Francis

    I was working on building my own application (for learning purposes and for practical use) using DMVs and came across your app. Very nice application! Nice Application!

    Reply
    • SteveStedman

      Thanks for the feedback. I am glad you like the application! Have a great day.

      Reply
  2. Michael

    Love the new version.

    Reply
  3. Dinesh Modi

    Hello Steve, 8.1 has expired. Any plans for 8.2? I really rely on this tool for doing a lot of maintenance on my database and will appreciate a new version or for the expiry check to be removed from the existing version. Thanks in advance for your consideration.

    Reply
  4. Bojan

    Hi,
    Beta 8.1 expired, no new version, old one does not work.
    What to do?

    Best regards
    Bojan

    Reply
  5. deleor

    Now, I must tell you, this is one of the best tool I’ve used- Dele

    Reply
    • Steve Stedman

      Thanks for the feedback. I appreciate it.

      Reply
  6. SYed

    Its pretty cool and useful. i would like out to print out the report. is there any option ?

    Reply
    • Steve Stedman

      Printing is something that we have on the to do list. It is not yet available.

      Reply
  7. Daotman

    I get Beta expired and can’t open the app even after downloading the latest version

    Reply
  8. Eugene van den Bergh

    Thanks for the great product Steve, you make our lives so much easier, thanks for all the time and effort you put into making our lives easier. Just wanted to check with you if there was any probability of a version with web interface anywhere in the pipeline ?

    Reply
    • Steve Stedman

      I am not currently working on a version with a web interface, but it is a good idea. Thanks!

      Reply
  9. Rui Bastos

    It’s the first time I see so many useful DMVs packed together in a easy way! Funny thing: it “complains” about Holla Halagreen backup scripts because they’re too long 🙂

    Reply
    • Steve Stedman

      I know that the scripts from Ola Hallengren are awesome, and I recommend them all the time. Sometimes you just need to exclude some functions or stored procedures from the technical debt check.

      Reply
  10. Dennis Nielsen

    Which SQL versions are supported?

    Reply
    • Steve Stedman

      SQL Server 2005, SQL Server 2008, SQL Server 2008R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016 are all supported in Database Health Monitor.

      There are a few minor features that don’t show up with SQL Server 2005 as the functionality required was not available in SQL Server 2005.

      Reply
  11. dao

    Is there a way to disable automatic servers connections on start up?

    Reply
    • Steve Stedman

      Currently there is not, but that is a great idea. I have added this to my list of things to work on.
      Thanks for the suggestion.

      -Steve Stedamn

      Reply
  12. Andrey

    Hello!
    Thank you for the product Steve!
    Could you add support AlwaysON AG? Definition when you connect? Report, status, recommended, etc. May be Best Practice.

    Reply
    • Steve Stedman

      Andrey, your suggestion has been added to the product backlog or our To Do List. If you have an specific details on what you are looking for that would be helpful as we decide what to include in the next release.

      Thanks,
      Steve Stedman

      Reply
  13. Andrey

    Example: Connect to listner – In the main window is displayed in which the replica is connected (in the case of the FCI – which Noda). – When you go to an instance to display the number of nod/replicas and their statuses, as well as AG. To add a report on the database status information in AG. Could be something else. Same question for DB DBHealthHistory. As pravino to add it in AlwaysON? will work correctly if you create it on the primary replica, and then add to the availability group? The correct statistics will be in this database?

    Reply
    • Andrey

      T add database DBHealthHistory to AlwaysON AG. Push TestConnection.

      5. Testing monitoring process from sql-aotest-list local.
      ERROR: The OLE DB provider “SQLNCLI11” for linked server “sql-aotest-list” reported an error. Authentication failed.
      Cannot initialize the data source object of OLE DB provider “SQLNCLI11” for linked server “sql-aotest-list”.
      OLE DB provider “SQLNCLI11” for linked server “sql-aotest-list” returned message “Invalid authorization specification”.
      OLE DB provider “SQLNCLI11” for linked server “sql-aotest-list” returned message “Invalid authorization specification”.

      Reply
      • Steve Stedman

        For versions 2.1 to 2.4.1 there was a problem with the linked server being created from the monitoring instance. If you download version 2.4.2 (860) or newer, delete the linked server called sql-aotest-list and then restart the database health historic wait monitoring, that should fix the linked server issue.

        Reply
  14. dao

    I am on version to 2.4.2 , how do I enable the new features for SSRS ?

    Reply
    • Steve Stedman

      On version 2.4.2 (or newer) just navigate to the instance running the Report Server Database, and click on the ReportServer database in the heirarchy. The overview page for the report server database will show the new reporting for SSRS.

      -Steve Stedman

      Reply
      • dao

        That does not seem to work if the name of the reporting database is not the default name of ReportServer

        Reply
        • Steve Stedman

          Yes, I discovered the same thing. that will be fixed in the 2.4.3 release. Sorry about that.

          -Steve Stedman.

          Reply
          • Steve Stedman

            This has been fixed in the July 2016 release of Database Health Monitor version 2.4.3.

  15. Baine

    Awesome. Good stuff Steve! Yet again.

    Reply
  16. Ashok Mehan

    do you have a mac version?

    Reply
    • Steve Stedman

      No… Sorry, but no Mac version.

      -Steve Stedman

      Reply

Trackbacks/Pingbacks

  1. » It is finally here. Beta 1 of the Database Health Reports for SQL Server. Steve Stedman - [...] Today (September 1, 2012) I have released the Beta 1 of the Database Health reports project. [...]
  2. » Working on Beta 2 of the Database Health Reports Steve Stedman - [...] has been a good acceptance of Beta 1 so far, and with feedback here are some of the things…
  3. » Finding tables that don’t have a clustered index. Steve Stedman - [...] Take a look give it a try.   This report will be in Beta 2, which will be available…
  4. » Finding the contents of the Plan Cache Steve Stedman - [...] do I find the contents of the SQL Server Plan Cache?”   My first response is just use the…
  5. » Database Health Beta 2. Stedman Solutions - [...] Today we released Beta 2 of the Database Health Project. [...]
  6. » Database Health Reports – Historic Waits Report Sneak Preview Steve Stedman - [...] now please download Beta 2 of the Database Health Reports or register on this site and you will be informed…
  7. » Reminder… Please Register for Beta 3 Steve Stedman - [...] Wait Monitoring.  Here is an example screen shot of the Historic Wait Monitoring.  Beta 3 of the Database Health Reports…
  8. » Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Steve Stedman - [...] Here is a preview of the Query Waits Advisor, which will be available soon in Beta 3. [...]
  9. » Unleashing CTEs in SQL Server – Slides and Sample Code – Olympia SQL Saturday Steve Stedman - [...] Here is a preview of the Query Waits Advisor, which will be available soon in Beta 3. [...]
  10. » Beta 3 is Now Available. Steve Stedman - [...] 18, 2012 by SteveStedman Leave a Comment Download this page in PDF formatOne big new feature…
  11. » Beta 4 of the Database Health Reports Steve Stedman - [...] http://databasehealth.stevestedman.com/download/ [...]
  12. » Over 300 Dowloads of the Database Health Reports Steve Stedman - [...] If you haven’t tried out the Database Health Reports project you can get it from the FREE download page. [...]
  13. » Database Health Reports – Beta 5 Released Today. Steve Stedman - [...] The Database Health Reports application provided free of charge to the SQL Server community. Enjoy! [...]

Submit a Comment

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

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.