Standard Reports in SSMS 2008 R2


I am using SQL Server Management Studio (2008 R2) for quite some times and found the Standard Reports feature is very helpful. In case you have not tried it so far, there are various reports available when you install SQL Server and you can find a lot of information about your instances and databases from it. I use two reports most of time at work, Server Dashboard Report and Disk Usage Report. Connect to the SQL Server instance using SSMS, right-click on the server instance, go to Reports –> Standard Reports –> Server Dashboard.

1. Open Server Dashboard Report

This report gives you a lot of information about your SQL Server instance, like SQL Server Edition, Server Collation, Number of databases, Number of active transactions, to name a few.

Server_Dashboard

However, the other information, which you might be interested in, is not displayed by default, Non-default Configuration Options. The non-default configuration options display the Server settings which are modified since the installation of the SQL instance. Most of the organization have followed certain configuration settings for their SQL Server environment, this report will help you to find out whether the required settings are applied for the given instance. As we can see from the above screenshot, the above configurations have been modified since the instance was installed.

Non-Default-Configuration

Another report, which I find very useful, is the Disk Usage Report. To open the disk usage report, right-click on the database, select Reports –> Standard Reports –> Disk Usage. This report provides the information about the space used by the database, along with the space used by various data and log files, along with the percentage of space used by each files. In a shared environment, often you have to notify your customers about the disk space usage by their respective databases, this report will become handy in such scenarios. I used this report everyday in my current assignment, this saves a lot of time, while notifying my customers about their current disk space usage.

Disk_Usage_Report

These reports save a lot of time for me at work. Hope, you may find it useful.
Advertisements

About Sudeepta Ganguly

A SQL Server User... Still Learning
This entry was posted in How To, SQL Server, SQL Server Tools and tagged . Bookmark the permalink.

2 Responses to Standard Reports in SSMS 2008 R2

  1. Pingback: Amazing SQL server tools every DBA must have!!! – Part 2 | SQL Server Blogs

  2. Pingback: Amazing SQL server tools every DBA must have!!! – Part 2 | DBCouncil

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s