Monday, July 18, 2016

Updated MP: SQL MPs, Version

The SQL MP line has been updated to version This is a major update, containing many fixes and new features. For instance, the SQL Server MP for SQL 2005, 2008, 2008 R2 & 2012 contains these fixes and new features:

  • 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

As ever, TEST these MPs BEFORE putting them into PRODUCTION. In the past there have been nasty issues with updated MPs, causing unexpected behavior, like DW bloat for instance.

So TEST yourself before you WRECK yourself.

No comments: