RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

Microsoft® SQL Server® 2012 Performance Dashboard Reports

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"



Another great free tool from Microsoft !

Categoria: Sql Server 2012
sabato, 18 mag 2013 Ore. 14.46
  • Views Home Page: 416.112
  • Views Posts: 844.805
  • Views Gallerie: 0
  • n° Posts: 345
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003