Monthly Archives: November 2017

SCOM 2016: Updated MPs for SQL Server v7.0.0.0

The new management packs for SQL Server have been released get them at the links below:

SQL Server 2016

SQL Server 2014

SQL Server (2008-2012)

SQL Server Dashboards

 

New SQL Server 2008-2012 MP Features and Fixes

  • The version of the management packs was significantly increased as the SQL Server MP product family was extended with brand new management packs for SQL Server 2017+ and SQL Server 2017+ Replication. The new management packs are designed to monitor SQL Server 2017 and the upcoming versions.
  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks
  • Fixed issue: Invalid encoding of SQL instance names in Always On console tasks

 New SQL Server 2014 MP Features and Fixes

  • The version of the management packs was significantly increased as the SQL Server MP product family was extended with brand new management packs for SQL Server 2017+ and SQL Server 2017+ Replication. The new management packs are designed to monitor SQL Server 2017 and the upcoming versions.
  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Added debug information to Always On monitoring scripts
  • Disabled the alerting rule for event #18456 by default
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks
  • Fixed issue: Invalid encoding of SQL instance names in Always On console tasks

New SQL Server 2016 MP Features and Fixes

  • The version of the management packs was significantly increased as the SQL Server MP product family was extended with brand new management packs for SQL Server 2017+ and SQL Server 2017+ Replication. The new management packs are designed to monitor SQL Server 2017 and the upcoming versions.
  • Reimplemented Always On workflows to enable monitoring of Availability Groups hosting over 200 databases
  • Updated alert descriptions of Availability Group monitors: added cluster name and primary replica name
  • Implemented 3 alerting rules for events #5105 (error with physical file access), #833 (IO request has taken longer than 15 seconds), and #41144 (AO availability group failed); they are disabled by default
  • Added debug information to Always On monitoring scripts
  • Implemented “MSSQL 2014/16: HTTP Storage: Avg. Bytes/Transfer” performance rule
  • Enabled Memory-Optimized workflows for all editions of SQL Server 2016 by default, so far as all editions now support Memory-Optimized Data since SP1
  • Disabled the alerting rule for event #18456 by default
  • Optimized ProbeAction for User Resource Pool Memory workflows
  • Fixed issue: Invalid encoding of SQL names in Always On console tasks
  • Fixed issue: “XTP Configuration” monitor is in healthy state when XTP filegroup container and the transaction log are placed on different volumes of a physical disk
  • Fixed issue: Incorrect publishers’ names for SSIS EventCollection rules (SQL2016)
  • Fixed issue: GetSQL2016DBEngineWinServState.js crashes when getting neither “true” nor “false” as the second parameter (CheckStartupType)
  • Fixed issue: Invalid encoding of SQL instance names in Always On console tasks
  • Fixed issue: XTP Configuration monitor is always in Warning state for SQL Server 2016 Standard edition

SQL Server Dashboards MP

  • No changes introduced; increased the version number to 7.0.0.0 to comply with the current version of SQL Server Management Packs

System Center: First preview, version 1711 now available

The first preview of the new semi-annual channel for System Center is now available you can get it here.

Here are some of the new features that you can experience

In Operations Manager:

  • Improvements to Linux MPs
  • Linux Kerberos support
  • Improvements to Windows Server OS MP
  • One setup for all languages
  • Improved UI responsiveness with large number MPs
  • Visual Studio 2017 support in VSAE

In Virtual Machine Manager:

  • SLB Guest cluster floating IP support
  • Storage QoS at VMM Cloud
  • Storage QoS extended to SAN storage
  • Remote to VMs in Enhanced Session mode
  • Seamless update of non-domain host agent
  • Support for fallback HGS for Shielded VM
  • Host Refresher made up to 10X faster

For more information check out the MS Cloud Platform Blog

Management Pack Recap – October 2017 Wave

This is a summary of the wave of Management Packs that were released in October 2017. Information and download location in the links provided:

DHCP 2016 MP v10.0.9.0 – here
DHCP 2012 MP v6.0.7307.0 – here
SQL 2017+ MPhere

If you know of any other Management Packs that have been released recently that I may have missed leave me a note in the comments and I’ll add them