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”
