SQL MP Version

Microsoft recently released a newer version of their SQL Management Pack. You can find it here: https://www.microsoft.com/en-us/download/details.aspx?id=10631

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 2005, 2008, 2012 roles like DB Engine, Integrations Services.
  • Discovery of SQL Server 2005, 2008, 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.
  • Reports for long-term analysis of different problematic areas related to SQL Server, such as SQL Server lock analysis, top deadlocked databases, SQL Server service pack levels, user connection activity. In addition, generic reports from the Microsoft Generic Report Library can be used to review availability and performance of objects discovered by Microsoft System Center Operations Manager Management Pack for SQL Server.
  • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
  • Support for 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 rules for alerting when an Availability Replica changed its role and/or a Database Replica changed its role
  • Created a group for WOW64 SQL Server instances and disabled launching some workflows for these instances
  • Added MP version line into MP’s events generated by scripts
  • Fixed display strings and Knowledge Base articles
  • Fixed: some scripts do not return data when one of few installed instances is stopped
  • Fixed: SPN configuration monitor uses stale data
  • Fixed: Mirroring monitoring scripts fail when instance is stopped
  • Fixed Always On Database replica discovery incorrect behavior; fixed Always On policies discovery and monitoring
  • Fixed Database policies discovery and monitoring
  • Fixed and optimized CPU Usage monitoring scripts (the issue appeared when only one core was assigned)
  • Added support for more than 32 processors count in CPU Usage monitoring.
  • SQLPS module is now used for the tasks instead of deprecated SQLPS.EXE
  • Implemented FILESTREAM filegroup monitoring
  • Multiple Ports are now supported in SQL Server TCP/IP parameters
  • Fixed error occurring when no port is specified in SQL Server TCP/IP parameters
  • Fixed filegroup read-only state discovery
  • Fixed RunAs profiles mapping for some workflows
  • Implemented support for TLS 1.2 in connection logic
  • Implemented support for different client drivers in connection logic
  • Updated connection logic error logging
  • Added RunAs profiles for mirroring monitors, fixed mirroring discovery issues
  • Fixed issue: CPU usage monitor ignored SQL server limitations on CPU core count
  • Fixed display strings and Knowledge Base articles
  • Fixed error reporting in the scripts
  • Fixed intermittent “Cannot login to database” alert with some rules
  • Added support for SQL Express Instances
  • Updated Knowledge Base articles
  • Microsoft SQL Server 2012 x86 on Windows 2008 R2: fixed the issue when DB filegroups cannot be discovered
  • Win10 support: fixed “Cannot bind argument to parameter ‘Path’ because it is an empty string.” issue
  • Fixed issue when SQL Configuration Manager starts snap-in of wrong version
  • Fixed invalid Always On non-readable replica detection

Trackbacks for this post

Leave a Reply