SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of either the server node, or the database nodes. Simply right-click the node, and select reports. The server level reports are:

And the database level reports are:

Each of these reports provide useful, timely information.

Once you have used one of the reports, that report will be at the bottom of the reports menu in addition to being in the Standard Reports submenu:

In addition, you can add your own reports to these. The Custom Reports option allows you to build your own special reports. Jes Borland has a great article here for how to create your own custom reports.

This post is for day thirty of my month-long blog series “A Month of SSMS Tips”. I have a landing page for the series at bit.ly/MonthOfSSMS. Please visit this page for an easy place to quickly view all of the other tips in this series.