Ask Learn
Preview
Please sign in to use this experience.
Sign inThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
We are happy to announce SQL Server 2017 Management Pack CTP4 bits with new features are ready (6.7.60.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com).
Please download the public preview bits at:
Microsoft System Center Management Pack (Community Technical Preview 4) for SQL Server 2017 Microsoft System Center Management Pack (Community Technology Preview 4) for SQL Server 2017 Replication
Feature/Workflow | CTP1 (6.7.18.0) | CTP2 (6.7.40.0) | CTP3 (6.7.55.0) | CTP4 (6.7.60.0) |
Core objects | ||||
DB Engine Discovery | W/L | W/L | W/L | W/L |
Local DB Engine Discovery (windows only feature) | – | W | W | W |
SQL Cluster instances | W | W | W | W |
DB Discovery | W/L | W/L | W/L | W/L |
DB Filegroup Discovery | W/L | W/L | W/L | W/L |
DB File Discovery | W/L | W/L | W/L | W/L |
DB Log file Discovery | W/L | W/L | W/L | W/L |
DB Policy Discovery | – | W/L | W/L | W/L |
Filestream Filegroup Discovery | – | W | W | W |
Memory-Optimized Data Filegroup Discovery | – | W/L | W/L | W/L |
Memory-Optimized Data Filegroup Containers Discovery | – | W/L | W/L | W/L |
DB Engine Resource pool Discovery | – | – | W/L | W/L |
SQL Agent Discovery | – | – | W/L | W/L |
Always On Discovery | – | – | W | W/L |
Features | ||||
Agentless Monitoring | W/L | W/L | W/L | W/L |
Mixed monitoring (windows only feature) | W | W | W | W |
Agent Monitoring (windows only feature) | W | W | W | W |
SQL Credentials | W/L | W/L | W/L | W/L |
AD Credentials | W | W | W | W |
In-memory OLTP support | – | W/L | W/L | W/L |
SQL Server Express support | W | W | W | W |
MSSQL LogReader module | – | W/L | W/L | W/L |
Support long names (windows only feature) | W | W | W | W |
Wizard multithreading | – | W/L | W/L | W/L |
Tasks Execution | – | – | W/L | W/L |
Docker Support | – | – | L | L |
Monitoring Scenarios | ||||
DB Engine Health Status Monitoring | W/L | W/L | W/L | W/L |
DB Engine Performance Monitoring | W/L | W/L | W/L | W/L |
DB Engine Service Pack Compliance Monitoring | – | W/L | W/L | W/L |
DB Configuration Monitoring | W/L | W/L | W/L | W/L |
DB Memory-Optimized Data Filegroup Performance Monitoring | – | W | W | W |
CPU Monitoring and performance metrics | – | W | W | W |
Log Shipping monitoring | – | W | W | W |
WMI Health Monitoring | – | W/NA | W/NA | W/NA |
Event Base monitoring (400+ Alert rules) | – | W/L | W/L | W/L |
DB Space Monitoring and performance metrics collection | W | W | W | W |
DB Space Monitoring and performance metrics collection for Filestream objects | – | W | W | W |
DB Space Monitoring and performance metrics collection for Hekaton objects | – | W | W | W |
SQL Full-text Filter Daemon Launcher Service Monitoring | – | W | W | W |
SQL Agent Monitoring | – | – | W/L | W/L |
Always On Monitoring | – | – | W | 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. Full functionality will be available with SQL Server 2017 GA. This CTP release only covers a subset of monitors and rules. We will work towards full functionality as we release new CTPs.
We are looking forward to hearing your feedback (sqlmpsfeedback@microsoft.com).
Please sign in to use this experience.
Sign in