Introduction
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.
Note
Use the OpsRamp Azure public cloud integration to discover and collect metrics against the Azure service.Setup
To set up the OpsRamp Azure integration and discover the Azure service,
go to Azure Integration Discovery Profile and select SQL Elastic Pool.
Metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| azure_sql_elasticpool_allocated_data_storage | Data space allocated | Bytes | Average | Data space allocated |
| azure_sql_elasticpool_allocated_data_storage_percent | Data space allocated percentage | Percent | Maximum | Data space allocated percentage |
| azure_sql_elasticpool_cpu_limit | CPU limit | Count | Average | CPU limit |
| azure_sql_database_cpu_percent | CPU Percentage | Percent | Average | CPU Percentage |
| azure_sql_elasticpool_cpu_used | CPU Used | Count | Average | CPU Used |
| azure_sql_database_dtu_consumption_percent | DTU Percentage | Percent | Average | DTU Percentage |
| azure_eDTU_limit | eDTU limit | Count | Average | eDTU limit |
| azure_eDTU_used | eDTU used | Count | Average | eDTU used |
| azure_sql_database_log_write_percent | Log IO percentage | Percent | Average | Log IO percentage |
| azure_sql_database_physical_data_read_percent | Data IO percentage | Percent | Average | Data IO percentage |
| azure_sql_database_sessions_percent | Sessions percentage | Percent | Average | Sessions percentage |
| azure_storage_limit | Storage limit | Bytes | Average | Storage limit |
| azure_sql_database_storage_percent | Storage percentage | Percent | Maximum | Storage percentage |
| azure_sql_elasticpool_sqlserver_process_core_percent | SQL Server process core percentage | Percent | Maximum | SQL Server process core percentage |
| azure_sql_elasticpool_sqlserver_process_memory_percent | SQL Server process memory percentage | Percent | Maximum | SQL Server process memory percentage |
| azure_sql_elasticpool_tempdb_data_size | Tempdb Data File Size Kilobytes | Count | Maximum | Tempdb Data File Size Kilobytes |
| azure_sql_elasticpool_tempdb_log_size | Tempdb Log File Size Kilobytes | Count | Maximum | Tempdb Log File Size Kilobytes |
| azure_sql_elasticpool_tempdb_log_used_percent | Tempdb percent log used | Percent | Maximum | Tempdb percent log used |
| azure_sql_database_workers_percent | Workers percentage | Percent | Average | Workers percentage |
| azure_sql_database_xtp_storage_percent | In-Memory OLTP storage percentage | Percent | Average | In-Memory OLTP storage percentage. |
Event support
- Supported
- Configurable in OpsRamp Azure Integration Discovery Profile.