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 | Description | Aggregation Type |
|---|---|---|---|---|---|
| azure_sql_database_allocated_data_storage | allocated_data_storage | Data space allocated | Bytes | Maximum amount of storage space allocated for a specific database. | Average |
| azure_sql_database_app_cpu_billed | cpu_billed | App CPU billed | Count | Amount of CPU resources consumed by your database. | Total |
| azure_sql_database_app_cpu_percent | cpu_percent | App CPU percentage | Percent | Percentage of the CPU resources allocated to your database. | Average |
| azure_sql_database_app_memory_percent | app_memory_percent | App memory used percentage | Percent | Percentage of the memory resources allocated to your database, | Average |
| azure_sql_database_blocked_by_firewall | blocked_by_firewall | Blocked by Firewall | Count | Refers to a situation where the Azure SQL Database instance is blocked by firewall. | Total |
| azure_sql_database_cache_hit_percent | cache_hit_percent | Cache hit percentage | Percent | Percentage of queries that are served using data that is already present in the database cache. | Maximum |
| azure_sql_database_cache_used_percent | cache_used_percent | Cache used percentage | Percent | Refers to the percentage of memory allocated to the database cache that is currently in use. | Maximum |
| azure_sql_database_connection_failed | connection_failed | Failed Connections | Count | Error or failure that occurs when attempting to establish a connection to an Azure SQL Database. | Total |
| azure_sql_database_connection_successful | connections_successful | Successful Connections | Count | Number of successful connections. | Total |
| azure_sql_database_cpu_percent | cpu_percent | CPU Percentage | Percent | CPU percentage. | Average |
| azure_sql_database_cpu_limit | cpu_limit | CPU limit | Count | CPU limit. | Average |
| azure_sql_database_cpu_used | cpu_used | CPU used | Count | CPU used. | Average |
| azure_sql_database_deadlock | deadlock | Dead Locks | Count | Dead locks. | Total |
| azure_sql_database_dtu_limit | dtu_limit | DTU Limit | Count | DTU limit. | Average |
| azure_sql_database_dtu_consumption_percent | dtu_consumption_percent | DTU percentage | Percent | DTU percentage. | Average |
| azure_sql_database_dtu_used | dtu_used | DTU used | Count | DTU used. | Average |
| azure_dw_cpu_percent | dwu_cpu_percent | DW node level CPU percentage | Percent | DW node level CPU percentage. | Average |
| azure_dw_physical_data_read_percent | dw_physical_data_read_percent | DW node level Data IO percentage | Percent | DW node level Data IO percentage. | Average |
| azure_dwu_consumption_percent | dwu_consumption_percent | DWU percentage | Percent | DWU percentage. | Maximum |
| azure_sql_database_dwu_limit | dwu_limit | DWU limit | Count | DWU limit. | Maximum |
| azure_sql_database_local_tempdb_usage_percent | local_tempdb_usage_percent | Local tempdb usage percent | Percent | Local temporarily database usage percent. | Average |
| azure_sql_database_log_write_percent | log_write_percent | Log IO percentage | Percent | Log IO percentage. | Average |
| azure_sql_database_physical_data_read_percent | phyiscal_data_read_percent | Data IO percentage | Percent | Data IO percentage. | Average |
| azure_sql_database_sessions_percent | sessions_percent | Sessions percentage | Percent | Sessions percentage. | Average |
| azure_sql_database_sqlserver_process_core_percent | sqlserver_process_core_percent | SQL Server process core percent | Percent | SQL server procces core percent. | Maximum |
| azure_sql_database_sqlserver_process_memory_percent | sqlserver_process_memory_percent | SQL Server process memory percent | Percent | SQL Server process memory percent. | Maximum |
| azure_sql_database_storage | storage | Storage | Bytes | Availability of storage. | n/a |
| azure_sql_database_storage_percent | storage_percent | Storage Percent | Percent | Database size percentage. | Percent |
| azure_sql_database_tempdb_data_size | tempdb_data_size | Tempdb Data File Size Kilobytes | Count | Temporary database data file size in kilobytes. | Maximum |
| azure_sql_database_tempdb_log_size | tempdb_log_size | Tempdb Log File Size Kilobytes | Count | Temporary database log file size in kilobytes. | Maximum |
| azure_sql_database_tempdb_log_used_percent | tempdb_log_used_percent | Tempdb Percent Log Used | Percent | Temporary database percent log used. | Maximum |
| azure_sql_database_workers_percent | workers_percent | Workers percentage | Percent | Workers percent. | Average |
| azure_sql_database_xtp_storage_percent | xtp_storage_percent | In-Memory OLTP storage percent | Percent | In-Memory OLTP storage percent. | Average |
| cloud_instance_state | Status/State | n/a | Status/State | n/a | |
| azure_sql_servers_databases_connection_failed_user_error | connection_failed_user_error | Failed Connections : User Errors | Count | Failed Connections : User Errors | Total |
| azure_sql_servers_databases_ledger_digest_upload_failed | ledger_digest_upload_failed | Failed Ledger Digest Uploads | Count | Ledger digests that failed to be uploaded. | Countg |
| azure_sql_servers_databases_ledger_digest_upload_success | ledger_digest_upload_success | Successful Ledger Digest Uploads | Count | Ledger digests that were successfully uploaded. | Countg |
| azure_sql_servers_databases_log_backup_size_bytes | log_backup_size_bytes | Log backup storage size | Bytes | Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases. | Average |
| azure_sql_servers_databases_snapshot_backup_size_bytes | snapshot_backup_size_bytes | Data backup storage size | Bytes | Cumulative data backup storage size. Applies to Hyperscale databases. | Average |
| azure_sql_servers_databases_base_blob_size_bytes | base_blob_size_bytes | Data storage size | Bytes | Data storage size. Applies to Hyperscale databases. | Average |
| azure_sql_servers_databases_sql_instance_cpu_percent | sql_instance_cpu_percent | SQL instance CPU percent | Percent | CPU usage by all user and system workloads. Not applicable to data warehouses. | Average |
| azure_sql_servers_databases_sql_instance_memory_percent | sql_instance_memory_percent | SQL instance memory percent | Percent | Memory usage by the database engine instance. Not applicable to data warehouses. | Average |
| azure_sql_servers_databases_sessions_count | sessions_count | Sessions count | Count | Number of active sessions. Not applicable to Synapse DW Analytics. | Average |
| azure_sql_servers_databases_diff_backup_size_bytes | diff_backup_size_bytes | Differential backup storage size | Bytes | Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. | Average |
| azure_sql_servers_databases_full_backup_size_bytes | full_backup_size_bytes | Full backup storage size | Bytes | Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. | Average |
| azure_sql_servers_databases_availability | availability | Availability (Preview) | Percentg | The percentage of SLA-compliant availability for the database, calculated based on successful connections. For each one-minute data point, the availability is recorded as 100% if the connection(s) succeed, or 0% if all connections fail due to system errors. | Average |