Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

The Microsoft Azure SQL Database Management Pack enables you to monitor the availability and performance of applications that are running on 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 Azure SQL Database metrics.

Feature Summary
After configuration, the Azure SQL Database Monitoring Management Pack offers the following functionalities:

• User-friendly wizard to discover Azure SQL Database servers.
• Multiple subscriptions and multiple 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 Azure SQL 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 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
• 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 Azure SQL Database.
• Detailed knowledge to guide the IT operator with troubleshooting the problem.
• Custom tasks to redirect the user to the Azure SQL Database online portal.
• Custom query support to enable application-specific availability and performance monitoring.
• Dashboard functionality.

For more information about this management pack, see the Azure SQL Database Management Pack Operations Guide.

Files

Status: Live This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

Files
AzureSQLDatabaseMPWorkflowList.pdf Size: 505 KB
Microsoft.SqlServer.Azure.ManagementPack.msi Size: 13.77 MB

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

For detailed system requirements, refer to the Azure SQL Database Management Pack Operations Guide.

For detailed instructions on setup, configuration, and monitoring, refer to the Azure SQL Database Management Pack Operations Guide.