December 14, 2014 Leave a Comment
Today I had the pleasure of releasing Beta 9.3 of the Database Health Monitor. It has been a whole week since the last beta update, and here is the outline of the new features and bug fixes.
- New report, Partitioned Tables. This new report shows all of the partitioned tables in a database. Double clicking for drill down shows the new Partitioned Tables Advisor that shows details on the number of partitions, rows in each partition and the range for each partition.
- The entire color scheme has been updated, not so blue.
- Added double click action on the one time use query report.
- The duplicate indexes chart has been migrated over to the new report format and colors.
- Performance improvements and bug fixes on the table size advisor. It is still a bit slow on really huge tables, but it works well on most.
- Fixed the drilldown when double clicking the chart view on the disk space report.
- Improved exception handling on the needs parameters report.
- Increased query timeout on the index fragmentation report.
- Improved the column layout and sizing on the following reports:
- Missing Indexes Report
- Unclustered Tables Report
- Improved error handling on all background threads when attempting to connect to a database. Better handling when the connection fails.
- Fixed a bug on the plan cache panel not linking to the right report.
- The enter key now does the same thing as double clicking for drilldown on all grids in the application.
- Based on improved crash reporting in beta 9.1 and 9.2, I was able to learn more about the common problem areas in the application. This lead to improved exception handling in many of the areas where a database connection is established, along with better error messages when a connection fails for some reason.
The Partitioned Tables Report was a new addition to the Database Health monitor with this release.
The partition tables report shows a list of all the partitioned tables in a database. As shown here, there is just one partitioned table in this test database.
Double clicking on the table [dbo].[orders] brings up the Partitioned Table Advisor which shows the number of rows in each partition, the percentage of the table represented by that partition, and the range items for the partition. In this example the partitions are split over date ranges.
I plan to keep the updates coming for some time. Every week I am learning something new to help make the product even stronger.