Tag Archives: #2012 R2

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

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.

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.

SCOM: Updated MP for Talon FAST Storage v1.0.0.149

Talon have released an updated version of their FAST storage management pack for SCOM get it here.

In this version

  • Operational Management
    • Systems level inventory
    • Patch level inventory
  • Availability Management
    • Systems Health Status
    • Event Viewer
    • SCOM alerting
    • i.e. Key services not running
  • Systems Optimization
    • % Cache Utilized
    • Cache Purge alert via SCOM

SCOM 2016: Error while connecting to management server: The client has been disconnected from the server

When trying to install a second management server in a SCOM 2016 management group, after entering the OpsDB details,  a few moments later the wizard would return to the SQL details screen.

A brief investigation revealed the following error in the installation log file (OpsMgrSetupWizard.txt this is your best friend for troubleshooting SCOM installations):

Info:Error while connecting to management server: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.
Error: :Couldn’t connect to mgt server stack: : Threw Exception.Type: Microsoft.EnterpriseManagement.Common.ServerDisconnectedException, Exception Error Code: 0x80131500, Exception.Message: The client has been disconnected from the server. Please call ManagementGroup.Reconnect() to reestablish the connection.

First confirming that the Data Access service was in fact running on the original management server and that a connection could be made to the SDK.

It turns out that the two servers times were out of sync by more than 5 minutes causing a Keberos time skew. After correcting the server time the second management server installed with no issues.

SCOM 2016: Updated SQL Server Management Packs v6.7.31.0

New versions of the SQL management packs were released a short while ago links for all of the versions 6.7.31.0 MPs can be found below:

SQL Server

SQL Server 2008/2012 – here
SQL Server 2014 – here
SQL Server 2016 – here

SQL Server Dashboards

SQL Server Dashboards – here

SQL Server Replication

SQL Server 2008 Replication – here
SQL Server 2012 Replication – here
SQL Server 2014 Replication – here
SQL Server 2014 Replication – here

SQL Server Analysis Services

SQL Server 2008 Analysis Services – here
SQL Server 2012 Analysis Services – here
SQL Server 2014 Analysis Services – here
SQL Server 2016 Analysis Services – here

SQL Server Reporting Services (Native Mode)

SQL Server 2008 Replication(Native Mode) – here
SQL Server 2012 Replication(Native Mode) – here
SQL Server 2014 Replication(Native Mode) – here
SQL Server 2014 Replication(Native Mode) – here

 

New in this version:

Important Notes About This Release

  • Please note that we implemented a new alerting rule for SQL Server event #18456 “Login failed” in this release. However, this rule may become rather noisy due to the fact that the target events appear quite frequently in some environments. The rule is enabled by default; thus, if it creates too many alerts in your environment, consider disabling it via the override. The ideal would be to resolve the underlying issues causing the alert but we understand this is not always a priority.
  • We are introducing a new monitor in this release (see the first bullet below) based on customer feedback. You have now a better solution for monitoring backups of AG databases.

SQL Server 2008-2016

  • Added new “Availability Database Backup Status” monitor in Availability Group to check the existence and age of the availability database backups (this monitor is disabled by default)
  • “Database Backup Status” monitor has been changed to return only “Healthy” state for the databases that are Always On replicas, since availability database backups are now watched by the dedicated monitor
  • Improved performance of DB Space monitoring workflows
  • Added new “Login failed” alerting rule for SQL Server event #18456
  • Fixed issue: “Active Alerts” view does not show all alerts
  • Fixed issue: DB space monitoring scripts fail with “Cannot connect to database” error.
  • Fixed issue: PowerShell scripts fail with “Cannot process argument because the value of argument ‘obj’ is null” error
  • Fixed issue: Alert description of “Disk Ready Latency” and “Disk Write Latency” monitors displays the sample count instead of the performance value that was measured
  • Fixed issue: Different file location info from “sys.master_files” and “sysfiles” causes error when Availability Group secondary database files are in different path
  • Fixed issue: “DB Transaction Log Free Space Total” rules return wrong data
  • Introduced minor updates to the display strings
  • Deprecated “Garbage Collection” monitor and the appropriate performance rule
  • Resource Pool Discovery is disabled by default for pools not containing databases with Memory-Optimized Tables
  • “XTP Configuration” monitor now supports different file path types (not only those starting with C:, D:, etc.)
  • Fixed issue: “Resource Pool State” view shows incorrect set of objects
  • Fixed issue: Invalid group discovery in SQL Server 2016 Always On
  • Updated the visualization library

SQL Server Dashboards

  • Increased the version number to comply with the current version of SQL Server MPs

SQL Server 2008-2016 Replication

  • Added Distributor name caching to Subscription discovery
  • Restricted the length of some string class properties
  • Improved the internal structure of SQL scripts storage
  • Fixed variable types in SQL scripts
  • Fixed connectivity issues in SmartConnect module
  • Introduced minor updates to the display strings
  • Updated the visualization library

SQL Server 2008-2016 Reporting Services

  • Reimplemented Instance seed discovery: replaced the managed module with a PowerShell script
  • Reimplemented Deployment seed discovery: added a retry policy and improved error handling
  • Updated the visualization library

SQL Server 2008-2016 Analysis Services

  • Restricted length of some string class properties
  • Updated the visualization library

SCOM: Updated NiCE DB2 MP 4.20

Another updated MP released over at NiCE this time for IBM DB2 get more info here.

New with this release

  • Feature: Support of DB2 BLU Acceleration
  • Feature: Monitoring of InDoubt Transactions
  • Security: Support of DB2 restrictive databases
  • Security: Support of non-root setup and operation
  • Security: DB2 Instance attach extensions for user and password options
  • Platform: New platform support for IBM AIX 7.2
  • Platform: Support of non-standard paths for both installation path and instance user home directory

SCOM: Updated NiCE PowerHA MP 1.20

Our friends at NiCE have released an updated MP for PowerHA go here for more info.

What´s new with this release

  • Logical Disk Monitoring for Cluster File Systems
  • No False Files Systems Alarms from Microsoft® AIX Management Pack anymore!
  • Cluster-aligned Service Model
  • Improved Discovery for Cluster Resources
  • Updated Product Knowledge