The SQL Server 2012 Presentation Management Pack was released together with the September 2013 version of the SQL Server Monitoring Pack.
This new MP contains a new dashboard component: The SQL Server 2012 Databases Summary Dashboard. It is a combination of a state widget, a detail widget, an alert widget, a free space widget and a performance tile widget in a single dashboard layout.
It references hence requires both the SQL 2012 (Discovery) Management Pack and Visualization Component Extensions Library Management Pack to be imported as well.
Here is an example of a dashboard, the Sample Logical Disk Summary Dashboard, that displays the list of all monitored Logical Disk instances and their health states, provides detailed information and visualization on performance data collected, using the performance tile widget component defined in the Visualization Component Extensions Library Management Pack.
I also wanted to use this sample dashboard as a book plug for: PowerShell Deep Dives.
It is an in-depth PowerShell book written by some of the most prominent PowerShell MVPs, FTEs and PFEs on the planet. My good friend and colleague, Chris Bellée is one of them.
The project was created as a not-for-profit, so all proceeds go to “SAVE THE CHILDREN". For more information, please visit: http://manning.com/hicks/
Why are you plugging the PowerShell Deep Dives book in the same article as an OpsMgr dashboard you ask ?
With OpsMgr, you can create PowerShell-based performance collection rules and unit monitors for the logical disk instances of your monitored servers.
Hence, on the dashboard, you can rollup the health state of the monitor to the logical disk instance in the state widget, and show the performance charts of the selected object in the performance tile widget based on the data collected by the PowerShell based collection rule! :)
For more information on how to create a Powershell-based 2 state monitor, go to: http://gallery.technet.microsoft.com/Sample-Management-Pack-17b76379
The Sample Management Pack Bundle (MPB) for the Logical Disk Summary Dashboard can be downloaded from the TechNet Gallery.
Here is a graphical representation of the dashboard composition:
For more information about OpsMgr 2012 Dashboard Component Types and Implementations,
Go to: http://social.technet.microsoft.com/wiki/contents/articles/18657.operations-manager-management-pack-authoring-dashboards.aspx
All information on this blog is provided on an as-is basis with no warranties and for informational purposes only. Use at your own risk. The opinions and views expressed in this blog are those of the author and do not necessarily state or reflect those of my employer.