Beta 2 of the Database Health Reports has just been released. The new Beta contains several bug fixes, and several new features. Here is a breakdown of what is new or changed since the last beta.
New Features
- Added the Memory by Database panel to the Database Overview page.
- Added the Memory by Database report.
- Added Unclustered Tables Report.
- Added the Connections Advisor which is linked to from the Connections Report.
- Added the Missing Index Advisor.
- Additional wait type descriptions added into the Waits Advisor.
- Added the Triggers by Table report.
Bug Fixes
- Performance tuned the Page Reads and Page Writes reports which were having some difficulty on larger databases.
- Fixed bug with the Plan Cache Report which was only showing data for the master DB originally, now it shows for the appropriate database.
- Performance tuning on the Table Size Advisor dialog. There is a lot going on with this, it may take some time, but it is faster than before.
- Performance tuning on the Fragmented Indexes Report.
- Improved error handling on connection failures such as invalid password or a bad username.
- Removed backup status for TempDB as this really didn’t make any sense. Why would anyone backup TempDB.
Download the free Beta 2 version and give it a try.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!