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

SCOM 2016: Update Rollup 4 released!

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.
  • The UseMIAPI registry subkey prevents collection of custom performance rules data for all Linux servers.

Known issues

  • During Audit Collection Services (ACS) update or removal, the Audit Collection Services Collector Setup wizard is incorrectly titled “System Center Operations Manager 2012 Audit Collection Server.”
  • When you access Silverlight dashboards, a “Web Console Configuration Required” message is displayed.

    To work around this issue, follow these steps:

    1. Click Configure in the dialog box.
    2. When you are prompted to run or save the SilverlightClientConfiguration.exe file, click Save.
    3. Run the SilverlightClientConfiguration.exe file.
    4. Right-click the .exe file, click Properties, and then select the Digital Signatures tab.
    5. Select the certificate that has Digest Algorithm as SHA256, and then click Details.
    6. In the Digital Signature Details dialog box, click View Certificate.
    7. In the dialog box that appears, click Install Certificate.
    8. In the Certificate Import Wizard, change the store location to Local Machine, and then click Next.
    9. Select the Place all certificates in the following store option and then select Trusted Publishers.
    10. Click Next and then click Finish.
    11. Refresh your browser window.

SCOM 2016: Updated MP for SQL 2017+

Hot off the press an updated management pack for monitoring of SQL 2017 and all future versions of SQL get version 6.7.65.0 here

New in this version:

  • The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
  • Introduced a number of fixes and improvements to functionality, performance, and display strings
  • Reduced the number of files in the management pack
  • Removed dependency on SQL Server Dashboards management pack

SCOM 2016: Updated MP DHCP 2012 v6.0.7307.0

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.

Management Pack Recap – September 2017 Wave

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

Talon FAST Storage MP v1.0.0.149 here
Unix and Linux MPs v7.6.1076.0  – here

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

SCOM 2016: Updated MP DHCP 2016 v10.0.9.0

A new version of the DHCP 2016 management pack has been released get version 10.0.9.0 here

Changes in this version:

  • Fixed issue: 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.
  • Fixed issue: 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.
  • Fixed issue: 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
  • Fixed issue: “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
  • Fixed issue: “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
  • Fixed issue: “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.