Microsoft Azure SQL Elastic Pool

概要

エラスティックプールは、複数のデータベースのパフォーマンスを管理するためのシンプルでコスト効率の高いソリューションを提供します。

Azure SQL Elastic Pool からメトリクスを取得すると、以下のことができます。

  • SQL Elastic Pool のパフォーマンスを視覚化。
  • SQL Elastic Pool のパフォーマンスをアプリケーションと関連付け。

セットアップ

インストール

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_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

イベント

Azure SQL Elastic Pool インテグレーションには、イベントは含まれません。

サービスチェック

Azure SQL Elastic Pool インテグレーションには、サービスのチェック機能は含まれません。

トラブルシューティング

ご不明な点は、Datadog のサポートチームまでお問合せください。