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:
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:
Sample Customizable SQL Server 2008 Databases Summary Dashboard
Operations Manager Management Pack Authoring - Dashboards
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.