SQL Server 2017
Microsoft System Center Management Pack for SQL Server 2017+ enables the discovery and monitoring of SQL Server 2017+ Database Engines, Databases and other related components. It is designed to run by Operations Manager 2012 R2 or Operations Manager 2016.
This management pack was thoroughly built from the ground up in accordance with Best Practices for SQL Server; it is intended to monitor SQL Server 2017 and all upcoming SQL Server versions.
The monitoring provided by the management pack includes performance, availability, and configuration monitoring, as well as performance and events data collection. All monitoring workflows have predefined thresholds and complimentary knowledge base articles. You can integrate the monitoring of SQL Server 2017+ components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views, alert views and diagnostic tasks that enable near real-time diagnostics and remediation of detected issues.
The following list gives an overview of the features introduced by Microsoft System Center Operations Manager Management Pack for SQL Server 2017+. Please refer to Microsoft SQL Server 2017+ Management Pack Guide for more details.
Cross-platform operation: SQL 2017+ monitoring is possible both on Windows and Linux operating systems.
Agentless monitoring is now available along with traditional agent monitoring.
Usage of scripts is discontinued in favor of .Net Framework modules.
SQL Server Dynamic Management Views and Functions are now used for getting information on health and performance. Previously some of these monitors were using WMI and other system data sources.
Download diagram as a Visio file