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.

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.

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.

UR4 for SCOM 2016 is out you can get it here or through windows update.

As usual test before implementing in your production environment and take special note of the known issues.

Issues that are fixed and improvements

When a log file is being monitored by SCOM, Monagent locks the file and won’t allow it to be renamed.

Adds support for TLS 1.2. For more information about how to set up, configure, and run your environment with TLS 1.2, see the following article in the Microsoft Knowledge Base:4051111 TLS 1.2 Protocol Support Deployment Guide for System Center 2016

Addresses an issue in which the APM AppDiagnostics console fails to create a Problem Management rule due to a FormatException. The appropriate string is now used for formatting, and the Problem Management wizard is able to run without issues.

This update resolves an issue that causes a crash of IIS application pools that are running under CLR 2.0 when the APM feature is installed on the server as part of SCOM Agent. The code now uses appropriate memory instructions, based on the CLR version.

Failure of GetOpsMgrDBWatcherDiscovery.ps1 script causes the Monitoring Host to crash.

WMI Health monitor doesn’t work if WINRM is configured to use https only.

SCOMpercentageCPUTimeCounter.ps1 script generates WMI errors that are caused by Service Principle Name (SPN) configuration issues.

WMI Health monitor doesn’t work if SPN http://servername is set to a user account.

Product knowledge of “Windows Cluster Service Discovery” includes an incorrect reference to “Windows NT.”

After a network outage, the management server does not reconnect to the gateway server if the gateway server was installed with the /ManagementServerInitiatesConnection=True option.

A configuration change to the network device triggers a rediscover of the device, and this process changes the SNMP agent address.

A new version of the DHCP 2012 management pack has been released and has lots of bug fixes, get version 6.0.7307.0 here

Updated in this version:

DHCP Failover Server Relationship Discovery was failing as the Scope ID length max limit was 4000. The Scope ID length limit has been increased to 65536.

Alert description for “DHCP IPv4 Runtime Service Bound to Static IP Address Monitor”,”DHCP Dependent Service Health Monitor”,”DHCP Database Integrity Monitor” have been updated, users can comprehend and troubleshoot the situation better with such information.

To reduce the alert noise created with multiple alerts of same type, the alert rules “DHCP Back Up Database Warning Rule”, “DHCP IPv4 Runtime DNS Registration Rule”,” DHCP IPv4 Runtime Users Group Configuration Rule” and “DHCP Database Integrity Warning Rule” are suppressed so that only the alert count increases and not generate new alerts

“Collect ALL DHCP Server Performance Data” rule has been fixed to ingest right data in the registry key, thus indicating the correct health state of the entity

“DHCP Performance Health Monitor” which was always in not-monitored state has been rectified to correctly show the health state of the entity it monitors

“DHCP Server 2012 R2 Super Scope Addresses Available Percentage Monitor” that was failing to change state on critical alerts, has been fixed to show the appropriate state so the users do not miss out on critical state.