Microsoft Azure SQL Database

개요

Azure SQL Database는 수요에 맞게 규모 조정이 가능한, 강력한 데이터 저장소입니다.

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

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

설정

설치

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

수집한 데이터

메트릭

azure.sql_servers_databases.active_queries
(count)		Active queries across all workload groups. Applies only to data warehouses.
azure.sql_servers_databases.data_space_allocated
(gauge)		Allocated data storage. Not applicable to data warehouses.
Shown as byte
azure.sql_servers_databases.app_cpu_billed
(count)		App CPU billed. Applies to serverless databases.
azure.sql_servers_databases.app_cpu_percentage
(gauge)		App CPU percentage. Applies to serverless databases.
Shown as percent
azure.sql_servers_databases.app_memory_percentage
(gauge)		App memory percentage. Applies to serverless databases.
Shown as percent
azure.sql_servers_databases.data_storage_size
(gauge)		Data storage size. Applies to Hyperscale databases.
Shown as byte
azure.sql_servers_databases.blocked_by_firewall
(count)		Blocked by Firewall.
azure.sql_servers_databases.cache_hit_percentage
(gauge)		Cache hit percentage. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.cache_used_percentage
(gauge)		Cache used percentage. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.connection_failed
(count)		Failed Connections.
azure.sql_servers_databases.connection_successful
(count)		Successful Connections.
azure.sql_servers_databases.core_count
(gauge)		Core count.
azure.sql_servers_databases.cpu_limit
(gauge)		CPU limit. Applies to vCore-based databases.
azure.sql_servers_databases.cpu_percent
(gauge)		CPU percentage.
Shown as percent
azure.sql_servers_databases.cpu_percent.max
(gauge)		Maximum CPU percentage (Max Aggregated)
Shown as percent
azure.sql_servers_databases.cpu_used
(gauge)		CPU used. Applies to vCore-based databases.
azure.sql_servers_databases.cpu_used.max
(count)		Maximum CPU used. Applies to vCore-based databases. (Max Aggregated)
azure.sql_servers_databases.deadlock
(count)		Deadlocks. Not applicable to data warehouses.
azure.sql_servers_databases.remote_data_reads
(count)		Remote data reads in bytes.
Shown as byte
azure.sql_servers_databases.total_remote_bytes_read_and_written
(count)		Total remote bytes read and written by compute.
Shown as byte
azure.sql_servers_databases.remote_log_writes
(count)		Remote log writes in bytes.
Shown as byte
azure.sql_servers_databases.differential_backup_storage_size
(gauge)		Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.
Shown as byte
azure.sql_servers_databases.dtu_consumption_percent
(gauge)		DTU Percentage. Applies to DTU-based databases.
Shown as percent
azure.sql_servers_databases.dtu_limit
(gauge)		DTU Limit. Applies to DTU-based databases.
azure.sql_servers_databases.dtu_used
(gauge)		DTU used. Applies to DTU-based databases.
azure.sql_servers_databases.dwu_consumption_percent
(gauge)		DWU percentage. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.dwu_limit
(gauge)		DWU limit. Applies only to data warehouses.
azure.sql_servers_databases.dwu_used
(gauge)		DWU used. Applies only to data warehouses.
azure.sql_servers_databases.full_backup_storage_size
(gauge)		Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.
Shown as byte
azure.sql_servers_databases.local_tempdb_percentage
(gauge)		Local tempdb percentage. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.log_backup_storage_size
(gauge)		Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases.
Shown as byte
azure.sql_servers_databases.log_write_percent
(gauge)		Log IO percentage. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.memory_percentage
(gauge)		Memory percentage. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.physical_data_read_percent
(gauge)		Data IO percentage.
Shown as percent
azure.sql_servers_databases.physical_data_read_percent.max
(gauge)		Maximum Data IO percentage (Max Aggregated)
Shown as percent
azure.sql_servers_databases.queued_queries
(count)		Queued queries across all workload groups. Applies only to data warehouses.
azure.sql_servers_databases.replication_links.count
(gauge)		The amount of replication links per database
azure.sql_servers_databases.sessions_percent
(gauge)		Sessions percentage. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.data_backup_storage_size
(gauge)		Cumulative data backup storage size. Applies to Hyperscale databases.
Shown as byte
azure.sql_servers_databases.sql_server_process_core_percent
(gauge)		CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.sql_server_process_memory_percent
(gauge)		Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.storage
(gauge)		Data space used. Not applicable to data warehouses.
Shown as byte
azure.sql_servers_databases.storage_percent
(gauge)		Data space used percent. Not applicable to data warehouses or hyperscale databases.
Shown as percent
azure.sql_servers_databases.tempdb_data_file_size_kilobytes
(gauge)		Space used in tempdb data files in kilobytes. Not applicable to data warehouses.
azure.sql_servers_databases.tempdb_log_file_size_kilobytes
(gauge)		Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses.
azure.sql_servers_databases.tempdb_percent_log_used
(gauge)		Space used percentage in tempdb transaction log file. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.workload_group_active_queries
(count)		Active queries within the workload group. Applies only to data warehouses.
azure.sql_servers_databases.workload_group_query_timeouts
(count)		Queries that have timed out for the workload group. Applies only to data warehouses.
azure.sql_servers_databases.workload_group_allocation_by_system_percent
(gauge)		Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.workload_group_allocation_by_cap_resource_percent
(gauge)		Allocated percentage of resources relative to the specified cap resources per workload group. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.effective_cap_resource_percent
(gauge)		A hard limit on the percentage of resources allowed for the workload group, taking into account Effective Min Resource Percentage allocated for other workload groups. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.effective_min_resource_percent
(gauge)		Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. Applies only to data warehouses.
Shown as percent
azure.sql_servers_databases.workload_group_queued_queries
(count)		Queued queries within the workload group. Applies only to data warehouses.
azure.sql_servers_databases.workers_percent
(gauge)		Workers percentage. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.xtp_storage_percent
(gauge)		In-Memory OLTP storage percent. Not applicable to data warehouses.
Shown as percent
azure.sql_servers_databases.count
(gauge)		Count of Azure SQL Database resources.
azure.sql_servers_databases.status
(gauge)		Status of Azure SQL Database resources(deprecated).

이벤트

Azure SQL Database 통합에는 이벤트가 포함되어 있지 않습니다.

서비스 검사

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

트러블슈팅

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