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.

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 Databases.

Metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
azure_sql_database_allocated_data_storage

Data space allocated.
Data space allocatedBytesAverage
azure_sql_database_app_cpu_billed

App CPU billed.
App CPU billedCountTotal
azure_sql_database_app_cpu_percent

App CPU percentage.
App CPU percentagePercentAverage
azure_sql_database_app_memory_percent

App memory used percentage.
App memory used percentagePercentAverage
azure_sql_database_blocked_by_firewall

Blocked by firewall.
Blocked by FirewallCountTotal
azure_sql_database_cache_hit_percent

Cache hit percentage.
Cache hit percentagePercentMaximum
azure_sql_database_cache_used_percent

Cache used percentage.
Cache used percentagePercentMaximum
azure_sql_database_connection_failed

Number of failed connections.
Failed ConnectionsCountTotal
azure_sql_database_connection_successful

Number of successful connections.
Successful ConnectionsCountTotal
azure_sql_database_cpu_percent

CPU percentage.
CPU PercentagePercentAverage
azure_sql_database_cpu_limit

CPU limit.
CPU limitCountAverage
azure_sql_database_cpu_used

CPU used.
CPU usedCountAverage
azure_sql_database_deadlock

Dead locks.
Dead LocksCountTotal
azure_sql_database_dtu_limit

DTU limit.
DTU LimitCountAverage
azure_sql_database_dtu_consumption_percent

DTU percentage.
DTU percentagePercentAverage
azure_sql_database_dtu_used

DTU used.
DTU usedCountAverage
azure_dw_cpu_percent

DW node level CPU percentage.
DW node level CPU percentagePercentAverage
azure_dw_physical_data_read_percent

DW node level Data IO percentage.
DW node level Data IO percentagePercentAverage
azure_dwu_consumption_percent

DWU percentage.
DWU percentagePercentMaximum
azure_sql_database_dwu_limit

DWU limit.
DWU limitCountMaximum
azure_sql_database_local_tempdb_usage_percent

Local temporarily database usage percent.
Local tempdb usage percentPercentAverage
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_sql_database_sqlserver_process_core_percent

SQL server procces core percent.
SQL Server process core percentPercentMaximum
azure_sql_database_sqlserver_process_memory_percent

SQL Server process memory percent.
SQL Server process memory percentPercentMaximum
azure_sql_database_storage

Availability of storage.
StorageBytesn/a
azure_sql_database_storage_percent

Database size percentage.
Storage PercentPercentPercent
azure_sql_database_tempdb_data_size

Temporary database data file size in kilobytes.
Tempdb Data File Size KilobytesCountMaximum
azure_sql_database_tempdb_log_size

Temporary database log file size in kilobytes.
Tempdb Log File Size KilobytesCountMaximum
azure_sql_database_tempdb_log_used_percent

Temporary database percent log used.
Tempdb Percent Log UsedPercentMaximum
azure_sql_database_workers_percent

Workers percent.
Workers percentagePercentAverage
azure_sql_database_xtp_storage_percent

In-Memory OLTP storage percent.
In-Memory OLTP storage percentPercentAverage
cloud_instance_state

Status/State
Status/Staten/an/a

Event support

  • Supported
  • Configurable in OpsRamp Azure Integration Discovery Profile.

External reference