SQL Server Management Studio 2005 (SP2) updates has a wide range of reports that give the users vital information about server health and database objects.  You can even add your own custom reports to create you own application database dashboards.  The reports are created just like SQL Server Reporting Services RDL’s.

Some Links to help you along:

Listing of some Available Reports HERE

How to make your own Custom Reports HERE