Azure SQL DB
Overview
Azure SQL Database gives you a robust data store with the flexibility to scale to meet demand. To get metrics from Azure SQL Database you need to:
- Visualize the performance of SQL DB.
- Correlate the performance of SQL DB with your applications.
Metrics
| azure.sql.database.storage.size.bytes | Data space used. Not applicable to data warehouses. | Bytes |
| azure.sql.database.cpu.percent | CPU percentage. | percent |
| azure.sql.database.data.storage.used.bytes | Data storage size. Applies to Hyperscale databases. | Bytes |
| azure.sql.database.data.storage.allocated.bytes | Allocated data storage. Not applicable to data warehouses. | Bytes |
| azure.sql.database.data.storage.used.percent | Data space used percent. Not applicable to data warehouses or hyperscale databases. | percent |
| azure.sql.database.in.memory.oltp.storage.used.percent | In-Memory OLTP storage percent. Not applicable to data warehouses. | percent |
| azure.sql.database.dtu.limit | DTU Limit. Applies to DTU-based databases. | percent |
| azure.sql.database.used.dtu | DTU used. Applies to DTU-based databases. | percent |
| azure.sql.database.dtu.utilization.percent | DTU Percentage. Applies to DTU-based databases. | percent |
| azure.sql.database.sql.server.process.memory.used.percent | Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses. | percent |
| azure.sql.database.tempdb.data.file.size.bytes | Space used in tempdb data files in kilobytes. Not applicable to data warehouses. | Count |
| azure.sql.database.tempdb.log.file.size.bytes | Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses. | Count |
| azure.sql.database.used.tempdb.log.utilization.percent | Space used percentage in tempdb transaction log file. Not applicable to data warehouses. | percent |
