SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.
Use the Azure public cloud integration to discover and collect metrics against the Azure service.
External reference
Setup
To set up the Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select SQL Elastic Pool.
Event support
- Supported
- Configurable in OpsRamp Azure Integration Discovery Profile.
Supported metrics
| OpsRamp Metric | Azure Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|---|
| azure_sql_servers_elasticpools_allocated_data_storage | allocated_data_storage | Data space allocated | Bytes | Average | Data space allocated |
| azure_sql_servers_elasticpools_allocated_data_storage_percent | allocated_data_storage_percent | Data space allocated percent | Percent | Average | Data space allocated percent. Not applicable to hyperscale |
| azure_sql_servers_elasticpools_app_cpu_billed | app_cpu_billed | App CPU billed | Count | Total | App CPU billed. Applies to serverless elastic pools |
| azure_sql_servers_elasticpools_app_cpu_percent | app_cpu_percent | App CPU percentage | Percent | Average | App CPU percentage. Applies to serverless elastic pools |
| azure_sql_servers_elasticpools_app_memory_percent | app_memory_percent | App memory percentage | Percent | Average | App memory percentage. Applies to serverless elastic pools |
| azure_sql_servers_elasticpools_cpu_limit | cpu_limit | CPU limit | Count | Average | CPU limit. Applies to vCore-based elastic pools |
| azure_sql_servers_elasticpools_cpu_percent | cpu_percent | CPU percentage | Percent | Average | CPU percentage |
| azure_sql_servers_elasticpools_cpu_used | cpu_used | CPU used | Count | Average | CPU used. Applies to vCore-based elastic pools |
| azure_sql_servers_elasticpools_dtu_consumption_percent | dtu_consumption_percent | DTU percentage | Percent | Average | DTU Percentage. Applies to DTU-based elastic pools |
| azure_sql_servers_elasticpools_eDTU_limit | eDTU_limit | eDTU limit | Count | Average | eDTU limit. Applies to DTU-based elastic pools |
| azure_sql_servers_elasticpools_eDTU_used | eDTU_used | eDTU used | Count | Average | eDTU used. Applies to DTU-based elastic pools |
| azure_sql_servers_elasticpools_log_write_percent | log_write_percent | Log IO percentage | Percent | Average | Log IO percentage |
| azure_sql_servers_elasticpools_physical_data_read_percent | physical_data_read_percent | Data IO percentage | Percent | Average | Data IO percentage |
| azure_sql_servers_elasticpools_sessions_count | sessions_count | Sessions Count | Count | Average | Number of active sessions |
| azure_sql_servers_elasticpools_sessions_percent | sessions_percent | Sessions percentage | Percent | Average | Sessions percentage |
| azure_sql_servers_elasticpools_sql_instance_cpu_percent | sql_instance_cpu_percent | SQL instance CPU percent | Percent | Average | CPU usage by all user and system workloads. Applies to elastic pools |
| azure_sql_servers_elasticpools_sql_instance_memory_percent | sql_instance_memory_percent | SQL instance memory percent | Percent | Average | Memory usage by the database engine instance. Applies to elastic pools |
| azure_sql_servers_elasticpools_sqlserver_process_core_percent | sqlserver_process_core_percent | SQL Server process core percent | Percent | Average | 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.) |
| azure_sql_servers_elasticpools_sqlserver_process_memory_percent | sqlserver_process_memory_percent | SQL Server process memory percent | Percent | Average | 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.) |
| azure_sql_servers_elasticpools_storage_limit | storage_limit | Data max size | Bytes | Average | Data max size. Not applicable to hyperscale |
| azure_sql_servers_elasticpools_storage_percent | storage_percent | Data space used percent | Percent | Average | Data space used percent. Not applicable to hyperscale |
| azure_sql_servers_elasticpools_storage_used | storage_used | Data space used | Bytes | Average | Data space used |
| azure_sql_servers_elasticpools_tempdb_data_size | tempdb_data_size | Tempdb Data File Size Kilobytes | Count | Average | Space used in tempdb data files in kilobytes |
| azure_sql_servers_elasticpools_tempdb_log_size | tempdb_log_size | Tempdb Log File Size Kilobytes | Count | Average | Space used in tempdb transaction log file in kilobytes |
| azure_sql_servers_elasticpools_tempdb_log_used_percent | tempdb_log_used_percent | Tempdb Percent Log Used | Percent | Average | Space used percentage in tempdb transaction log file |
| azure_sql_servers_elasticpools_workers_percent | workers_percent | Workers percentage | Percent | Average | Workers percentage |
| azure_sql_servers_elasticpools_xtp_storage_percent | xtp_storage_percent | In-Memory OLTP storage percent | Percent | Average | In-Memory OLTP storage percent. Not applicable to hyperscale |