Microsoft System Center Management Packs (Community Technical Preview 1) for SQL Server

  • Article

Download here: https://www.microsoft.com/en-us/download/details.aspx?id=51645

 

Details

Note: There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.

image

New Microsoft System Center Management Packs (Community Technical Preview 1) for the following SQL Server products:

  • Microsoft SQL Server 2008/2008 R2/2012
  • Microsoft SQL Server 2014/2016

Downloads available:

  • Microsoft System Center Management Pack for SQL Server 2008/2008 R2/2012 (6.7.3.0)
    This Management Pack provides both proactive and reactive monitoring of Microsoft SQL Server 2008, SQL Server 2008 R2 and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
  • Microsoft System Center Management Pack for SQL Server 2014 (6.7.3.0)
    This Management Pack enables the monitoring of the following features:
    SQL Server 2014 Database Engines (supported editions: Enterprise, Business Intelligence, Standard, Express), SQL Server 2014 Databases (including file groups, data files and transaction log files), SQL Server 2014 Agent, SQL Server 2014 Always On Availability Groups, SQL Server 2014 Failover Clusters, SQL Server 2014 Mirroring, SQL Server 2014 Memory-Optimized Data, SQL Server 2014 Managed Backup to Windows Azure, SQL Server 2014 Integration Services.
  • Microsoft System Center Management Pack for SQL Server 2016 (6.7.3.0)
    This Management Pack enables the monitoring of the following features:
    SQL Server 2016 Database Engines (supported editions: Enterprise, Business Intelligence, Standard, Express), SQL Server 2016 Databases (including file groups, data files and transaction log files), SQL Server 2016 Agent, SQL Server 2016 Always On Availability Groups, SQL Server 2016 Failover Clusters, SQL Server 2016 Mirroring, SQL Server 2016 Memory-Optimized Data, SQL Server 2016 Managed Backup to Windows Azure, SQL Server 2016 Integration Services.

The new features and fixes introduced in CTP1 management packs are as follows:
New SQL Server 2008/2008 R2/2012 MP Features and Fixes

  • Added support for databases stored on SMB Shares
  • Fixed error logging in a script for Blocking Sessions monitor
  • Removed files of SQL 2005 MP from the installer since this MP is no longer supported
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed Non-Readable Replica detection (Always On)
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

New SQL Server 2014/2016 MP Features and Fixes

  • Disabled Memory-Optimized Data Garbage Collection Fill Factor monitor and rule by default
  • Disabled Memory-Optimized Data workflows for all SQL Server instances, except for Developer, Enterprise, and Evaluation editions
  • Fixed issue: CPU Usage monitor & rule did not work for SQL Server cluster instance
  • Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
  • Fixed issue: in some cases, Set Database Online/Offline tasks did not work for databases of SQL Server 2016 cluster instance
  • Made detection condition stricter for DB User Policy event-based discovery: added management group name
  • Made detection condition stricter for Script Failed alerting rule: added management group name

For more details, please refer to the user guides that can be downloaded along with the corresponding Management Packs.
The Operations Manager team encourages you to provide any feedbacks on the management packs by sending them to sqlmpsfeedback@microsoft.com.

System Requirements

Supported Operating System: Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2

Other Software: System Center Operations Manager 2012 SP1, System Center Operations Manager 2012 R2