Trace Id is missing

Copilot is your AI companion

Always by your side, ready to support you whenever and wherever you need it.
Download the Copilot app
A picture of a dog with a pop up bubble saying Talk to Copilot and asking What celeb does my dog look like?

Microsoft System Center Management Pack for SQL Server

Microsoft System Center Management Pack for SQL Server enables the discovery and monitoring of SQL Server 2012, 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.6.5

    Date Published:

    8/5/2024

    File Name:

    SQLServerMP.CustomMonitoring.msi

    SQLServerMP.Linux.msi

    SQLServerMP.Windows.msi

    SQLServerMPWorkflowList.pdf

    File Size:

    1.9 MB

    4.0 MB

    4.3 MB

    3.4 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 being 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 2012 R2, Operations Manager 2016, Operations Manager 1801/1807, Operations Manager 2019, and Operations Manager 2022. Due to the lifecycle policy, Operations Manager 2012 R2 is no longer being tested.

    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.
    For more information about this management pack, see the Microsoft SQL Server Management Pack Operations Guide.

  • Supported Operating Systems

    Windows Server 2012, Windows Server 2012 R2, 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.

Follow Microsoft

Back To Top