SQL Server Management Studio Reports
Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within your database is critical to the performance of your applications. One tool you can leverage to see what is happening are the built in reports in SSMS. SQL Server includes basic reports that you can run from within SQL Server Management Studio. These pre-built reports that allow you to see what is happening within your system. There are two types of reports available, server and database reports. To access the reports that are specific to the server. Right click on your server name and then select the Reports->Standard Reports and then select the report you wish to run. The included reports for the server are shown below.
If you need information on a database, right click on the database and then select Reports->Standard Reports to access the available database level reports shown here.
Many of these reports can take a while to run and consume a lot of resources. Before you run any of them on production, you should run them in development to see exactly what data they return and ensure it meets your needs.
For example, selecting and running the Disk Usage by Table in the Adventure Works database will produce the following report. This gives you a quick way to examine what tables are in the database along with how much storage is being used by the data and indexes. If you have never explored these reports, take some time to learn what is available and how they may help you improve your applications.
For a complete listing of the reports see the MSDN blog – MSDN Blog SSMS Reports