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 Azure public cloud integration to discover and collect metrics against the Azure service.

Setup

To set up the Azure integration and discover the SQL Database, do the following:

  1. Create an Azure Integration if not available in your installed integrations. For more information on on installing the Azure Integration, refer to Install Azure integration.

  2. Create a discovery profile.

  3. Select Azure SQL Database under the Filter Criteria on the Edit Discovery Profile page.

  4. Save the discovery profile to make it available in the list of Discovery Profiles.

  5. Scan to discover the resources at any time independent of the predefined schedule.

  6. Once the scan is completed, you can view the SQL Database resources under Infrastructure > Resources > Microsoft Azure category.

  7. Create a template with collector type Azure and applicable for SQL Database. See Create a Template for more information on how to create a template.

  8. Refer to Assign a Template on assigning a template to a resource.

  9. Click the Metrics tab to view the monitoring data of the Azure SQL Database.

Event support

OpsRamp supports Azure events for Azure SQL Database. Configure Azure Events in OpsRamp Azure integration discovery profile. See Process Azure Events for more information on how to configure Azure events.

Supported metrics

OpsRamp MetricAzure MetricMetric Display NameUnitDescriptionAggregation Type
azure_sql_database_allocated_data_storageallocated_data_storageData space allocatedBytesMaximum amount of storage space allocated for a specific database.Average
azure_sql_database_app_cpu_billedcpu_billedApp CPU billedCountAmount of CPU resources consumed by your database.Total
azure_sql_database_app_cpu_percentcpu_percentApp CPU percentagePercentPercentage of the CPU resources allocated to your database.Average
azure_sql_database_app_memory_percentapp_memory_percentApp memory used percentagePercentPercentage of the memory resources allocated to your database,Average
azure_sql_database_blocked_by_firewallblocked_by_firewallBlocked by FirewallCountRefers to a situation where the Azure SQL Database instance is blocked by firewall.Total
azure_sql_database_cache_hit_percentcache_hit_percentCache hit percentagePercentPercentage of queries that are served using data that is already present in the database cache.Maximum
azure_sql_database_cache_used_percentcache_used_percentCache used percentagePercentRefers to the percentage of memory allocated to the database cache that is currently in use.Maximum
azure_sql_database_connection_failedconnection_failedFailed ConnectionsCountError or failure that occurs when attempting to establish a connection to an Azure SQL Database.Total
azure_sql_database_connection_successfulconnections_successfulSuccessful ConnectionsCountNumber of successful connections.Total
azure_sql_database_cpu_percentcpu_percentCPU PercentagePercentCPU percentage.Average
azure_sql_database_cpu_limitcpu_limitCPU limitCountCPU limit.Average
azure_sql_database_cpu_usedcpu_usedCPU usedCountCPU used.Average
azure_sql_database_deadlockdeadlockDead LocksCountDead locks.Total
azure_sql_database_dtu_limitdtu_limitDTU LimitCountDTU limit.Average
azure_sql_database_dtu_consumption_percentdtu_consumption_percentDTU percentagePercentDTU percentage.Average
azure_sql_database_dtu_useddtu_usedDTU usedCountDTU used.Average
azure_dw_cpu_percentdwu_cpu_percentDW node level CPU percentagePercentDW node level CPU percentage.Average
azure_dw_physical_data_read_percentdw_physical_data_read_percentDW node level Data IO percentagePercentDW node level Data IO percentage.Average
azure_dwu_consumption_percentdwu_consumption_percentDWU percentagePercentDWU percentage.Maximum
azure_sql_database_dwu_limitdwu_limitDWU limitCountDWU limit.Maximum
azure_sql_database_local_tempdb_usage_percentlocal_tempdb_usage_percentLocal tempdb usage percentPercentLocal temporarily database usage percent.Average
azure_sql_database_log_write_percentlog_write_percentLog IO percentagePercentLog IO percentage.Average
azure_sql_database_physical_data_read_percentphyiscal_data_read_percentData IO percentagePercentData IO percentage.Average
azure_sql_database_sessions_percentsessions_percentSessions percentagePercentSessions percentage.Average
azure_sql_database_sqlserver_process_core_percentsqlserver_process_core_percentSQL Server process core percentPercentSQL server procces core percent.Maximum
azure_sql_database_sqlserver_process_memory_percentsqlserver_process_memory_percentSQL Server process memory percentPercentSQL Server process memory percent.Maximum
azure_sql_database_storagestorageStorageBytesAvailability of storage.n/a
azure_sql_database_storage_percentstorage_percentStorage PercentPercentDatabase size percentage.Percent
azure_sql_database_tempdb_data_sizetempdb_data_sizeTempdb Data File Size KilobytesCountTemporary database data file size in kilobytes.Maximum
azure_sql_database_tempdb_log_sizetempdb_log_sizeTempdb Log File Size KilobytesCountTemporary database log file size in kilobytes.Maximum
azure_sql_database_tempdb_log_used_percenttempdb_log_used_percentTempdb Percent Log UsedPercentTemporary database percent log used.Maximum
azure_sql_database_workers_percentworkers_percentWorkers percentagePercentWorkers percent.Average
azure_sql_database_xtp_storage_percentxtp_storage_percentIn-Memory OLTP storage percentPercentIn-Memory OLTP storage percent.Average
cloud_instance_stateStatus/Staten/aStatus/Staten/a
azure_sql_servers_databases_connection_failed_user_errorconnection_failed_user_errorFailed Connections : User ErrorsCountFailed Connections : User ErrorsTotal
azure_sql_servers_databases_ledger_digest_upload_failedledger_digest_upload_failedFailed Ledger Digest UploadsCountLedger digests that failed to be uploaded.Countg
azure_sql_servers_databases_ledger_digest_upload_successledger_digest_upload_successSuccessful Ledger Digest UploadsCountLedger digests that were successfully uploaded.Countg
azure_sql_servers_databases_log_backup_size_byteslog_backup_size_bytesLog backup storage sizeBytesCumulative log backup storage size. Applies to vCore-based and Hyperscale databases.Average
azure_sql_servers_databases_snapshot_backup_size_bytessnapshot_backup_size_bytesData backup storage sizeBytesCumulative data backup storage size. Applies to Hyperscale databases.Average
azure_sql_servers_databases_base_blob_size_bytesbase_blob_size_bytesData storage sizeBytesData storage size. Applies to Hyperscale databases.Average
azure_sql_servers_databases_sql_instance_cpu_percentsql_instance_cpu_percentSQL instance CPU percentPercentCPU usage by all user and system workloads. Not applicable to data warehouses.Average
azure_sql_servers_databases_sql_instance_memory_percentsql_instance_memory_percentSQL instance memory percentPercentMemory usage by the database engine instance. Not applicable to data warehouses.Average
azure_sql_servers_databases_sessions_countsessions_countSessions countCountNumber of active sessions. Not applicable to Synapse DW Analytics.Average
azure_sql_servers_databases_diff_backup_size_bytesdiff_backup_size_bytesDifferential backup storage sizeBytesCumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.Average
azure_sql_servers_databases_full_backup_size_bytesfull_backup_size_bytesFull backup storage sizeBytesCumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.Average

External reference

What is Azure SQL Database?