PREMNAIR'S Blog

"..Unnatural work produces too much stress.."

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

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.

Few report examples

Advertisements

May 20, 2012 Posted by | Microsoft, Performance Dashboard, Software, SQL Server | , | Leave a comment

Apple World Wide Developers Conference – 2012

WWDC 2012…Scheduled between June 11 and 15 at San Francisco’s Moscone Center, the conference has been known for launching Apple’s newest products, software, and technologies. Rumors circulating around the web are pointing towards a MacBook Pro refresh, the release of OS X Mountain Lion and announcements surrounding the hotly anticipated release of iOS 6, Apple’s reported next-generation mobile operating system…etc. Mountain Lion is one of the highlights of WWDC 2012, and with the new operating system, Apple might announce the redesigned MacBook Pro that sports the MacBook Air-like design (with no optical drive) and will come with a new processor, a new iSight camera and might ship with 4G LTE support…..

Enjoy!!!

May 20, 2012 Posted by | Apple, Articles, iOS6, Macbook Pro, WWDC | , | Leave a comment

   

%d bloggers like this: