Documentation is now available for the Fall 2020 Update release!

Azure SQL Database

Leave Feedback

Introduction

Azure SQL Database is a general-purpose relational database, provided as a managed service. With SQL Database, you can create a highly available and high-performance data storage layer for the applications and solutions in Azure.

Setup

To set up the OpsRamp Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select SQL Databases.

Metrics

OpsRamp MetricMetric Display NameUnitAggregation TypeDescription
azure.sql.database.allocated.data.storageData space allocatedBytesAverageData space allocated.
azure.sql.database.app.cpu.billedApp CPU billedCountTotalApp CPU billed.
azure.sql.database.app.cpu.percentApp CPU percentagePercentAverageApp CPU percentage.
azure.sql.database.app.memory.percentApp memory used percentagePercentAverageApp memory used percentage.
azure.sql.database.blocked_by_firewallBlocked by FirewallCountTotalBlocked by firewall.
azure.sql.database.cache.hit.percentCache hit percentagePercentMaximumCache hit percentage.
azure.sql.database.cache.used.percentCache used percentagePercentMaximumCache used percentage.
azure.sql.database.connection_failedFailed ConnectionsCountTotalNumber of failed connections.
azure.sql.database.connection_successfulSuccessful ConnectionsCountTotalNumber of successful connections.
azure.sql.database.cpu_percentCPU PercentagePercentAverageCPU percentage.
azure.sql.database.cpu.limitCPU limitCountAverageCPU limit.
azure.sql.database.cpu.usedCPU usedCountAverageCPU used.
azure.sql.database.deadlockDead LocksCountTotalDead locks.
azure.sql.database.dtu_limitDTU LimitCountAverageDTU limit.
azure.sql.database.dtu_consumption_percentDTU percentagePercentAverageDTU percentage.
azure.sql.database.dtu_usedDTU usedCountAverageDTU used.
azure.dw.cpu.percentDW node level CPU percentagePercentAverageDW node level CPU percentage.
azure.dw.physical.data.read.percentDW node level Data IO percentagePercentAverageDW node level Data IO percentage.
azure.dwu.consumption.percentDWU percentagePercentMaximumDWU percentage.
azure.sql.database.dwu.limitDWU limitCountMaximumDWU limit.
azure.sql.database.local.tempdb.usage.percentLocal tempdb usage percentPercentAverageLocal temporarily database usage percent.
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.sql.database.sqlserver.process.core.percentSQL Server process core percentPercentMaximumSQL server procces core percent.
azure.sql.database.sqlserver.process.memory.percentSQL Server process memory percentPercentMaximumSQL Server process memory percent.
azure.sql.database.storageStorageBytesn/aAvailability of storage.
azure.sql.database.storage_percentStorage PercentPercentPercentDatabase size percentage.
azure.sql.database.tempdb.data.sizeTempdb Data File Size KilobytesCountMaximumTemporary database data file size in kilobytes.
azure.sql.database.tempdb.log.sizeTempdb Log File Size KilobytesCountMaximumTemporary database log file size in kilobytes.
azure.sql.database.tempdb.log.used.percentTempdb Percent Log UsedPercentMaximumTemporary database percent log used.
azure.sql.database.workers_percentWorkers percentagePercentAverageWorkers percent.
azure.sql.database.xtp_storage_percentIn-Memory OLTP storage percentPercentAverageIn-Memory OLTP storage percent.
cloud.instance.stateStatus/Staten/an/aStatus/State

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference