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