Jump to content


mobieus

Microsoft SQL Server 2012 Performance Dashboard Reports

Recommended Posts

NOTE: These are not System Center Operations Manager dashboards. 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.

Tuning System Center Operations Manager almost always centers around the performance of SQL. These reports provide valuable insight into the performance and health of the OperationsManager and OperationsManagerDW databases.

Common performance problems the dashboard reports may help to resolve:

  • 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

Download Now

Figure 1: Summary

sql2.gif?w=625

Figure 2: IO Statistics

sql11.gif?w=625

line3.gif?w=625

Connect with Mobieus Solutions:

Share this post


Link to post
Share on other sites


Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...