SQL Server Management Studio Reports

, 2014-11-21 (first published: )

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.

SQL SSMS Server Reports

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.

SQL Database Reports

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.

SQL Disk Usage Report

For a complete listing of the reports see the MSDN blog – MSDN Blog SSMS Reports




The post SQL Server Management Studio Reports appeared first on Derek E Wilson - Blog.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.


1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...


1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.


360 reads