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:
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.
Create a discovery profile.
Select
Azure SQL Databaseunder the Filter Criteria on the Edit Discovery Profile page.Save the discovery profile to make it available in the list of Discovery Profiles.
Scan to discover the resources at any time independent of the predefined schedule.
Once the scan is completed, you can view the SQL Database resources under Infrastructure > Resources > Microsoft Azure category.
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.
Refer to Assign a Template on assigning a template to a resource.
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 Metric | Azure Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|---|
| azure_sql_servers_databases_active_queries | active_queries | Active queries | Count | Total | Active queries across all workload groups. Applies only to data warehouses |
| azure_sql_servers_databases_allocated_data_storage | allocated_data_storage | Data space allocated | Bytes | Average | Allocated data storage. Not applicable to data warehouses |
| azure_sql_servers_databases_app_cpu_billed | app_cpu_billed | App CPU billed | Count | Total | App CPU billed. Applies to serverless databases |
| azure_sql_servers_databases_app_cpu_billed_ha_replicas | app_cpu_billed_ha_replicas | App CPU billed HA replicas | Count | Total | Sum of app CPU billed across all HA replicas associated with the primary replica or a named replica |
| azure_sql_servers_databases_app_cpu_percent | app_cpu_percent | App CPU percentage | Percent | Average | App CPU percentage. Applies to serverless databases |
| azure_sql_servers_databases_app_memory_percent | app_memory_percent | App memory percentage | Percent | Average | App memory percentage. Applies to serverless databases |
| azure_sql_servers_databases_availability | availability | Availability | Percent | Average | The percentage of SLA compliant availability for the database. Availability is calculated based on connections and for each one-minute data point the value will be either 100% if connection(s) succeed or 0% if all connections fail due to system errors. Note:Select 1-minute time granularity to view SLA compliant availability |
| azure_sql_servers_databases_base_blob_size_bytes | base_blob_size_bytes | Data storage size | Bytes | Average | Data storage size. Applies to Hyperscale databases |
| azure_sql_servers_databases_blocked_by_firewall | blocked_by_firewall | Blocked by Firewall | Count | Total | Blocked by Firewall |
| azure_sql_servers_databases_cache_hit_percent | cache_hit_percent | Cache hit percentage | Percent | Average | Cache hit percentage. Applies only to data warehouses |
| azure_sql_servers_databases_cache_used_percent | cache_used_percent | Cache used percentage | Percent | Average | Cache used percentage. Applies only to data warehouses |
| azure_sql_servers_databases_connection_failed | connection_failed | Failed Connections : System Errors | Count | Total | Failed Connections |
| azure_sql_servers_databases_connection_failed_user_error | connection_failed_user_error | Failed Connections : User Errors | Count | Total | Failed Connections : User Errors |
| azure_sql_servers_databases_connection_successful | connection_successful | Successful Connections | Count | Total | Successful Connections |
| azure_sql_servers_databases_cpu_limit | cpu_limit | CPU limit | Count | Average | CPU limit. Applies to vCore-based databases |
| azure_sql_servers_databases_cpu_percent | cpu_percent | CPU percentage | Percent | Average | CPU percentage |
| azure_sql_servers_databases_cpu_used | cpu_used | CPU used | Count | Average | CPU used. Applies to vCore-based databases |
| azure_sql_servers_databases_deadlock | deadlock | Deadlocks | Count | Total | Deadlocks. Not applicable to data warehouses |
| azure_sql_servers_databases_diff_backup_size_bytes | diff_backup_size_bytes | Differential backup storage size | Bytes | Average | Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases |
| azure_sql_servers_databases_dtu_consumption_percent | dtu_consumption_percent | DTU percentage | Percent | Average | DTU Percentage. Applies to DTU-based databases |
| azure_sql_servers_databases_dtu_limit | dtu_limit | DTU Limit | Count | Average | DTU Limit. Applies to DTU-based databases |
| azure_sql_servers_databases_dtu_used | dtu_used | DTU used | Count | Average | DTU used. Applies to DTU-based databases |
| azure_sql_servers_databases_dwu_consumption_percent | dwu_consumption_percent | DWU percentage | Percent | Average | DWU percentage. Applies only to data warehouses |
| azure_sql_servers_databases_dwu_limit | dwu_limit | DWU limit | Count | Average | DWU limit. Applies only to data warehouses |
| azure_sql_servers_databases_dwu_used | dwu_used | DWU used | Count | Average | DWU used. Applies only to data warehouses |
| azure_sql_servers_databases_free_amount_consumed | free_amount_consumed | Free amount consumed | Count | Average | Free amount of vCore seconds consumed this month. Applies only to free database offer |
| azure_sql_servers_databases_free_amount_remaining | free_amount_remaining | Free amount remaining | Count | Average | Free amount of vCore seconds remaining this month. Applies only to free database offer |
| azure_sql_servers_databases_full_backup_size_bytes | full_backup_size_bytes | Full backup storage size | Bytes | Average | Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases |
| azure_sql_servers_databases_ledger_digest_upload_failed | ledger_digest_upload_failed | Failed Ledger Digest Uploads | Count | Count | Ledger digests that failed to be uploaded |
| azure_sql_servers_databases_ledger_digest_upload_success | ledger_digest_upload_success | Successful Ledger Digest Uploads | Count | Count | Ledger digests that were successfully uploaded |
| azure_sql_servers_databases_local_tempdb_usage_percent | local_tempdb_usage_percent | Local tempdb percentage | Percent | Average | Local tempdb percentage. Applies only to data warehouses |
| azure_sql_servers_databases_log_backup_size_bytes | log_backup_size_bytes | Log backup storage size | Bytes | Average | Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases |
| azure_sql_servers_databases_log_write_percent | log_write_percent | Log IO percentage | Percent | Average | Log IO percentage. Not applicable to data warehouses |
| azure_sql_servers_databases_memory_usage_percent | memory_usage_percent | Memory percentage | Percent | Average | Memory percentage. Applies only to data warehouses |
| azure_sql_servers_databases_physical_data_read_percent | physical_data_read_percent | Data IO percentage | Percent | Average | Data IO percentage |
| azure_sql_servers_databases_queued_queries | queued_queries | Queued queries | Count | Total | Queued queries across all workload groups. Applies only to data warehouses |
| azure_sql_servers_databases_replication_lag_seconds | replication_lag_seconds | Replication lag | Seconds | Average | Replication lag or RPO is the number of seconds that the secondary database is behind the primary database. This value is available on the primary database only |
| azure_sql_servers_databases_sessions_count | sessions_count | Sessions count | Count | Average | Number of active sessions. Not applicable to Synapse DW Analytics |
| azure_sql_servers_databases_sessions_percent | sessions_percent | Sessions percentage | Percent | Average | Sessions percentage. Not applicable to data warehouses |
| azure_sql_servers_databases_snapshot_backup_size_bytes | snapshot_backup_size_bytes | Data backup storage size | Bytes | Average | Cumulative data backup storage size. Applies to Hyperscale databases |
| azure_sql_servers_databases_storage | storage | Data space used | Bytes | Average | Data space used. Not applicable to data warehouses |
| azure_sql_servers_databases_storage_percent | storage_percent | Data space used percent | Percent | Average | Data space used percent. Not applicable to data warehouses or hyperscale databases |
| azure_sql_servers_databases_workers_percent | workers_percent | Workers percentage | Percent | Average | Workers percentage. Not applicable to data warehouses |
| azure_sql_servers_databases_xtp_storage_percent | xtp_storage_percent | In-Memory OLTP storage percent | Percent | Average | In-Memory OLTP storage percent. Not applicable to data warehouses |
| azure_sql_servers_databases_sql_instance_cpu_percent | sql_instance_cpu_percent | SQL instance CPU percent | Percent | Average | CPU usage by all user and system workloads. Not applicable to data warehouses |
| azure_sql_servers_databases_sql_instance_memory_percent | sql_instance_memory_percent | SQL instance memory percent | Percent | Average | Memory usage by the database engine instance. Not applicable to data warehouses |
| azure_sql_servers_databases_sqlserver_process_core_percent | sqlserver_process_core_percent | SQL Server process core percent | Percent | Average | CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses. (This metric is equivalent to sql_instance_cpu_percent, and will be removed in the future.) |
| azure_sql_servers_databases_sqlserver_process_memory_percent | sqlserver_process_memory_percent | SQL Server process memory percent | Percent | Average | Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses. (This metric is equivalent to sql_instance_memory_percent, and will be removed in the future.) |
| azure_sql_servers_databases_tempdb_data_size | tempdb_data_size | Tempdb Data File Size Kilobytes | Count | Average | Space used in tempdb data files in kilobytes. Not applicable to data warehouses |
| azure_sql_servers_databases_tempdb_log_size | tempdb_log_size | Tempdb Log File Size Kilobytes | Count | Average | Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses |
| azure_sql_servers_databases_tempdb_log_used_percent | tempdb_log_used_percent | Tempdb Percent Log Used | Percent | Average | Space used percentage in tempdb transaction log file. Not applicable to data warehouses |
| azure_sql_servers_databases_wlg_active_queries | wlg_active_queries | Workload group active queries | Count | Total | Active queries within the workload group. Applies only to data warehouses |
| azure_sql_servers_databases_wlg_active_queries_timeouts | wlg_active_queries_timeouts | Workload group query timeouts | Count | Total | Queries that have timed out for the workload group. Applies only to data warehouses |
| azure_sql_servers_databases_wlg_allocation_relative_to_system_percent | wlg_allocation_relative_to_system_percent | Workload group allocation by system percent | Percent | Average | Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses |
| azure_sql_servers_databases_wlg_allocation_relative_to_wlg_effective_cap_percent | wlg_allocation_relative_to_wlg_effective_cap_percent | Workload group allocation by cap resource percent | Percent | Average | Allocated percentage of resources relative to the specified cap resources per workload group. Applies only to data warehouses |
| azure_sql_servers_databases_wlg_effective_cap_resource_percent | wlg_effective_cap_resource_percent | Effective cap resource percent | Percent | Average | A hard limit on the percentage of resources allowed for the workload group, taking into account Effective Min Resource Percentage allocated for other workload groups. Applies only to data warehouses |
| azure_sql_servers_databases_wlg_effective_min_resource_percent | wlg_effective_min_resource_percent | Effective min resource percent | Percent | Average | Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. Applies only to data warehouses |
| azure_sql_servers_databases_wlg_queued_queries | wlg_queued_queries | Workload group queued queries | Count | Total | Queued queries within the workload group. Applies only to data warehouses |