--- title: Azure SQL Elastic Pool description: >- Elastic pools provide a simple and cost effective solution for managing the performance of multiple databases. breadcrumbs: Docs > Integrations > Azure SQL Elastic Pool --- > For the complete documentation index, see [llms.txt](https://docs.datadoghq.com/llms.txt). # Azure SQL Elastic Pool {% callout %} # Important note for users on the following Datadog sites: us2.ddog-gov.com {% alert level="info" %} To find out if this integration is available in your organization, see your [Datadog Integrations](https://app.datadoghq.com/integrations) page or ask your organization administrator. To initiate an exception request to enable this integration for your organization, email [support@ddog-gov.com](mailto:support@ddog-gov.com). {% /alert %} {% /callout %} ## Overview{% #overview %} Elastic pools provide a simple and cost effective solution for managing the performance of multiple databases. Get metrics from Azure SQL Elastic Pool to: - Visualize the performance of your SQL Elastic Pools. - Correlate the performance of your SQL Elastic Pools with your applications. ## Setup{% #setup %} ### Installation{% #installation %} If you haven't already, set up the [Microsoft Azure integration](https://docs.datadoghq.com/integrations/azure.md). No additional installation steps are required. ## Data Collected{% #data-collected %} ### Metrics{% #metrics %} | | | | | **azure.sql_servers_elasticpools.cpu_percent**(gauge) | Average compute utilization in percentage of the limit of the pool*Shown as percent* | | **azure.sql_servers_elasticpools.data_space_allocated**(gauge) | Data space allocated*Shown as byte* | | **azure.sql_servers_elasticpools.data_space_allocated_percent**(gauge) | Data space allocated percent*Shown as percent* | | **azure.sql_servers_elasticpools.dtu_consumption_percent**(gauge) | Average eDTU utilization in percentage of eDTU limit for the pool*Shown as percent* | | **azure.sql_servers_elasticpools.e_dtu_limit**(gauge) | Current max elastic pool DTU setting for this elastic pool*Shown as unit* | | **azure.sql_servers_elasticpools.e_dtu_used**(gauge) | Average eDTUs used by the pool*Shown as unit* | | **azure.sql_servers_elasticpools.in_memory_oltp_storage_percent**(gauge) | In-Memory OLTP storage percent*Shown as percent* | | **azure.sql_servers_elasticpools.log_write_percent**(gauge) | Average write resource utilization in percentage of the limit of the pool*Shown as percent* | | **azure.sql_servers_elasticpools.physical_data_read_percent**(gauge) | Average I/O utilization in percentage based on the limit of the pool*Shown as percent* | | **azure.sql_servers_elasticpools.sessions_percent**(gauge) | Maximum concurrent sessions in percentage based on the limit of the pool*Shown as percent* | | **azure.sql_servers_elasticpools.sql_instance_cpu_percent**(gauge) | Maximum compute usage by all user and system workloads. Applies to elastic pools.*Shown as percent* | | **azure.sql_servers_elasticpools.storage_limit**(gauge) | Current max elastic pool storage limit setting for this elastic pool in megabytes during this interval*Shown as byte* | | **azure.sql_servers_elasticpools.storage_percent**(gauge) | Current max elastic pool storage limit setting for this elastic pool*Shown as percent* | | **azure.sql_servers_elasticpools.storage_used**(gauge) | Average storage used by the pool in this interval in bytes*Shown as byte* | | **azure.sql_servers_elasticpools.workers_percent**(gauge) | Maximum concurrent workers (requests) in percentage based on the limit of the pool*Shown as percent* | | **azure.sql_servers_elasticpools.app_cpu_billed**(count) | App CPU billed. Applies to serverless elastic pools. | | **azure.sql_servers_elasticpools.app_cpu_percentage**(gauge) | App CPU percentage. Applies to serverless elastic pools.*Shown as percent* | | **azure.sql_servers_elasticpools.app_memory_percentage**(gauge) | App memory percentage. Applies to serverless elastic pools.*Shown as percent* | | **azure.sql_servers_elasticpools.cpu_limit**(gauge) | CPU limit. Applies to vcore-based elastic pools. | | **azure.sql_servers_elasticpools.cpu_used**(gauge) | CPU used. Applies to vcore-based elastic pools. | | **azure.sql_servers_elasticpools.sessions_count**(gauge) | Number of active sessions. | | **azure.sql_servers_elasticpools.sql_instance_memory_percent**(gauge) | Memory usage by the database engine instance. Applies to elastic pools.*Shown as percent* | | **azure.sql_servers_elasticpools.sql_server_process_core_percent**(gauge) | CPU usage as a percentage of the SQL DB process. Applies to elastic pools. (This metric is equivalent to sql_instance_cpu_percent, and will be removed in the future.).*Shown as percent* | | **azure.sql_servers_elasticpools.sql_server_process_memory_percent**(gauge) | Memory usage as a percentage of the SQL DB process. Applies to elastic pools. (This metric is equivalent to sql_instance_memory_percent, and will be removed in the future.).*Shown as percent* | | **azure.sql_servers_elasticpools.tempdb_data_file_size_kilobytes**(gauge) | Space used in tempdb data files in kilobytes. | | **azure.sql_servers_elasticpools.tempdb_log_file_size_kilobytes**(gauge) | Space used in tempdb transaction log file in kilobytes. | | **azure.sql_servers_elasticpools.tempdb_percent_log_used**(gauge) | Space used percentage in tempdb transaction log file.*Shown as percent* | ### Events{% #events %} The Azure SQL Elastic pools integration does not include any events. ### Service Checks{% #service-checks %} The Azure SQL Elastic pools integration does not include any service checks. ## Troubleshooting{% #troubleshooting %} Need help? Contact [Datadog support](https://docs.datadoghq.com/help/).