jump to navigation

Using SQL Server 2012 Performance Dashboard Reports July 16, 2012

Posted by fofo in Sql Server, SQL Server 2012.
Tags:
trackback

In this post I would like to talk about various reports ( SQL Server 2012 Performance Dashboard Reports ) that are available to us (through Microsoft Download) and their purpose is to give us an overview of the overall performance of a SQL Server instance.Basically they can help us identify where bottlenecks (CPU,IO) can be found.These reports identify where blocking occurs (waits-latches).You do not have to install SQL Server Reporting Services in order to use these reports.They retrieve all the data they present us through DMVs.

You can download these reports here. The installation process is straight forward and you just need to follow the steps of the installer.

Once these reports (these are simply Reporting Services report files) have been installed we can use them through SSMS (Custom Reports).

There are Standard Server reports available to us.Let’s have a look at what standard reports are available to us at the server level.We have reports on queries performance (filtered by IO,CPU), transactions that cause blocking,locking,memory consumption on the server e.t.c.

Please have a look at the picture below

I have chosen the first report (Server Dashboard) – This report provides overview data about the SQL Server instance and its configurations.

Have a look at the picture below

There are Standard reports at the database level as well.We can have Disk Usage reports,backup and restore events reports and much more.

Have a look at the picture below

For this example I have chosen the Index Usage Statistics report.

Have a look at the picture below

Let me show you how to use SQL Server 2012 Performance Dashboard Reports after you install them. You just right- click on the server in the Object Explorer, then choose Reports from the context menu and then Custom Reports.

Have a look at the picture below

Then in the Open File Dialog box choose performance_dashboard_main report file (you must know the folder where all these reports are kept- e.g “C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Performance Dashboard” folder)  and click Open to display the report.

Please have a look at the picture below that shows the output of this particular report.

Have a look at the rest of the Custom Reports (Waits,IO Statistics) by selecting the links from the main report.

Hope it helps!!!

About these ads

Comments»

1. Dot Net Rules : Using SQL Server 2012 Performance Dashboard Reports - July 16, 2012

[...] Services in order to use these reports.They retrieve all the data they present us through DMVs. (read more) Share Posted: Δευτέρα, 16 Ιουλίου 2012 7:10 μμ από το μέλος [...]

2. Darshan Shah - September 6, 2012

Great. Can we use it on production server?

fofo - September 6, 2012

yes of course

3. Diego Olave - January 2, 2013

Hi, tanks for you help I have one problem, no work IO statics, say no have instance for connection to read data

4. Jitendra - February 7, 2013

Can we clear the existing data for report? or can we get report for specific duration?

5. SQL Performance Related Tools Collection - Path-to-mordor - Site Home - MSDN Blogs - December 24, 2013
6. SQL Performance Related Tools Collection | Geekness in Words - December 25, 2013

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

Follow

Get every new post delivered to your Inbox.

Join 1,788 other followers

%d bloggers like this: