Microsoft® 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.
Common performance problems that the dashboard reports may help
to resolve include:
- CPU bottlenecks (and what queries are
consuming the most CPU)
- IO
bottlenecks (and what queries are performing the most IO)
- Index
recommendations generated by the query optimizer (missing indexes)
- Blocking
- Latch
contention
How To:
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.
"Reporting Services is not required to be
installed to use the Performance Dashboard Reports"
Download@ http://www.microsoft.com/en-us/download/details.aspx?id=29063
Another great
free tool from Microsoft !