-
Management Pack:
SQL Server
-
MP Version:
6.7.7.0 for SQL Server 2012
-
Released:
10/6/2016
-
Publisher:
Microsoft
Feature Summary
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
•Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services.
•Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs.
•Monitoring of SQL Server 2012 Always On:
•Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
•Health roll-up from availability database to availability replicas.
•Detailed knowledge for each related monitoring workflow.
•Seamless integration with SQL Server policy based management (PBM): •Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
•Rollup of policy execution health to the health of related SCOM entity.
•Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
•Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
• Discover mirroring databases, witness, and mirroring group.
• Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
• Custom diagram view to represent the primary and the mirrored databases visually.
New Features and Fixes •Added support for configurations where computer host names are longer than 15 symbols
•Added "Event ID" to descriptions of all the alerts generated by the alerting rules
•Added support for databases stored on SMB Shares
•Updated the visualization library
•Removed files of SQL 2005 MP from the installer since this MP is no longer supported
•Added 2 rules for alerts generating when there are problems with execution of the monitoring workflows scripts on the following agents: "MSSQL: Monitoring failed" and "MSSQL: Monitoring warning"
•Added "MSSQL 20XX: Discovery warning" rules to generate alerts when there are non-critical problems with execution of the discovery scripts (warning events in the Operations Manager log)
•Changed "MSSQL 20XX: Discovery failed" rules to generate alerts for only critical errors during executing discovery scripts
•Improved error logging in the MP scripts
•Fixed issue: SQL Server 2012 Always On discoveries fail after stopping WSFC service
•Fixed issue: "Set DB offline" task does not work when the database is in Availability Group
•Fixed issue: user policy discovery script fails with "Invalid namespace "ROOT\Microsoft\SqlServer\ComputerManagement12" error
•Fixed issue: Always On console task does not work
•Deprecated "Run As Account does not exist on the target system, or does not have enough permissions" rule
•Fixed some issues in the scripts, which could lead to unstable work with WMI
•Fixed error logging in a script for Blocking Sessions monitor
•Fixed issue: CPU Usage monitor and 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
Download diagram as a Visio file
6.3.173.1 for SQL Server 2012
6.6.0.0 for SQL Server 2012
6.6.2.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
6.7.20.0 for SQL Server 2012