SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Server Management Studio Reports

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.

Business Intelligence and Enterprise Architecture

Derek Wilson delivers tactical and strategic Business Intelligence and Enterprise Architecture solutions. His primary focus in on Microsoft SQL Server technologies and aligning business problems to technology solutions. He architects BI solutions leveraging SQL Server, SharePoint and any other technologies that help his clients achieve better data driven decisions. By leveraging the information learned while collecting requirements for BI projects, he helps align business processes to technology helping further organizations Enterprise Architecture. He is an author, trainer, blogger and has been using SQL Server since version 6.5.


Leave a comment on the original post [derekewilson.com, opens in a new window]

Loading comments...