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 …
Although clustered indexes are not required, and there are many cases where you should not use a clustered index, quite often clustered indexes can be overlooked when creating a table. This is actually more likely if you are inheriting a database from someone else who didn’t know enough about indexes. In these cases adding the right clustered index can dramatically …
Finding tables that don’t have a clustered index. Read more »
Beta 2 of the Database Health Reports will be available in the next 7 to 10 days as I finish it up. There has been a good acceptance of Beta 1 so far, and with feedback here are some of the things included in the next beta. Overall performance tuning, some of the reports run faster now, and some of …
Working on Beta 2 of the Database Health Reports Read more »
In October last year I started work on the Database Health reports project. It started out as a series of SSRS reports that I released and updated in December 2011 to March 2012. After that it became clear that the SSRS reports weren’t going to do what I was looking for so I started on the Database Health reports version …
It is finally here. Beta 1 of the Database Health Reports for SQL Server. Read more »