Released: Public Preview for SQL Server 2017+ and Replication Management Pack (RC)
We are happy to announce SQL Server 2017+ Management Pack Release Candidate with new features is ready (6.7.65.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).
NEW: Version Agnostic SQL Server MPs
We understand that with many SQL Server versions in market and with new server releases becoming more frequent, it is becoming harder to manage a separate MP for each server version. We are moving to version agnostic MPs to address this issue. This will be valid going forward. The new MP is named SQL Server 2017+. The ‘+’ in the name indicates that it will be used to monitor SQL Server 2017 and the releases that come after that. Current in-market MPs (2008 through 2016) will not be changed and the 2017+ MP cannot be used to monitor older releases. We are making this change for SQL Server and Replication MPs. It would be great to get your feedback on this public preview before we reach GA.
Please download the public preview bits at:
Microsoft System Center Management Pack (Release Candidate 1) for SQL Server 2017+
Microsoft System Center Management Pack (Release Candidate 1) for SQL Server 2017+ Replication
New Features and Fixes for SQL Server 2017+ Windows and Linux MP (6.7.65.0)
- The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
- Reduced the number of files in the management pack
- Removed dependency on SQL Server Dashboards management pack
- Introduced a number of fixes and improvements to functionality, performance, and display strings
New Features and Fixes for SQL Server 2017+ Replication Windows MP (6.7.65.0)
- The management pack was reimplemented in order to enable monitoring SQL Server 2017 and all upcoming SQL Server versions
- Reduced the number of files in the management pack
- Introduced a number of fixes and improvements to functionality, performance, and display strings
Feature/Workflow |
CTP1 (6.7.18.0) |
CTP2 (6.7.40.0) |
CTP3 (6.7.55.0) |
CTP4 (6.7.60.0) |
RC (6.7.65.0) |
Core objects |
|||||
| DB Engine Discovery | W/L | W/L | W/L | W/L | W/L |
| Local DB Engine Discovery (windows only feature) | – | W | W | W | W |
| SQL Cluster instances | W | W | W | W | W |
| DB Discovery | W/L | W/L | W/L | W/L | W/L |
| DB Filegroup Discovery | W/L | W/L | W/L | W/L | W/L |
| DB File Discovery | W/L | W/L | W/L | W/L | W/L |
| DB Log file Discovery | W/L | W/L | W/L | W/L | W/L |
| DB Policy Discovery | – | W/L | W/L | W/L | W/L |
| Filestream Filegroup Discovery | – | W | W | W | W |
| Memory-Optimized Data Filegroup Discovery | – | W/L | W/L | W/L | W/L |
| Memory-Optimized Data Filegroup Containers Discovery | – | W/L | W/L | W/L | W/L |
| DB Engine Resource pool Discovery | – | – | W/L | W/L | W/L |
| SQL Agent Discovery | – | – | W/L | W/L | W/L |
| Always On Discovery | – | – | W | W/L | W/L |
Features |
|||||
| Agentless Monitoring | W/L | W/L | W/L | W/L | W/L |
| Mixed monitoring (windows only feature) | W | W | W | W | W |
| Agent Monitoring (windows only feature) | W | W | W | W | W |
| SQL Credentials | W/L | W/L | W/L | W/L | W/L |
| AD Credentials | W | W | W | W/L | W/L |
| In-memory OLTP support | – | W/L | W/L | W/L | W/L |
| SQL Server Express support | W | W | W | W/L | W/L |
| MSSQL LogReader module | – | W/L | W/L | W/L | W/L |
| Support long names (windows only feature) | W | W | W | W | W |
| Wizard multithreading | – | W/L | W/L | W/L | W/L |
| Tasks Execution | – | – | W/L | W/L | W/L |
| Docker Support | – | – | L | L | L |
Monitoring Scenarios |
|||||
| DB Engine Health Status Monitoring | W/L | W/L | W/L | W/L | W/L |
| DB Engine Performance Monitoring | W/L | W/L | W/L | W/L | W/L |
| DB Engine Service Pack Compliance Monitoring | – | W/L | W/L | W/L | W/L |
| DB Configuration Monitoring | W/L | W/L | W/L | W/L | W/L |
| DB Memory-Optimized Data Filegroup Performance Monitoring | – | W | W | W/L | W/L |
| CPU Monitoring and performance metrics | – | W | W | W | W/L |
| Log Shipping monitoring | – | W | W | W | W/L |
| WMI Health Monitoring | – | W/NA | W/NA | W/NA | W/NA |
| Event Base monitoring (400+ Alert rules) | – | W/L | W/L | W/L | W/L |
| DB Space Monitoring and performance metrics collection | W | W | W | W/L | W/L |
| DB Space Monitoring and performance metrics collection for Filestream objects | – | W | W | W | W |
| DB Space Monitoring and performance metrics collection for Hekaton objects | – | W | W | W | W/L |
| SQL Full-text Filter Daemon Launcher Service Monitoring | – | W/L | W/L | W/L | W/L |
| SQL Agent Monitoring | – | – | W/L | W/L | W/L |
| Always On Monitoring | – | – | W | W/L | W/L |
Legend
Completed
W – Supported on Windows
L – Supported on Linux
W/L – Supported on Windows and Linux
W/NA – Supported on Windows but no applicable to Linux
All the details regarding the new functionality can be found in the Operations Guide that can be downloaded along with the Management Pack.
We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com).