Released: Public Preview for SQL Server 2017 and Replication Management Pack (CTP4)
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
New Features and Fixes for SQL Server 2017 Windows and Linux MP (6.7.60.0)
- Implemented Always On monitoring on Windows and Linux
- Implemented Disk Latency workflows
- Added new "Login failed" alerting rule for SQL Server event #18456
- Added support for AD Credentials in Agentless Mode on Windows
- Added DB Space Forecast report
- Fixed issue: different file location info from "sys.master_files" and "sysfiles" causes error when Availability Group secondary database files are in different path
- Fixed issue: workflows cannot connect to an instance when only Shared Memory protocol is enabled
- Introduced a number of improvements to the management pack
New Features and Fixes for SQL Server 2017 Replication Windows MP (6.7.60.0)
- Added a number of monitors and performance rules to create the same Health model as presented in SQL Server 2008-2016 Replication MPs
- Improved and refactored the management pack modules
- Fixed a number of issues
| 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).