Microsoft Azure SQL Elastic Pool監視
概要
Applications ManagerのAzure SQL Elastic Pool監視ツールは、CPU使用率、ストレージ統計など、Azure SQL Elastic Pool の主要なパフォーマンスメトリクスを追跡するのに役立ちます。
新規監視追加
新規にMicrosoft Azure SQL Elastic Pool Monitorを追加する方法はこちらをご参照ください。
監視対象パラメーター
［監視］タブをクリックして、監視カテゴリービューへ移動します。［クラウド］カテゴリーから［Microsoft Azure］配下の［子モニター］にカーソルを合わせて、表示された欄から［SQL
Elastic Pool］をクリックしてください。
一括設定ビューが3つのタブに分類のうえ表示されます。
- ［可用性］タブ：最新24時間か30日の可用性履歴がわかります。
- ［パフォーマンス］タブ：最新24時間か30日のステータスとイベントを確認可能です。
- ［リストビュー］タブ：一括管理設定を実行できます。
Azure SQL Elastic Pool監視で対応するタブで監視できるメトリクスのリストは次のとおりです。
パフォーマンス概要
- DTU UTILIZATIONおよびELASTIC DTU USAGEグループのメトリクスは、DTUベースのElastic Poolでのみサポートされます。
- CPU使用率グループのメトリクスは、vCoreベースのElastic Poolでのみサポートされます。
- Active Sessionsメトリクスは、Azureグローバルアカウントでのみサポートされます。
| パラメーター | 説明 |
|---|---|
| CPU UTILIZATION | |
| CPU Utilization | The average CPU utilization towards the user workload limit of an elastic pool at the time of polling (in %). |
| CPU USAGE | |
| CPU Used | The average CPU consumption towards the user workload limit of an elastic pool at the time of polling. |
| CPU Limit | The average CPU limit at the time of polling. |
| DTU UTILIZATION | |
| DTU Utilization | The average DTU consumption towards the user workload limit of an elastic pool at the time of polling (in %). |
| ELASTIC DTU USAGE | |
| eDTU Limit | The average number of eDTU (Elastic Database Transaction Units) limit at the time of polling. |
| eDTU Used | The average number of eDTU (Elastic Database Transaction Units) used at the time of polling. |
| SQL INSTANCE UTILIZATION | |
| CPU Utilization (SQL Instance) | The average CPU consumption by the user and system workloads at the time of polling (in %). |
| Memory Utilization (SQL Instance) | The average memory usage of the database engine instance at the time of polling (in %) |
| SESSIONS AND WORKERS UTILIZATION | |
| Sessions Utilization | The average consumption of established user sessions for an elastic pool between the poll interval (in %). |
| Workers Utilization | The average consumption of worker threads towards the user workload limit of an elastic pool between the poll interval (in %). |
| ACTIVE SESSIONS | |
| Active Sessions | The average number of established user sessions for an elastic pool between the poll interval. |
ストレージ統計
IN-MEMORY OLTP STORAGE UTILIZATION、DATA
SPACE UTILIZATIONおよびDATA SPACE USAGEグループのメトリクスは、Hyperscale
SKU層ではサポートされていません。
| パラメーター | 説明 |
|---|---|
| IN-MEMORY OLTP STORAGE UTILIZATION | |
| In-Memory OLTP Storage Utilization | The average consumption of In-Memory OLTP Storage by the user and system workloads between the poll interval (in %). |
| DATA SPACE UTILIZATION | |
| Data Space Allocated Percentage | The maximum amount of storage space occupied by the data files of all databases in an elastic pool towards the data size limit of the pool between the poll interval (in %). |
| Data Space Utilization | The average amount of storage space used in the data files of all databases in an elastic pool between the poll interval (in %). |
| DATA SPACE USAGE | |
| Data Space Allocated | The average amount of storage space occupied by the data files of all databases in an elastic pool between the poll interval (in MiB). |
| Data Space Used | The average amount of storage space used in the data files of all databases in an elastic pool between the poll interval (in MiB). |
| Data Space Limit | The Data max size configured for the elastic pool (in GiB). |
| IO UTILIZATION | |
| Log IO Utilization | The average transaction log write throughput consumption towards the user workload limit of an elastic pool between the poll interval (in %). |
| Data IO Utilization | The average data file IO consumption towards the user workload limit of an elastic pool between the poll interval (in %). |
| TEMPDB LOG UTILIZATION | |
| TempDB Log Utilization | The average consumption of the transaction log space in the tempdb database towards the maximum log size between the poll interval (in %). |
| TEMPDB DATA FILE SIZE | |
| TempDB Data File Size | The maximum amount of space used in the tempdb data files between the poll interval (in MB). |
| TEMPDB LOG FILE SIZE | |
| TempDB Log File Size | The maximum amount of space used in the tempdb transaction log files between the poll interval (in MB). |
構成
| パラメーター | 説明 |
|---|---|
| CONFIGURATION | |
| Resource Group Name | The name of the resource group. |
| Location | The location of the resource. |
| State | The state of the elastic pool. Possible values: Creating/ Disabled/ Ready |
| Server Name | The name of the server. |
| Kind | Kind of the elastic pool. |
| Creation Time | The time when the elastic pool was created. |
| License Type | The license type applied for this elastic pool. Possible values: BasePrice/ LicenseIncluded |
| Minimum DTU Capacity per Database | The minimum capacity guaranteed for all databases. |
| Maximum DTU Capacity per Database | The maximum capacity that can be consumed by any one database. |
| Zone Redundancy | Indicates whether or not the replicas of this elastic pool can spread across multiple availability zones. Possible values: Enabled/Disabled. |
| SKU | |
| SKU Name | The name of the SKU. |
| SKU Tier | The tier or edition of the particular SKU. Possible values:
|
| SKU Capacity | The capacity of the particular SKU. |