--- 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 --- # Azure SQL Elastic Pool ## 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/).