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.
External reference
Setup
To set up the Azure integration and discover the Azure service, go to Azure Integration Discovery Profile and select SQL Databases.
Event support
- Supported
- Configurable in OpsRamp Azure Integration Discovery Profile.
Supported metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| azure_sql_database_allocated_data_storage Data space allocated. | Data space allocated | Bytes | Average |
| azure_sql_database_app_cpu_billed App CPU billed. | App CPU billed | Count | Total |
| azure_sql_database_app_cpu_percent App CPU percentage. | App CPU percentage | Percent | Average |
| azure_sql_database_app_memory_percent App memory used percentage. | App memory used percentage | Percent | Average |
| azure_sql_database_blocked_by_firewall Blocked by firewall. | Blocked by Firewall | Count | Total |
| azure_sql_database_cache_hit_percent Cache hit percentage. | Cache hit percentage | Percent | Maximum |
| azure_sql_database_cache_used_percent Cache used percentage. | Cache used percentage | Percent | Maximum |
| azure_sql_database_connection_failed Number of failed connections. | Failed Connections | Count | Total |
| azure_sql_database_connection_successful Number of successful connections. | Successful Connections | Count | Total |
| azure_sql_database_cpu_percent CPU percentage. | CPU Percentage | Percent | Average |
| azure_sql_database_cpu_limit CPU limit. | CPU limit | Count | Average |
| azure_sql_database_cpu_used CPU used. | CPU used | Count | Average |
| azure_sql_database_deadlock Dead locks. | Dead Locks | Count | Total |
| azure_sql_database_dtu_limit DTU limit. | DTU Limit | Count | Average |
| azure_sql_database_dtu_consumption_percent DTU percentage. | DTU percentage | Percent | Average |
| azure_sql_database_dtu_used DTU used. | DTU used | Count | Average |
| azure_dw_cpu_percent DW node level CPU percentage. | DW node level CPU percentage | Percent | Average |
| azure_dw_physical_data_read_percent DW node level Data IO percentage. | DW node level Data IO percentage | Percent | Average |
| azure_dwu_consumption_percent DWU percentage. | DWU percentage | Percent | Maximum |
| azure_sql_database_dwu_limit DWU limit. | DWU limit | Count | Maximum |
| azure_sql_database_local_tempdb_usage_percent Local temporarily database usage percent. | Local tempdb usage percent | Percent | Average |
| azure_sql_database_log_write_percent Log IO percentage. | Log IO percentage | Percent | Average |
| azure_sql_database_physical_data_read_percent Data IO percentage. | Data IO percentage | Percent | Average |
| azure_sql_database_sessions_percent Sessions percentage. | Sessions percentage | Percent | Average |
| azure_sql_database_sqlserver_process_core_percent SQL server procces core percent. | SQL Server process core percent | Percent | Maximum |
| azure_sql_database_sqlserver_process_memory_percent SQL Server process memory percent. | SQL Server process memory percent | Percent | Maximum |
| azure_sql_database_storage Availability of storage. | Storage | Bytes | n/a |
| azure_sql_database_storage_percent Database size percentage. | Storage Percent | Percent | Percent |
| azure_sql_database_tempdb_data_size Temporary database data file size in kilobytes. | Tempdb Data File Size Kilobytes | Count | Maximum |
| azure_sql_database_tempdb_log_size Temporary database log file size in kilobytes. | Tempdb Log File Size Kilobytes | Count | Maximum |
| azure_sql_database_tempdb_log_used_percent Temporary database percent log used. | Tempdb Percent Log Used | Percent | Maximum |
| azure_sql_database_workers_percent Workers percent. | Workers percentage | Percent | Average |
| azure_sql_database_xtp_storage_percent In-Memory OLTP storage percent. | In-Memory OLTP storage percent | Percent | Average |
| cloud_instance_state Status/State | Status/State | n/a | n/a |