The free SQL Server Health report evaluates a number of areas of your database, and provides details on problems and what can be done to fix them.
One question that comes up is “what do I need to install on my SQL Server?” The answer is NOTHING, the Database Health Reports is an application that can install on your SQL Server, or it can be installed on your desktop.
Here are some screen shots:
Inefficient Indexes Report
Index Fragmentation Report
Wait Monitoring Report
- Download the Database Health Reports
After downloading and attempting to use the report, you will need to configure the datasource to connect to your server. See the help page for more details.
SQL Server Health Reports History
11/19/2011 – Created Initial Version
11/26/2011 – Added Long Running Queries
11/27/2011 – Added Duplicate Indexes
12/03/2011 – Added CPU Utilization Report
12/07/2011 – Released the database size report
12/08/2011 – Released the Backup Set Report
12/10/2011 – Fixed a couple of bugs in the Backup Set report with the line sizes in the chart. Added the new Statistics report.
01/08/2012 – Fixed some layout issues in the Index Fragmentation Report, and cleaned up some general layout issues in the rest of the reports.
03/03/2012 – Major UI Fixup. Standard header on all pages, linking from any report to any other, ability to change the database from within the report, Updated help links, added Top IO report, fixed several bugs Updated.
03/11/2012 – Minor UI Fixup. Added included columns into the Duplicate Indexes
03/16/2012 – A little more clean up and final polishing for SQL Saturday Vancouver tomorrow.
03/18/2012 – Added 2 new reports Top Cache Queries and top CPU Queries.