Back in November this year, the SQL Server Engineering Team released the latest version (18.104.22.168) of the SQL Server and Replication management packs. In addition to health monitoring capabilities, this management pack includes new and enhanced summary dashboards for SQL Server 2008 and 2012, and a datacenter dashboard template to allow users to create custom dashboards with the same visualization capabilities for other components or applications monitored by their Operations Manager environment.
The datacenter dashboard template and the new summary dashboards are based on a new standalone WPF/Silverlight application component defined in the SQL Server Visualization Library management pack from version 22.214.171.124 onwards. Since version 126.96.36.199, the components used to define the previous versions of the SQL Server summary dashboards (multi widget/component) have been deprecated and removed from the main SQL Server Visualization Library management pack. Therefore, importing any versions of this library management pack from 188.8.131.52 onwards into an Operations Manager management group would remove all the legacy components. Hence, custom dashboard created referencing the legacy components would be affected and would either show up as blank tiles or lose certain functionalities after say, version 184.108.40.206 of the SQL Server Visualization Library was imported.
THANKFULLY, the SQL Server Engineering Team has recently released a standalone and independent version of the visualization library for the community. This visualization library consist of all legacy components previously used to define the summary dashboards for SQL Server 2008 and 2012 up till version 220.127.116.11.
The file name of the visualization library with legacy components is: Microsoft.Legacy.SQLServer.Visualization.Library.mpb, version 18.104.22.168, and it can now be downloaded from the TechNet Gallery.
This legacy library management pack is independent from the current versions of the SQL Server Visualization management pack and can be imported or removed separately, without being affected by any updates or changes to the current versions going forward.
This is good because this legacy visualization library consists of individual components that allow more granularity and control as these components can be referenced in other custom dashboard to provide further insights and richness in context with monitored objects and monitoring data.
I have some examples on my blog that demonstrates these capabilities using an XML authoring or a template approach.
The following is an example of some custom widgets created based on the performance tile and monitor state tile components defined in the Microsoft Legacy SQL Server Visualization Library management pack:
Note that I will be doing some simple modifications to some of the sample summary dashboards and templates created previously for this blog to now reference the Microsoft.Legacy.SQLServer.Visualization.Library. An update will be provided in my next blog post.
Thanks again to the SQL Server Engineering Team for releasing this SQL Server Visualization Library with the Legacy Components and allowing me to share it with the community.
Happy holidays to all !