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