Released: System Center Management Pack for SQL Server and Replication (6.6.3.0)

We are happy to announce that a new version of SQL Server and Replication Management Packs has been released! Only the English version is available at this time. Localized management packs for this version will be made available at a later time.

Downloads available:

  • Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server Database Engines, Databases, SQL Server Agents, and other related components.

Microsoft System Center Management Pack for SQL Server

Microsoft System Center Management Pack for SQL Server 2014

  • Microsoft System Center Management Pack for SQL Server Replication enables the monitoring of Replication as set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

Microsoft System Center Management Pack for SQL Server 2008 Replication

Microsoft System Center Management Pack for SQL Server 2012 Replication

Microsoft System Center Management Pack for SQL Server 2014 Replication

Please see below for the new features and improvements in the dashboards, SQL Server MPs, and Replication MPs. More detailed information can be found in guides that can be downloaded from the links above.

SQL Server Visualization Library (dashboards) features and changes in v6.6.3.0

  • Implemented batching to all data aggregation mechanisms to ensure low temp database space and log space usage.
    • Please see Notes section below for further details.
  • Implemented a control bit to divide group from non-group references to save space in aggregated data storage.
  • Fixed error message in SQL DB Discovery script that erroneously stated “… SQL Agent Job discovery script … failed”.
  • Improved performance!
  • Dashboard displays behave in line with user permissions:
    • The user can see the groups according to his/her access level only.
    • Read-Only mode for non-authors provides basic functions only: navigation, changing of the personalization settings.
  • Dark, Light, and Contrast themes have been added.

  • Synchronization errors for the personalization settings have been fixed.
  • Upgraded interface enables displaying Dashboard errors.
  • Objects with selected monitors are now displayed on the top of the tiles list while editing.
  • If there are no child elements, Related Objects tile is not displayed in Instance View.
  • A new Dashboard feature allows displaying data from any nesting level within the widgets.

  • UI design has been upgraded and various UI errors fixed.

SQL Server 2005/2008/2012/2014 MP features and changes in v6.6.3.0

  • Improved performance!
  • Added support for disabled TCP/IP protocol.
  • Fixed performance metrics error that may occur on some localized versions of Windows.
  • Fixed incorrect performance of Transaction log free space monitor.
  • Added new type of events from failed discoveries; added a new reporting rule that collects such events.
  • Added timeout overrides to prevent various scripts timeout failures.
  • Filestream filegroups are excluded from discovery until this feature is fully supported in a later version.
  • Added KB for Microsoft.SQLServer.2014.Mirroring.MirroringCommonGroupDiscovery.
  • Summary Dashboard:
    • Added monitor/performance tiles to class “SQL Server 2014 Mirroring Groups”.
    • Various bug fixes in monitor tiles.
    • Reorganized 2008/2012 tiles.
    • Removed some 1X1 tiles.

SQL Server Replication 2008/2012/2014 MP features and changes in v6.6.3.0

  • Updated Preset dashboards.

Notes

On some environments there was an issue with temp db growth and high log usage in v6.6.2.0. We’ve reviewed our approach to work with such environments and implemented batching and protection from the race situation. Log space and temp db usage is now under 500 mb for all the processing period, usually under 100 mb.

Also, timeouts are not a problem anymore, because batches are processed and committed one by one. Hanging batches will be reset to new and reprocessed if they were started more than 3 minutes ago.

Please note that on large environments initial data collection can take significant time. You can check the installation progress and result using these queries:

select * from sdk.Microsoft_SQLServer_Visualization_Library_DB_Version; — this should be 7

select count(*) — this should be 0, but it could be 1-4 if something new is being processed right now

from sdk.Microsoft_SQLServer_Visualization_Library_Table_Batches tb

where FinishDate is null;

 

If you still have an issue with installation, please collect statistics using the following queries and open an issue on the https://connect.microsoft.com/WindowsServer/SC_Public with diagnostic info.

select t.[Type], count(tb.BatchId) as Count, avg(DATEDIFF(ms, StartDate, FinishDate)) as AverageTime, sum(DATEDIFF(ms, StartDate, FinishDate)) as TotalTime

from sdk.Microsoft_SQLServer_Visualization_Library_Table_Batches tb inner join sdk.Microsoft_SQLServer_Visualization_Library_Tables t on t.TableId = tb.TableId

group by t.[Type];

select ‘Perf’ as Name, count(*) as [Count]

from sdk.Microsoft_SQLServer_Visualization_Library_LastPerfValues

UNION ALL

select ‘State’, count(*)

from sdk.Microsoft_SQLServer_Visualization_Library_LastMonitorValues

UNION ALL

select ‘Alert’, count(*)

from sdk.Microsoft_SQLServer_Visualization_Library_LastAlertValues

UNION ALL

select ‘RelationshipTypes’, count(*)

from sdk.Microsoft_SQLServer_Visualization_Library_RelationshipType_Hierarchy

UNION ALL

select ‘Relationships’, count(*)

from sdk.Microsoft_SQLServer_Visualization_Library_Relationship_Hierarchy;

 

We are looking forward to hearing your feedback about this newest release!