A new version of the sql agnistoc MP is out get it here

What’s New

• 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

Bug Fixes

• 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”