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 | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| azure_sql_elasticpool_allocated_data_storage Data space allocated | Data space allocated | Bytes | Average |
| azure_sql_elasticpool_allocated_data_storage_percent Data space allocated percentage | Data space allocated percentage | Percent | Maximum |
| azure_sql_elasticpool_cpu_limit CPU limit | CPU limit | Count | Average |
| azure_sql_database_cpu_percent CPU Percentage | CPU Percentage | Percent | Average |
| azure_sql_elasticpool_cpu_used CPU Used | CPU Used | Count | Average |
| azure_sql_database_dtu_consumption_percent DTU Percentage | DTU Percentage | Percent | Average |
| azure_eDTU_limit eDTU limit | eDTU limit | Count | Average |
| azure_eDTU_used eDTU used | eDTU used | Count | Average |
| azure_sql_database_log_write_percent Log IO percentage | Log IO percentage | Percent | Average |
| azure_sql_database_physical_data_read_percent Data IO percentage | Data IO percentage | Percent | Average |
| azure_sql_database_sessions_percent Sessions percentage | Sessions percentage | Percent | Average |
| azure_storage_limit Storage limit | Storage limit | Bytes | Average |
| azure_sql_database_storage_percent Storage percentage | Storage percentage | Percent | Maximum |
| azure_sql_elasticpool_sqlserver_process_core_percent SQL Server process core percentage | SQL Server process core percentage | Percent | Maximum |
| azure_sql_elasticpool_sqlserver_process_memory_percent SQL Server process memory percentage | SQL Server process memory percentage | Percent | Maximum |
| azure_sql_elasticpool_tempdb_data_size Tempdb Data File Size Kilobytes | Tempdb Data File Size Kilobytes | Count | Maximum |
| azure_sql_elasticpool_tempdb_log_size Tempdb Log File Size Kilobytes | Tempdb Log File Size Kilobytes | Count | Maximum |
| azure_sql_elasticpool_tempdb_log_used_percent Tempdb percent log used | Tempdb percent log used | Percent | Maximum |
| azure_sql_database_workers_percent Workers percentage | Workers percentage | Percent | Average |
| azure_sql_database_xtp_storage_percent In-Memory OLTP storage percentage. | In-Memory OLTP storage percentage | Percent | Average |