The new version of the SQL management pack for SCOM has become available at the close of the year. Thank you for the present!
The new version agnostic pack has version 220.127.116.11 and is compatible with SQL 2019 as well. So it covers SQL versions from 2012 and up without the need to create overrides x times for each version separately.
I saw a few items in the list of fixes and changes that we ran into before, so happy to see the progress.
The new pack can be downloaded here: https://www.microsoft.com/en-us/download/details.aspx?id=56203
I will copy the list of changes and fixes below. As you can see this is an interesting list.
- Updated MP to support SQL Server 2019 RTM
- Added filter by edition to “Local DB Engine Discovery”
- Redesigned DB Space monitoring to improve performance: Enabled by default monitors and performance rules targeting Database which watch for disk space consumption by ROWS Filegroups and Logfiles
- Redesigned DB Space monitoring: Added two monitors and two performance rules targeting Database to watch for disk space consumption by In-Memory and FILESTREAM data
- Redesigned DB Space monitoring: Read-only filegroups now count as well
- Redesigned DB Space monitoring: Disabled by default all workflows targeting Filegroups, Files, Logfiles
- Redesigned XTP performance counters to make them completely version-agnostic
- Added attribute “TCP Port” to “SQL DB Engine Class” and updated “DB Engine Discovery” to populate the new property
- Added summary dashboard for SCOM 2019 Web Console (HTML5)
- Added support for cluster nodes with disjoined namespaces
- Added sampling to algorithm of monitor “WMI Health State” in order to eliminate false alerting on cluster SQL Server instances
- Updated alert descriptions of monitors “Availability Database,” “Availability Replica,” and “Availability Group” (generating alerts still disabled by default)
- Updated monitor “Product Version Compliance” with versions of most recent public updates to SQL Server
- Disabled by default monitor “Buffer Cache Hit Ratio” and changed its threshold from 0% to 90%
- Disabled by default monitor “Page Life Expectancy”
- Removed monitors “Availability Database Join State” and “Availability Replica Join State” as not useful
- Updated display strings
- Revised columns on DB Engine state views
- Fixed: monitor “Service Principal Name Configuration Status” raises false alerts because of case-sensitive comparison
- Fixed: “Local DB Engine Discovery” crashes when Windows has Turkish locale
- Fixed issue that caused performance degradation in workflows “General Always On Discovery,” “Database Replica Discovery,” and “Always On System Policy Monitoring”
- Fixed: “General Always On Discovery” throws errors on environments with several Distributed Availability Groups
- Fixed monitoring issue in case of Database is replicated by Always On Availability Group
- Fixed empty property bag when Availability Group has cluster type NONE
- Fixed wrong target in alerting rule “DB Backup Failed to Complete”
- Fixed rule “MSSQL Integration Services on Windows: The package restarted from checkpoint file” and its alert
- Fixed rule “OS Error occurred while performing I/O on pages“ and its alert
- Fixed: “DB Disk Write Latency” and “DB Disk Read Latency” monitors and performance rules get wrong performance metric
- Fixed alert description of monitor “WMI Health State”
That’s a nice listing indeed.
Happy monitoring in the new year as well! Bob