OpsMgr: Sample Template for a SQL Server 2008 Database Summary Dashboard
This post features a sample management pack that includes a dashboard template that I have put together recently and shared at the TechNet Gallery .
The display name of this management pack is Sample SQL Server 2008 Database Summary Dashboard Library, and it includes a dashboard template to allow users to configure and create an instance of a sample SQL Server 2008 Database Summary Dashboard for a selected group of SQL Server 2008 Database objects within minutes by just using the IT Pro Authoring UI in the Operations Console.
The sample dashboard created will only display the list of pre-selected SQL Server 2008 Database objects and their health states, provides detailed information and visualization on performance data collected (configured to show 2 days of performance data), using the performance tile widget component defined in the Visualization Component Extensions Library Management Pack.
Here is an example of how an instance of the sample SQL Server 2008 Database Summary Dashboard created using the template, for a selected group of SQL Server 2008 Database objects would look like:
Here are the steps to configure and create a Sample SQL Server 2008 Database Summary Dashboard for a group of SQL Server 2008 Database objects using the template:
Create a group or groups of SQL Server 2008 Database objects (using dynamic or static membership) and save them in their corresponding management packs, for example:
Import the sample management pack:
Importing the management pack will allow the dashboard template to appear under the "All Templates" folder in the "New Dashboard and Widget Wizard":
Hence, to create new dashboard and save them into the management pack(s) created in (1.), select the "Dashboard View" option to create a custom dashboard under the custom management pack’s folder:
Then, select the above template (SQL Server 2008 DB Summary Dashboard) in the custom folder (WeiOutThere Samples).
Enter a name for the custom dashboard:
Select any pre-populated group of SQL Server 2008 Database objects created in (1.), as the scope for the summary dashboard template:
Standard Summary page:
… and that's it !!!
The steps to create a new sample summary dashboard for another group of SQL Server 2008 Database objects will be exactly the same:
Presentation Reminder:
In order for the Performance Tiles in the top 4 rows to display their health states (Green, Yellow or Red), the corresponding monitors that target the SQL Server 2008 Database class that are disabled by default, must be enabled.
Performance Tile (from left)
Associated Performance Counter
Corresponding Monitor
Default Setting
Performance Tile 1
DB Allocated Size (MB)
Database Status
Enabled
Performance Tile 2
DB Total Free Space (%)
DB Total Space
Disabled
Performance Tile 3
DB Avg. Disk ms/Read
Disk Read Latency
Disabled
Performance Tile 4
DB Avg. Disk ms/Write
Disk Write Latency
Disabled
Happy dashboarding !
Some useful links:
Sample Logical Disk Summary Dashboard Management Pack:
https://blogs.msdn.com/b/wei_out_there_with_system_center/archive/2013/12/19/opsmgr-sample-logical-disk-summary-dashboard-management-pack.aspx
Sample Customizable SQL Server 2008 Databases Summary Dashboard
https://blogs.msdn.com/b/wei_out_there_with_system_center/archive/2014/03/17/opsmgr-sample-customizable-sql-server-2008-databases-summary-dashboard.aspx
Operations Manager Management Pack Authoring - Dashboards
https://social.technet.microsoft.com/wiki/contents/articles/18657.operations-manager-management-pack-authoring-dashboards.aspx