Microsoft Azure SQL Elastic Pool offers a cloud-based service, which helps to manage and scale multiple SQL databases that have varying and unpredictable resource demands. It is a cost-effective solution suitable for configuring multiple SQL databases with resource pooling. Application's Manager's Azure SQL Elastic Pool Monitoring tool assists you in tracking the key performance metrics of Azure SQL Elastic Pool, including CPU Utilization, Storage Statistics and many more.
To learn how to create a new Microsoft Azure SQL Elastic Pool Monitor, click here.
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the SQL Elastic Pools monitor from the displayed tooltip. This action will display the bulk configuration view for Azure SQL Elastic Pool in three tabs:
The Microsoft Azure monitor provides a brief detail of the Azure SQL Elastic Pool under the given subscription. Following are the list of metrics monitored in Azure SQL Elastic Pool Monitoring in their corresponding tabs:
| Parameter | Description |
|---|---|
| CPU UTILIZATION | |
| CPU Utilization | The average CPU utilization towards the user workload limit of an elastic pool at the time of polling (in %). |
| CPU USAGE | |
| CPU Used | The average CPU consumption towards the user workload limit of an elastic pool at the time of polling. |
| CPU Limit | The average CPU limit at the time of polling. |
| DTU UTILIZATION | |
| DTU Utilization | The average DTU consumption towards the user workload limit of an elastic pool at the time of polling (in %). |
| ELASTIC DTU USAGE | |
| eDTU Limit | The average number of eDTU (Elastic Database Transaction Units) limit at the time of polling. |
| eDTU Used | The average number of eDTU (Elastic Database Transaction Units) used at the time of polling. |
| SQL INSTANCE UTILIZATION | |
| CPU Utilization (SQL Instance) | The average CPU consumption by the user and system workloads at the time of polling (in %). |
| Memory Utilization (SQL Instance) | The average memory usage of the database engine instance at the time of polling (in %) |
| SESSIONS AND WORKERS UTILIZATION | |
| Sessions Utilization | The average consumption of established user sessions for an elastic pool between the poll interval (in %). |
| Workers Utilization | The average consumption of worker threads towards the user workload limit of an elastic pool between the poll interval (in %). |
| ACTIVE SESSIONS | |
| Active Sessions | The average number of established user sessions for an elastic pool between the poll interval. |
Note: The metrics under IN-MEMORY OLTP STORAGE UTILIZATION, DATA SPACE UTILIZATION and DATA SPACE USAGE groups are not supported for Hyperscale SKU Tier.
| Parameter | Description |
|---|---|
| IN-MEMORY OLTP STORAGE UTILIZATION | |
| In-Memory OLTP Storage Utilization | The average consumption of In-Memory OLTP Storage by the user and system workloads between the poll interval (in %). |
| DATA SPACE UTILIZATION | |
| Data Space Allocated Percentage | The maximum amount of storage space occupied by the data files of all databases in an elastic pool towards the data size limit of the pool between the poll interval (in %). |
| Data Space Utilization | The average amount of storage space used in the data files of all databases in an elastic pool between the poll interval (in %). |
| DATA SPACE USAGE | |
| Data Space Allocated | The average amount of storage space occupied by the data files of all databases in an elastic pool between the poll interval (in MiB). |
| Data Space Used | The average amount of storage space used in the data files of all databases in an elastic pool between the poll interval (in MiB). |
| Data Space Limit | The Data max size configured for the elastic pool (in GiB). |
| IO UTILIZATION | |
| Log IO Utilization | The average transaction log write throughput consumption towards the user workload limit of an elastic pool between the poll interval (in %). |
| Data IO Utilization | The average data file IO consumption towards the user workload limit of an elastic pool between the poll interval (in %). |
| TEMPDB LOG UTILIZATION | |
| TempDB Log Utilization | The average consumption of the transaction log space in the tempdb database towards the maximum log size between the poll interval (in %). |
| TEMPDB DATA FILE SIZE | |
| TempDB Data File Size | The maximum amount of space used in the tempdb data files between the poll interval (in MB). |
| TEMPDB LOG FILE SIZE | |
| TempDB Log File Size | The maximum amount of space used in the tempdb transaction log files between the poll interval (in MB). |
| Parameter | Description |
|---|---|
| CONFIGURATION | |
| Resource Group Name | The name of the resource group. |
| Location | The location of the resource. |
| State | The state of the elastic pool. Possible values: Creating/ Disabled/ Ready |
| Server Name | The name of the server. |
| Kind | Kind of the elastic pool. |
| Creation Time | The time when the elastic pool was created. |
| License Type | The license type applied for this elastic pool. Possible values: BasePrice/ LicenseIncluded |
| Minimum DTU Capacity per Database | The minimum capacity guaranteed for all databases. |
| Maximum DTU Capacity per Database | The maximum capacity that can be consumed by any one database. |
| Zone Redundancy | Indicates whether or not the replicas of this elastic pool can spread across multiple availability zones. Possible values: Enabled/Disabled. |
| SKU | |
| SKU Name | The name of the SKU. |
| SKU Tier | The tier or edition of the particular SKU. Possible values:
|
| SKU Capacity | The capacity of the particular SKU. |
