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 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 MetricMetric Display NameUnitAggregation Type
azure_sql_elasticpool_allocated_data_storage

Data space allocated
Data space allocatedBytesAverage
azure_sql_elasticpool_allocated_data_storage_percent

Data space allocated percentage
Data space allocated percentagePercentMaximum
azure_sql_elasticpool_cpu_limit

CPU limit
CPU limitCountAverage
azure_sql_database_cpu_percent

CPU Percentage
CPU PercentagePercentAverage
azure_sql_elasticpool_cpu_used

CPU Used
CPU UsedCountAverage
azure_sql_database_dtu_consumption_percent

DTU Percentage
DTU PercentagePercentAverage
azure_eDTU_limit

eDTU limit
eDTU limitCountAverage
azure_eDTU_used

eDTU used
eDTU usedCountAverage
azure_sql_database_log_write_percent

Log IO percentage
Log IO percentagePercentAverage
azure_sql_database_physical_data_read_percent

Data IO percentage
Data IO percentagePercentAverage
azure_sql_database_sessions_percent

Sessions percentage
Sessions percentagePercentAverage
azure_storage_limit

Storage limit
Storage limitBytesAverage
azure_sql_database_storage_percent

Storage percentage
Storage percentagePercentMaximum
azure_sql_elasticpool_sqlserver_process_core_percent

SQL Server process core percentage
SQL Server process core percentagePercentMaximum
azure_sql_elasticpool_sqlserver_process_memory_percent

SQL Server process memory percentage
SQL Server process memory percentagePercentMaximum
azure_sql_elasticpool_tempdb_data_size

Tempdb Data File Size Kilobytes
Tempdb Data File Size KilobytesCountMaximum
azure_sql_elasticpool_tempdb_log_size

Tempdb Log File Size Kilobytes
Tempdb Log File Size KilobytesCountMaximum
azure_sql_elasticpool_tempdb_log_used_percent

Tempdb percent log used
Tempdb percent log usedPercentMaximum
azure_sql_database_workers_percent

Workers percentage
Workers percentagePercentAverage
azure_sql_database_xtp_storage_percent

In-Memory OLTP storage percentage.
In-Memory OLTP storage percentagePercentAverage

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference