Take a look at the Database Corruption Challenge
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:
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.