We are getting ready to release a new version of SQL Server Management Pack. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final product so much better.
Please download at:
Microsoft System Center Management Pack (Community Technology Preview) for SQL Server
New features and fixes in this version (7.0.18.0):
- 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 to watch for disk space consumption by In-Memory and FILESTREAM data at the Database level
- Redesigned DB Space monitoring: Disabled by default all workflows targeting Filegroups, Files, Logfiles
- 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
- 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
We are looking forward to hearing your feedback.