Installing and configuring SQL Server 2012 Performance Dashboard Reports

Installing and configuring SQL Server 2012 Performance Dashboard Reports

The SQL Server 2012 Performance Dashboard Reports are Reporting Services report files designed to be used with the Custom Reports feature of SQL Server Management Studio. The reports allow a database administrator to quickly identify whether there is a current bottleneck on their system, and if a bottleneck is present, capture additional diagnostic data that may be necessary to resolve the problem.

The information captured in the reports is retrieved from SQL Server's dynamic management views. There is no additional tracing or data capture required, which means the information is always available and this is a very inexpensive means of monitoring your server.

Common performance problems that the dashboard reports may help to resolve include:

1. Ø  CPU bottlenecks (and what queries are consuming the most CPU)
2. Ø  IO bottlenecks (and what queries are performing the most IO)
3. Ø  Index recommendations generated by the query optimizer (missing indexes)
4. Ø  Blocking
5. Ø  Latch contention

To install this add-on please go through below link

http://www.microsoft.com/en-us/download/details.aspx?id=29063

Download & copy SQLServer2012_PerformanceDashboard.msi file into server where you want to install.

 

Double click on downloaded file to install SQL Server 2012 performance dashboard reports

 

Clink on run

Click on Next

 

Select I accept the terms in the license agreement  

And click on next

Enter your name and company. Click on Next button.

If you want change the default installation location click on Browse and provide appropriate location

Click on Next

Dash board report will install files in above location

Click on Install button

Click on finish button

To load reports – right click on server name and expand reports and click on Custom Reports

Select the .rdl file from below location shown as in below images

 

Click on Run button

It will give above error. You need to execute the setup.sql files located in installation directory.

Open the file in Query Analyser

 

Execute the script

 

After successful execution  please load the report by selecting .rdl file. It will show the report as below

 

 

NetFx3 error while installing SQL Server 2012 on windows 2012 server

Problem description

TITLE: Microsoft SQL Server 2012 Service Pack 1 Setup

The following error has occurred:

Error while enabling Windows feature : NetFx3, Error Code : -2146498298 , Please try enabling Windows feature : NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features , see http://go.microsoft.com/fwlink/?linkid=227143

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3000.0&EvtType=0x681D636F%25401428%25401

- 

Solution 

Goto server manager

 --> Click on manager right side corner of window

--> Click Add Roles and Features

Blow Add Roles and features wizard window appears 

click on next

in the next screen click on Role-based or feature-based installation

and click on the next

in the Server Selection Screen select the first radio button i.e. Select a Server from the Server Pool 

In the server pool window you can see the server name 

On Server Roles page simply click on next

in Features page wizard clicked on the check box next to ".NET Framework 3.5 Features", and then clicked on the Next as shown in below image

and in final wizard click on install to add features

and installation progress as below 

Thanks & Regards
Venkat Sangu