Microsoft System Center Management Pack for SQL Server
Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server 2014, 2016, 2017, 2019, 2022, and upcoming versions.
Important! Selecting a language below will dynamically change the complete page content to that language.
Version:
7.8.4
Date Published:
24/01/2025
File Name:
SQLServerMPWorkflowList.pdf
SQLServerMP.Windows.msi
SQLServerMP.Linux.msi
SQLServerMP.CustomMonitoring.msi
File Size:
6.2 MB
4.3 MB
4.0 MB
1.9 MB
Microsoft System Center Management Pack for SQL Server is version-agnostic, which means that it supports discovery and monitoring of SQL Server 2012, 2014, 2016, 2017, 2019, 2022, and upcoming versions. Due to the lifecycle policy, SQL Server 2012 is no longer tested.
With this management pack, you can monitor various SQL Server components, such as Database Engines, Databases, and other SQL-related objects.
Monitoring gives you the insights about such metrics as performance, availability and configuration monitoring, performance and event data collection.
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 diagnostic and remediation of detected issues.
You can easily integrate monitoring of SQL Server components into your service-oriented monitoring scenarios.
Microsoft System Center Management Pack for SQL Server is intended for Operations Manager 2016, Operations Manager 2019, and Operations Manager 2022.
Feature Summary
The following list provides a brief overview of the features available in Microsoft System Center Operations Manager Management Pack for SQL Server:
- Cross-platform operation: Monitoring is possible both on Windows and Linux operating systems (SQL Server 2017 and up).
- 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.
Supported Operating Systems
Windows Server 2016, Windows Server 2019, Windows Server 2022, Linux
For detailed system requirements, refer to the Microsoft SQL Server Management Pack Operations Guide.- For detailed instructions on setup, configuration, and monitoring, refer to the Microsoft SQL Server Management Pack Operations Guide.