Microsoft Azure SQL Elastic Pool

To find out if this integration is available in your organization, see your Datadog Integrations page or ask your organization administrator.

To initiate an exception request to enable this integration for your organization, email [email protected].

概要

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

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 のサポートチームまでお問合せください。