azure.sql_servers_databases.active_queries
(count) | Active queries across all workload groups. Applies only to data warehouses. |
azure.sql_servers_databases.data_space_allocated
(gauge) | Allocated data storage. Not applicable to data warehouses.
Shown as byte |
azure.sql_servers_databases.app_cpu_billed
(count) | App CPU billed. Applies to serverless databases. |
azure.sql_servers_databases.app_cpu_percentage
(gauge) | App CPU percentage. Applies to serverless databases.
Shown as percent |
azure.sql_servers_databases.app_memory_percentage
(gauge) | App memory percentage. Applies to serverless databases.
Shown as percent |
azure.sql_servers_databases.data_storage_size
(gauge) | Data storage size. Applies to Hyperscale databases.
Shown as byte |
azure.sql_servers_databases.blocked_by_firewall
(count) | Blocked by Firewall. |
azure.sql_servers_databases.cache_hit_percentage
(gauge) | Cache hit percentage. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.cache_used_percentage
(gauge) | Cache used percentage. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.connection_failed
(count) | Failed Connections. |
azure.sql_servers_databases.connection_successful
(count) | Successful Connections. |
azure.sql_servers_databases.core_count
(gauge) | Core count. |
azure.sql_servers_databases.cpu_limit
(gauge) | CPU limit. Applies to vCore-based databases. |
azure.sql_servers_databases.cpu_percent
(gauge) | CPU percentage.
Shown as percent |
azure.sql_servers_databases.cpu_percent.max
(gauge) | Maximum CPU percentage (Max Aggregated)
Shown as percent |
azure.sql_servers_databases.cpu_used
(gauge) | CPU used. Applies to vCore-based databases. |
azure.sql_servers_databases.cpu_used.max
(count) | Maximum CPU used. Applies to vCore-based databases. (Max Aggregated) |
azure.sql_servers_databases.deadlock
(count) | Deadlocks. Not applicable to data warehouses. |
azure.sql_servers_databases.remote_data_reads
(count) | Remote data reads in bytes.
Shown as byte |
azure.sql_servers_databases.total_remote_bytes_read_and_written
(count) | Total remote bytes read and written by compute.
Shown as byte |
azure.sql_servers_databases.remote_log_writes
(count) | Remote log writes in bytes.
Shown as byte |
azure.sql_servers_databases.differential_backup_storage_size
(gauge) | Cumulative differential backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.
Shown as byte |
azure.sql_servers_databases.dtu_consumption_percent
(gauge) | DTU Percentage. Applies to DTU-based databases.
Shown as percent |
azure.sql_servers_databases.dtu_limit
(gauge) | DTU Limit. Applies to DTU-based databases. |
azure.sql_servers_databases.dtu_used
(gauge) | DTU used. Applies to DTU-based databases. |
azure.sql_servers_databases.dwu_consumption_percent
(gauge) | DWU percentage. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.dwu_limit
(gauge) | DWU limit. Applies only to data warehouses. |
azure.sql_servers_databases.dwu_used
(gauge) | DWU used. Applies only to data warehouses. |
azure.sql_servers_databases.full_backup_storage_size
(gauge) | Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases.
Shown as byte |
azure.sql_servers_databases.local_tempdb_percentage
(gauge) | Local tempdb percentage. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.log_backup_storage_size
(gauge) | Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases.
Shown as byte |
azure.sql_servers_databases.log_write_percent
(gauge) | Log IO percentage. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.memory_percentage
(gauge) | Memory percentage. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.physical_data_read_percent
(gauge) | Data IO percentage.
Shown as percent |
azure.sql_servers_databases.physical_data_read_percent.max
(gauge) | Maximum Data IO percentage (Max Aggregated)
Shown as percent |
azure.sql_servers_databases.queued_queries
(count) | Queued queries across all workload groups. Applies only to data warehouses. |
azure.sql_servers_databases.replication_links.count
(gauge) | The amount of replication links per database |
azure.sql_servers_databases.sessions_percent
(gauge) | Sessions percentage. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.data_backup_storage_size
(gauge) | Cumulative data backup storage size. Applies to Hyperscale databases.
Shown as byte |
azure.sql_servers_databases.sql_server_process_core_percent
(gauge) | CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.sql_server_process_memory_percent
(gauge) | Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.storage
(gauge) | Data space used. Not applicable to data warehouses.
Shown as byte |
azure.sql_servers_databases.storage_percent
(gauge) | Data space used percent. Not applicable to data warehouses or hyperscale databases.
Shown as percent |
azure.sql_servers_databases.tempdb_data_file_size_kilobytes
(gauge) | Space used in tempdb data files in kilobytes. Not applicable to data warehouses. |
azure.sql_servers_databases.tempdb_log_file_size_kilobytes
(gauge) | Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses. |
azure.sql_servers_databases.tempdb_percent_log_used
(gauge) | Space used percentage in tempdb transaction log file. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.workload_group_active_queries
(count) | Active queries within the workload group. Applies only to data warehouses. |
azure.sql_servers_databases.workload_group_query_timeouts
(count) | Queries that have timed out for the workload group. Applies only to data warehouses. |
azure.sql_servers_databases.workload_group_allocation_by_system_percent
(gauge) | Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.workload_group_allocation_by_cap_resource_percent
(gauge) | Allocated percentage of resources relative to the specified cap resources per workload group. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.effective_cap_resource_percent
(gauge) | 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.
Shown as percent |
azure.sql_servers_databases.effective_min_resource_percent
(gauge) | Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. Applies only to data warehouses.
Shown as percent |
azure.sql_servers_databases.workload_group_queued_queries
(count) | Queued queries within the workload group. Applies only to data warehouses. |
azure.sql_servers_databases.workers_percent
(gauge) | Workers percentage. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.xtp_storage_percent
(gauge) | In-Memory OLTP storage percent. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.count
(gauge) | Count of Azure SQL Database resources. |
azure.sql_servers_databases.app_cpu_billed_ha_replicas
(count) | Sum of app CPU billed across all HA replicas associated with the primary replica or a named replica. |
azure.sql_servers_databases.availability
(gauge) | 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.
Shown as percent |
azure.sql_servers_databases.failed_connections_user_errors
(count) | Failed connections : user errors. |
azure.sql_servers_databases.free_amount_consumed
(gauge) | Free amount of vcore seconds consumed this month. Applies only to free database offer. |
azure.sql_servers_databases.free_amount_remaining
(gauge) | Free amount of vcore seconds remaining this month. Applies only to free database offer. |
azure.sql_servers_databases.failed_ledger_digest_uploads
(count) | Ledger digests that failed to be uploaded. |
azure.sql_servers_databases.successful_ledger_digest_uploads
(count) | Ledger digests that were successfully uploaded. |
azure.sql_servers_databases.replication_lag_preview
(gauge) | 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.
Shown as second |
azure.sql_servers_databases.sessions_count
(gauge) | Number of active sessions. Not applicable to synapse DW analytics. |
azure.sql_servers_databases.sql_instance_cpu_percent
(gauge) | CPU usage by all user and system workloads. Not applicable to data warehouses.
Shown as percent |
azure.sql_servers_databases.sql_instance_memory_percent
(gauge) | Memory usage by the database engine instance. Not applicable to data warehouses.
Shown as percent |
