Microsoft Azure SQL Elastic Pool

개요

Elastic Pool은 효과적인 비용으로 다양한 데이터베이스의 성능을 관리할 수 있는 간단한 솔루션입니다.

Azure SQL Elastic Pool 메트릭을 얻으면 다음을 할 수 있습니다.

  • SQL Elastic Pools의 성능을 가시화
  • SQL Elastic Pools의 성능과 애플리케이션의 상관 관계 파악

설정

설치

아직 설정하지 않았다면, 먼저 Microsoft Azure 통합을 설정하세요. 그 외 다른 설치 단계는 없습니다.

수집한 데이터

메트릭

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 Elastic Pools 통합에는 이벤트가 포함되어 있지 않습니다.

서비스 검사

Azure SQL Elastic Pools 통합에는 서비스 점검이 포함되어 있지 않습니다.

트러블슈팅

도움이 필요하신가요? Datadog 지원팀에 문의하세요.