An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedback. This version also fully supports SQL Server 2019.
Please download at:
Microsoft System Center Management Pack for SQL Server
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
Issues Fixed
- 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”
We are looking forward to your feedback.
Updated Dec 30, 2019
Version 2.0EbruErsan
Microsoft
Joined January 31, 2019
SQL Server Blog
Follow this blog board to get notified when there's new activity