Database Health Beta 8.2 has been released

For everyone using Database Health, sorry for the delay, other projects have been keeping me far to busy.

Today I released an update to Database Health called Beta 8.2. For those attempting to use Beta 8.1, please upgrade, and this should get you going again.

The download is available at:
http://databasehealth.com/download/

Also this one never expires, so nobody should run into the timeout issue again.

Enjoy!

-Steve

Database Health Monitor – Beta 8 – Soft launch

Today I launched Database Health Reports Beta 8 as a soft launch. What I mean by the soft launch is that other than updating the DatabaseHealth website and this blog posting, I haven’t done much to promote it.  Why you might ask?  Due to it being a holiday week between Christmas and New Years, there are many people out of the office. I figured I would wait until after January 1st to make a big splash.

Beta 8 is out. The biggest change is the charting. About 75% of the charts in the system have been completely rewritten. I was using a charting module that didn’t allow for the flexiblity that was needed to make the charts look the way I wanted. In September right after the Beta 7 release I started rewriting the charts from scratch.  Between now and the next Beta I will work to get more of the charts converted over to the new look.

Here is an example of some of the newer charts. The red and green bars on the plan cache are used to indicate change.  Red indicates that the value was worse, and green indicates that it improved or stayed the same. The CPU by database chart was rewritten to make better use of the available space.

New Charts

 

Also shown in the above screen shot is the new Server Configuration panel with details on the specific version of SQL Server, when it was installed, the number of processors and more.

Beta 8 Release Notes

Beta 8 Released 12/29/2013.

The following changes have been made since Beta 7. The big feature in the Beta 8 is the rewrite of many of the charts.

New Features

  • Renamed to Database Health Monitor, attempting to avoid confusion with SSRS Reports.
  • Additional checks for obsolete or unusual settings (SHRINK_DATABASE, TORN_PAGE_DETECTION).
  • Blocking reporting with hierarchical drilldown on the blocking queries.
  • Server details panel showing logical and physical cpu counts, SQL Server Start time, SQL Server install data, Server Name, SQL Server version info, and information on real or virtual server.

Bug Fixes

  • Multithreading the re-connect of databases, vastly improving the startup time if one or more databases is not available.
  • A large amount of the project has been refactored to help mature the product and allow for additional feature growth, and reduce bugs.
  • Improved background threading.
  • Updates and bug fixes on SQL Technical Debt.

Beta 7++ Additional Cleanup on the Technical Debt

Again following the Agile philosophy of Release Early and Release Often, there is another minor release of Database Health Beta 7.  I called this one Beta 7++, the version has been updated to 1.99.7.512. In this version the following minor features were added based on customer feedback and requests.

1. When filtering the Technical Debt by a specific type, which you can do by double clicking on the Debt By Type list, you can now un-filter, or clear the filter with the “Clear Filter and Show All” button.

Beta7_512a

2. When analyzing a single object for Technical Debt, when the analysis is complete, there is now a “Refresh” button displayed below the Analyze button to quickly re-analyze the same object. Also the Analysis Complete message has been extended to include the name of the object being analyzed.

Beta7_512b

3. Unrelated to technical debt but still worth mentioning is the reduced severity on the Huge Log Files warning.  Several people had asked for this, it is now less of a forbidding warning message.

Beta7_512c

That’s it for now. Please give Beta 7 Version 5.12 a try.

Have a great day!

-Steve Stedman

Beta 7+ Filter Technical Debt by Debt Type

One of the ideas behind Scrum software development is the idea of “Release early, Release Often and Get Customer Feedback.”

After the release of Beta 7 of the Database Health Reports earlier this week I received an email with a really great suggestion that I just had to implement.  The suggestion was to be able to click on the debt type and get the list of items with that debt.

DebtTypeFiltering

 

If you are running Database Health Reports with a version (as shown in the title bar) less than 1.99.7.503 and you want this new feature, just go to the download page and download the latest version.

Database Health Beta 7 Released – Featuring SQL Technical Debt Analysis

I have been working on Beta 7 over the last 3 months, and it is finally ready.  Beta 7  has been released today featuring the addition of the SQL Technical Debt reporting.  Besides the SQL Technical debt reporting, the other area of major improvement was the overall performance of the application.  There are many areas that previously were slow or difficult to work with that have been improved overall.

A quote from one of the early preview users is the following:

Excuse my language but that’s bloody amazing – it’s instant! Wow, good work :)
The entire application is so much more responsive, can’t believe it. The new colour is fantastic too, really changes the whole ‘quality’ feel of the application.

New Features

  • Technical Debt Reporting.
  • Support for SQL Server 2014 CTP1.
  • Full support for case sensitive databases. All features have been tested and confirmed good with case sensitive databases.
  • Historic Reporting Settings Dialog – Adding the ability to turn on or off monitoring for a specific database.
  • New Page Life Expectancy Tracking to the Historic Reports.
  • New CPU historic chart to the Historic Reports.
  • New “Create Script to Update All” Statistics button added to the Statistics report.

Bug Fixes

  • Multithreading the re-connect of databases, vastly improving the startup time if one or more databases is not available.
  • Speed improvements on every page in the application.
  • Improved speed on the Database Overview and Server Overview reports.
  • Re-factoring code – reducing technical debt.
  • Historic reporting – improved cleanup of historic data to keep the DBHealthHistory database from growing too large.
  • Fixed the settings dialog for the number of days to keep historic data.
  • Performance tuning clipboard copy from grids with many rows.
  • Performance improvements on the index fragmentation report.
  • Improved disconnect/reconnect when a database is no longer available, for instance a VPN connection was dropped or reconnected.
  • Fixing bugs with minimum page settings for the fragmented indexes report. It now displays the right data.

Here is a preview of the SQL Technical Debt Analysis:

Beta7-SQLDebt

Please give Beta 7 of Database Health a try, it may make your day more productive.

Enjoy!

-Steve Stedman

Suggest An Idea for Database Health Reports

As I get ready for Beta 7 to launch I have decided that for Beta 8 I will focus on feature suggestions from the users of the Database Health application.  I have created a feedback system for users to suggest their ideas, then they can be voted on with the star rating. Users can comment on the ideas.

submitYourIdeasIf you would like to see any new features added into the Database Health Reports, please use the idea suggestion feature at the Database Health website.

Here is the link to submit a new idea:

http://databasehealth.com/is/new-idea/