Documentation is now available for the Fall 2020 Update release!

Azure SQL Elastic Pool

Leave Feedback

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.

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 TypeDescription
azure.sql.elasticpool.allocated.data.storageData space allocatedBytesAverageData space allocated
azure.sql.elasticpool.allocated.data.storage.percentData space allocated percentagePercentMaximumData space allocated percentage
azure.sql.elasticpool.cpu.limitCPU limitCountAverageCPU limit
azure.sql.database.cpu_percentCPU PercentagePercentAverageCPU Percentage
azure.sql.elasticpool.cpu.usedCPU UsedCountAverageCPU Used
azure.sql.database.dtu_consumption_percentDTU PercentagePercentAverageDTU Percentage
azure.eDTU.limiteDTU limitCountAverageeDTU limit
azure.eDTU.usedeDTU usedCountAverageeDTU used
azure.sql.database.log_write_percentLog IO percentagePercentAverageLog IO percentage
azure.sql.database.physical_data_read_percentData IO percentagePercentAverageData IO percentage
azure.sql.database.sessions_percentSessions percentagePercentAverageSessions percentage
azure.storage.limitStorage limitBytesAverageStorage limit
azure.sql.database.storage_percentStorage percentagePercentMaximumStorage percentage
azure.sql.elasticpool.sqlserver.process.core.percentSQL Server process core percentagePercentMaximumSQL Server process core percentage
azure.sql.elasticpool.sqlserver.process.memory.percentSQL Server process memory percentagePercentMaximumSQL Server process memory percentage
azure.sql.elasticpool.tempdb.data.sizeTempdb Data File Size KilobytesCountMaximumTempdb Data File Size Kilobytes
azure.sql.elasticpool.tempdb.log.sizeTempdb Log File Size KilobytesCountMaximumTempdb Log File Size Kilobytes
azure.sql.elasticpool.tempdb.log.used.percentTempdb percent log usedPercentMaximumTempdb percent log used
azure.sql.database.workers_percentWorkers percentagePercentAverageWorkers percentage
azure.sql.database.xtp_storage_percentIn-Memory OLTP storage percentagePercentAverageIn-Memory OLTP storage percentage

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference