Trace Id is missing

Maximize the everyday with Microsoft 365

Get online protection, secure cloud storage, and innovative apps designed to fit your needs—all in one plan.
For 1 personFor up to 6 people
A young woman works on a Surface laptop while Microsoft 365 App icons whirl around her head.

Microsoft System Center Management Pack (Community Technology Preview) for Azure SQL Database

This management pack provides capabilities to discover, monitor, and manage your Microsoft Azure SQL Databases

Important! Selecting a language below will dynamically change the complete page content to that language.

  • Version:

    7.0.25.0

    Date Published:

    9/8/2020

    File Name:

    AzureSQLDatabaseMPGuide.pdf

    Microsoft.SqlServer.Azure.ManagementPack.CTP.msi

    SQLServerDashboardsGuide.pdf

    File Size:

    2.3 MB

    3.6 MB

    1.6 MB

    The Microsoft Azure SQL Database Management Pack enables you to monitor the availability and performance of applications that are running on Microsoft Azure SQL Database.

    Note: This Management Pack is not part of Microsoft System Center Management Pack for Microsoft Azure. The Management Pack is designed to provide enhanced monitoring of Microsoft Azure SQL Database metrics.

    Feature Summary
    After configuration, the Microsoft Azure SQL Database Monitoring Management Pack offers the following functionalities:
    • User-friendly wizard to discover Microsoft Azure SQL Database servers.
    • Multiple subscriptions and multiple Microsoft Azure SQL Database servers are supported.
    • Two options for getting information on Azure SQL Database health: Azure Resource Manager (Azure REST API) and T-SQL queries to SQL Server system views.
    • Azure AD authentication is supported.
    • Collects and monitors health of Microsoft Azure SQL Database databases:
      • Database availability
      • Database space monitoring
      • Track the total number of databases per server
      • Successful connections count
      • Failed connections count
      • Number of deadlocks
      • Throttling/long transactions count
      • Connections blocked by firewall count
    • Collects and monitors health of Microsoft Azure SQL Database servers:
      • Server availability
      • Average memory per session
      • Total memory per session
      • Total CPU time per session
      • Total I/O per session
      • Number of database sessions
      • Maximum Transaction execution time
      • Maximum Transaction lock count
      • Maximum Transaction log space used
      • Network Egress/Ingress bandwidth
      • Percentage of CPU used
      • Percentage of workers used
      • Percentage of CPU used
    • Health monitoring for Elastic Pools.
    • Health monitoring for Database Geo-Replication.
    • Ability to define custom thresholds for each monitor to configure the warning and critical alerts.
    • Run-as profile to securely connect to Microsoft Azure SQL Database.
    • Detailed knowledge to guide the IT operator with troubleshooting the problem.
    • Custom tasks to redirect the user to the Microsoft Azure SQL Database online portal.
    • Custom query support to enable application-specific availability and performance monitoring.
    • Dashboard functionality.

  • Supported Operating Systems

    Windows Server 2012, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

    For detailed system requirements refer to the management pack guide.

  • For detailed instructions on setup, configuration and monitoring refer to the management pack guide.

Follow Microsoft

Back To Top