Microsoft Azure
Introduction
Middleware’s Azure Integration connects to Microsoft Azure accounts to enable useres to monitor and visualize key performance metrics across a range of Azure services.
With this integration, users can configure which services to monitor, collect detailed metrics, and visualize the data using Middleware's built-in dashboard tools, or build custom alerts and dashboards of their own.
Integration Setup
Azure Configuration
To integrate Azure with Middleware, you must first complete the following steps in the Azure Portal:
1 Create an App Registration
Navigate to App Registrations from Azure Services or use the search box.
Click New Registration.
Enter "Middleware Auth" as the name for the App Registration.
Next, Select "Accounts in this organizational directory only (Middleware - Single tenant)" in the Supported account types section.
Click Register.
2 Assign 'Monitoring Reader' permissions to the Application
To assign the 'Monitoring Reader' permissions, navigate to Subscriptions for a single subscription level, or go to Management Groups to assign permission across multiple subscriptions. Assigning permissions at the Management Group level provides access to any new subscriptions added later.
Select the subscription you wish to monitor.
Go to Access control (IAM) in the Subscription menu and select Add role assignment from Add menu.
In the Role tab, select Monitoring Reader and click Next.
In the Members tab, click Select members, choose the Middleware Auth and click Review + assign.
Middleware Configuration
After completing the App Registration, configure the integration on the Middleware platform using details from the App Registration:
1 Copy App Registration Details
After assigning the 'Monitoring Reader' permissions, copy the Subscription ID.
Copy Application (client) ID and Directory (tenant) ID from the Middleware Auth App Registration.
Paste these three values into the relevant fields on the Azure Integration form in Middleware.
To generate Client Secret, go to Manage > Certificates and secrets.
Click New client secret, enter "middlewareClientSecret" as the Description and select an expiration range.
After adding the Client Secret, copy the Value and paste it into the Client Secret field in Middleware.
2 Configuring Metric Collection
Once details are saved, proceed to the Configure Metric Collection step. Here, you can select which Azure integrations to monitor.
Once configured, click Save Configuration to finalize setup and proceed to the Dashboard Builder to find the relevant dashboard. Newly configured integrations take a few minutes to begin displaying data.
Supported Azure Integrations
We currently collect metrics from the following Azure Integrations: Azure Container Service, Azure CosmosDB for PostgreSQL, Azure DB for MySQL, Azure DB for PostgreSQL, Azure Load Balancers, Azure SQL Database, Azure SQL Elastic Pool, Azure VM Scale Set and Blob Storage. Additional Azure integrations are continuously added and will be released upon completion.
For specific needs, please contact our support team for prioritization.
Accessing Data
To begin viewing metrics or creating new widgets, visit the Dashboards page.
Metrics Collected
Container Service
CosmosDB for PostgreSQL
DB for MySQL
DB for PostgreSQL
Load Balancer
SQL Database
SQL Elastic Pool
VM Scale Set
Blob Storage
| Metrics Name | Description |
|---|---|
azure.containerservice_managedclusters.apiserver_current_inflight_requests | Inflight Requests |
azure.containerservice_managedclusters.cluster_autoscaler_cluster_safe_to_autoscale | Cluster Health |
azure.containerservice_managedclusters.cluster_autoscaler_scale_down_in_cooldown | Scale Down Cooldown |
azure.containerservice_managedclusters.cluster_autoscaler_unneeded_nodes_count | Unneeded Nodes |
azure.containerservice_managedclusters.cluster_autoscaler_unschedulable_pods_count | Unschedulable Pods |
azure.containerservice_managedclusters.kube_node_status_allocatable_cpu_cores | Total number of available cpu cores in a managed cluster |
azure.containerservice_managedclusters.kube_node_status_allocatable_memory_bytes | Total amount of available memory in a managed cluster |
azure.containerservice_managedclusters.kube_node_status_condition | Statuses for various node conditions |
azure.containerservice_managedclusters.kube_pod_status_phase | Number of pods by phase |
azure.containerservice_managedclusters.kube_pod_status_ready | Number of pods in Ready state |
azure.containerservice_managedclusters.node_cpu_usage_millicores | Aggregated measurement of CPU utilization in millicores across the cluster |
azure.containerservice_managedclusters.node_cpu_usage_percentage | Aggregated average CPU utilization measured in percentage across the cluster |
azure.containerservice_managedclusters.node_disk_usage_bytes | Disk space used in bytes by device |
azure.containerservice_managedclusters.node_disk_usage_percentage | Disk space used in percent by device |
azure.containerservice_managedclusters.node_memory_rss_bytes | Container RSS memory used in bytes |
azure.containerservice_managedclusters.node_memory_rss_percentage | Container RSS memory used in percent |
azure.containerservice_managedclusters.node_memory_working_set_bytes | Container working set memory used in bytes |
azure.containerservice_managedclusters.node_memory_working_set_percentage | Container working set memory used in percent |
azure.containerservice_managedclusters.node_network_in_bytes | Network received bytes |
azure.containerservice_managedclusters.node_network_out_bytes | Network transmitted bytes |
| Metrics Name | Description |
|---|---|
azure.dbforpostgresql_servergroupsv2.active_connections | Active Connections |
azure.dbforpostgresql_servergroupsv2.apps_reserved_memory_percent | Reserved Memory percent |
azure.dbforpostgresql_servergroupsv2.cpu_credits_consumed | CPU Credits Consumed |
azure.dbforpostgresql_servergroupsv2.cpu_credits_remaining | CPU Credits Remaining |
azure.dbforpostgresql_servergroupsv2.cpu_percent | CPU percent |
azure.dbforpostgresql_servergroupsv2.iops | IOPS |
azure.dbforpostgresql_servergroupsv2.memory_percent | Memory percent |
azure.dbforpostgresql_servergroupsv2.network_bytes_egress | Network Out |
azure.dbforpostgresql_servergroupsv2.network_bytes_ingress | Network In |
azure.dbforpostgresql_servergroupsv2.replication_lag | Replication lag |
azure.dbforpostgresql_servergroupsv2.storage_percent | Storage percent |
azure.dbforpostgresql_servergroupsv2.storage_used | Storage used |
azure.dbforpostgresql_servergroupsv2.vm_cached_bandwidth_percent | VM Cached Bandwidth Consumed Percentage |
azure.dbforpostgresql_servergroupsv2.vm_cached_iops_percent | VM Cached IOPS Consumed Percentage |
azure.dbforpostgresql_servergroupsv2.vm_uncached_bandwidth_percent | VM Uncached Bandwidth Consumed Percentage |
azure.dbforpostgresql_servergroupsv2.vm_uncached_iops_percent | VM Uncached IOPS Consumed Percentage |
| Metrics Name | Description |
|---|---|
azure.dbformysql_flexibleservers.aborted_connections | Aborted Connections |
azure.dbformysql_flexibleservers.active_connections | Active Connections |
azure.dbformysql_flexibleservers.active_transactions | Number of active transactions. |
azure.dbformysql_flexibleservers.backup_storage_used | Backup Storage Used |
azure.dbformysql_flexibleservers.binlog_storage_used | Storage used by Binlog files. |
azure.dbformysql_flexibleservers.com_alter_table | The number of times ALTER TABLE statement has been executed. |
azure.dbformysql_flexibleservers.com_create_db | The number of times CREATE DB statement has been executed. |
azure.dbformysql_flexibleservers.com_create_table | The number of times CREATE TABLE statement has been executed. |
azure.dbformysql_flexibleservers.com_delete | The number of times DELETE statement has been executed. |
azure.dbformysql_flexibleservers.com_drop_db | The number of times DROP DB statement has been executed. |
azure.dbformysql_flexibleservers.com_drop_table | The number of times DROP TABLE statement has been executed. |
azure.dbformysql_flexibleservers.com_insert | The number of times INSERT statement has been executed. |
azure.dbformysql_flexibleservers.com_select | The number of times SELECT statement has been executed. |
azure.dbformysql_flexibleservers.com_update | The number of times UPDATE statement has been executed. |
azure.dbformysql_flexibleservers.cpu_credits_consumed | CPU Credits Consumed |
azure.dbformysql_flexibleservers.cpu_credits_remaining | CPU Credits Remaining |
azure.dbformysql_flexibleservers.cpu_percent | Host CPU Percent |
azure.dbformysql_flexibleservers.data_storage_used | Storage used by data files. |
azure.dbformysql_flexibleservers.ha_io_status | Status for replication IO thread running |
azure.dbformysql_flexibleservers.ha_replication_lag | HA Replication lag in seconds |
azure.dbformysql_flexibleservers.ha_sql_status | Status for replication SQL thread running |
azure.dbformysql_flexibleservers.ibdata1_storage_used | Storage used by ibdata1 files. |
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_data | The number of pages in the InnoDB buffer pool containing data. |
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_dirty | The current number of dirty pages in the InnoDB buffer pool. |
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_flushed | The number of requests to flush pages from the InnoDB buffer pool. |
azure.dbformysql_flexibleservers.innodb_buffer_pool_pages_free | The number of free pages in the InnoDB buffer pool. |
azure.dbformysql_flexibleservers.innodb_buffer_pool_read_requests | The number of logical read requests. |
azure.dbformysql_flexibleservers.innodb_buffer_pool_reads | The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from disk. |
azure.dbformysql_flexibleservers.innodb_data_writes | The total number of data writes. |
azure.dbformysql_flexibleservers.innodb_row_lock_time | The total time spent in acquiring row locks for InnoDB tables, in milliseconds. |
azure.dbformysql_flexibleservers.innodb_row_lock_waits | The number of times operations on InnoDB tables had to wait for a row lock. |
azure.dbformysql_flexibleservers.io_consumption_percent | Storage I/O consumption percent |
azure.dbformysql_flexibleservers.lock_deadlocks | Number of deadlocks. |
azure.dbformysql_flexibleservers.lock_timeouts | Number of lock timeouts. |
azure.dbformysql_flexibleservers.memory_percent | Memory Percent |
azure.dbformysql_flexibleservers.network_bytes_egress | Host Network egress in bytes |
azure.dbformysql_flexibleservers.network_bytes_ingress | Host Network ingress in bytes |
azure.dbformysql_flexibleservers.others_storage_used | Storage used by other files. |
azure.dbformysql_flexibleservers.queries | Queries |
azure.dbformysql_flexibleservers.replica_io_running | Status for replication IO thread running |
azure.dbformysql_flexibleservers.replica_sql_running | Status for replication SQL thread running |
azure.dbformysql_flexibleservers.replication_lag | Replication lag in seconds |
azure.dbformysql_flexibleservers.serverlog_storage_limit | Serverlog Storage Limit |
azure.dbformysql_flexibleservers.serverlog_storage_percent | Serverlog Storage Percent |
azure.dbformysql_flexibleservers.serverlog_storage_usage | Serverlog Storage Used |
azure.dbformysql_flexibleservers.slow_queries | The number of queries that have taken more than long_query_time seconds. |
azure.dbformysql_flexibleservers.storage_io_count | The number of storage I/O consumed. |
azure.dbformysql_flexibleservers.storage_limit | Storage Limit |
azure.dbformysql_flexibleservers.storage_percent | Storage Percent |
azure.dbformysql_flexibleservers.storage_used | Storage Used |
azure.dbformysql_flexibleservers.threads_running | The number of threads that are not sleeping. |
azure.dbformysql_flexibleservers.total_connections | Total Connections |
azure.dbformysql_flexibleservers.trx_rseg_history_len | Length of the TRX_RSEG_HISTORY list. |
azure.dbformysql_flexibleservers.uptime | The number of seconds that the server has been up. |
azure.dbformysql_servers.active_connections | Active Connections |
azure.dbformysql_servers.backup_storage_used | Backup Storage used |
azure.dbformysql_servers.connections_failed | Failed Connections |
azure.dbformysql_servers.cpu_percent | CPU percent |
azure.dbformysql_servers.io_consumption_percent | IO percent |
azure.dbformysql_servers.memory_percent | Memory percent |
azure.dbformysql_servers.network_bytes_egress | Network Out across active connections |
azure.dbformysql_servers.network_bytes_ingress | Network In across active connections |
azure.dbformysql_servers.seconds_behind_master | Replication lag in seconds |
azure.dbformysql_servers.serverlog_storage_limit | Server Log storage limit |
azure.dbformysql_servers.serverlog_storage_percent | Server Log storage percent |
azure.dbformysql_servers.serverlog_storage_usage | Server Log storage used |
azure.dbformysql_servers.storage_limit | Storage limit |
azure.dbformysql_servers.storage_percent | Storage percent |
azure.dbformysql_servers.storage_used | Storage used |
| Metrics Name | Description |
|---|---|
azure.dbforpostgresql_flexibleservers.active_connections | Active Connections |
azure.dbforpostgresql_flexibleservers.analyze_count_user_tables | Analyze Counter User Tables |
azure.dbforpostgresql_flexibleservers.autoanalyze_count_user_tables | AutoAnalyze Counter User Tables |
azure.dbforpostgresql_flexibleservers.autovacuum_count_user_tables | AutoVacuum Counter User Tables |
azure.dbforpostgresql_flexibleservers.backup_storage_used | Backup Storage Used |
azure.dbforpostgresql_flexibleservers.blks_hit | Disk Blocks Hit |
azure.dbforpostgresql_flexibleservers.blks_read | Disk Blocks Read |
azure.dbforpostgresql_flexibleservers.bloat_percent | Bloat Percent (Preview) |
azure.dbforpostgresql_flexibleservers.client_connections_active | Active client connections |
azure.dbforpostgresql_flexibleservers.client_connections_waiting | Waiting client connections |
azure.dbforpostgresql_flexibleservers.connections_failed | Failed Connections |
azure.dbforpostgresql_flexibleservers.connections_succeeded | Succeeded Connections |
azure.dbforpostgresql_flexibleservers.cpu_credits_consumed | CPU Credits Consumed |
azure.dbforpostgresql_flexibleservers.cpu_credits_remaining | CPU Credits Remaining |
azure.dbforpostgresql_flexibleservers.cpu_percent | CPU percent |
azure.dbforpostgresql_flexibleservers.database_size_bytes | Database Size |
azure.dbforpostgresql_flexibleservers.deadlocks | Deadlocks |
azure.dbforpostgresql_flexibleservers.disk_bandwidth_consumed_percentage | Disk Bandwidth Consumed Percentage |
azure.dbforpostgresql_flexibleservers.disk_iops_consumed_percentage | Disk IOPS Consumed Percentage |
azure.dbforpostgresql_flexibleservers.disk_queue_depth | Disk Queue Depth |
azure.dbforpostgresql_flexibleservers.iops | IOPS |
azure.dbforpostgresql_flexibleservers.is_db_alive | Database Is Alive |
azure.dbforpostgresql_flexibleservers.logical_replication_delay | Max Logical Replication Lag |
azure.dbforpostgresql_flexibleservers.longest_query_time_sec | Oldest Query |
azure.dbforpostgresql_flexibleservers.longest_transaction_time_sec | Oldest Transaction |
azure.dbforpostgresql_flexibleservers.max_connections | Max Connections |
azure.dbforpostgresql_flexibleservers.maximum_used_transactionIDs | Maximum Used Transaction IDs |
azure.dbforpostgresql_flexibleservers.memory_percent | Memory percent |
azure.dbforpostgresql_flexibleservers.n_dead_tup_user_tables | Estimated Dead Rows User Tables |
azure.dbforpostgresql_flexibleservers.n_live_tup_user_tables | Estimated Live Rows User Tables |
azure.dbforpostgresql_flexibleservers.n_mod_since_analyze_user_tables | Estimated Modifications User Tables |
azure.dbforpostgresql_flexibleservers.network_bytes_egress | Network Out |
azure.dbforpostgresql_flexibleservers.network_bytes_ingress | Network In |
azure.dbforpostgresql_flexibleservers.num_pools | Number of connection pools |
azure.dbforpostgresql_flexibleservers.numbackends | Backends |
azure.dbforpostgresql_flexibleservers.oldest_backend_time_sec | Oldest Backend |
azure.dbforpostgresql_flexibleservers.oldest_backend_xmin | Oldest xmin |
azure.dbforpostgresql_flexibleservers.oldest_backend_xmin_age | Oldest xmin Age |
azure.dbforpostgresql_flexibleservers.physical_replication_delay | Max Physical Replication Lag |
azure.dbforpostgresql_flexibleservers.physical_replication_delay_in_seconds | Read Replica Lag |
azure.dbforpostgresql_flexibleservers.platform_cpu_percent | CPU percent from platform (Preview) |
azure.dbforpostgresql_flexibleservers.read_iops | Read IOPS |
azure.dbforpostgresql_flexibleservers.read_throughput | Read Throughput Bytes/Sec |
azure.dbforpostgresql_flexibleservers.server_connections_active | Active server connections |
azure.dbforpostgresql_flexibleservers.server_connections_idle | Idle server connections |
azure.dbforpostgresql_flexibleservers.sessions_by_state | Sessions by State |
azure.dbforpostgresql_flexibleservers.sessions_by_wait_event_type | Sessions by WaitEventType |
azure.dbforpostgresql_flexibleservers.storage_free | Storage Free |
azure.dbforpostgresql_flexibleservers.storage_percent | Storage percent |
azure.dbforpostgresql_flexibleservers.storage_used | Storage used |
azure.dbforpostgresql_flexibleservers.tables_analyzed_user_tables | User Tables Analyzed |
azure.dbforpostgresql_flexibleservers.tables_autoanalyzed_user_tables | User Tables AutoAnalyzed |
azure.dbforpostgresql_flexibleservers.tables_autovacuumed_user_tables | User Tables AutoVacuumed |
azure.dbforpostgresql_flexibleservers.tables_counter_user_tables | User Tables Counter |
azure.dbforpostgresql_flexibleservers.tables_vacuumed_user_tables | User Tables Vacuumed |
azure.dbforpostgresql_flexibleservers.temp_bytes | Temporary Files Size |
azure.dbforpostgresql_flexibleservers.temp_files | Temporary Files |
azure.dbforpostgresql_flexibleservers.total_pooled_connections | Total pooled connections |
azure.dbforpostgresql_flexibleservers.tps | Transactions per second (Preview) |
azure.dbforpostgresql_flexibleservers.tup_deleted | Tuples Deleted |
azure.dbforpostgresql_flexibleservers.tup_fetched | Tuples Fetched |
azure.dbforpostgresql_flexibleservers.tup_inserted | Tuples Inserted |
azure.dbforpostgresql_flexibleservers.tup_returned | Tuples Returned |
azure.dbforpostgresql_flexibleservers.tup_updated | Tuples Updated |
azure.dbforpostgresql_flexibleservers.txlogs_storage_used | Transaction Log Storage Used |
azure.dbforpostgresql_flexibleservers.vacuum_count_user_tables | Vacuum Counter User Tables |
azure.dbforpostgresql_flexibleservers.write_iops | Write IOPS |
azure.dbforpostgresql_flexibleservers.write_throughput | Write Throughput Bytes/Sec |
azure.dbforpostgresql_flexibleservers.xact_commit | Transactions Committed |
azure.dbforpostgresql_flexibleservers.xact_rollback | Transactions Rolled Back |
azure.dbforpostgresql_flexibleservers.xact_total | Total Transactions |
azure.dbforpostgresql_servers.active_connections | Active Connections |
azure.dbforpostgresql_servers.backup_storage_used | Backup Storage Used |
azure.dbforpostgresql_servers.connections_failed | Failed Connections |
azure.dbforpostgresql_servers.cpu_percent | CPU percent |
azure.dbforpostgresql_servers.io_consumption_percent | IO percent |
azure.dbforpostgresql_servers.memory_percent | Memory percent |
azure.dbforpostgresql_servers.network_bytes_egress | Network Out |
azure.dbforpostgresql_servers.network_bytes_ingress | Network In |
azure.dbforpostgresql_servers.pg_replica_log_delay_in_bytes | Max Lag Across Replicas |
azure.dbforpostgresql_servers.pg_replica_log_delay_in_seconds | Replica Lag |
azure.dbforpostgresql_servers.serverlog_storage_limit | Server Log storage limit |
azure.dbforpostgresql_servers.serverlog_storage_percent | Server Log storage percent |
azure.dbforpostgresql_servers.serverlog_storage_usage | Server Log storage used |
azure.dbforpostgresql_servers.storage_limit | Storage limit |
azure.dbforpostgresql_servers.storage_percent | Storage percent |
azure.dbforpostgresql_servers.storage_used | Storage used |
azure.dbforpostgresql_serversv2.active_connections | Active Connections |
azure.dbforpostgresql_serversv2.cpu_percent | CPU percent |
azure.dbforpostgresql_serversv2.iops | IOPS |
azure.dbforpostgresql_serversv2.memory_percent | Memory percent |
azure.dbforpostgresql_serversv2.network_bytes_egress | Network Out |
azure.dbforpostgresql_serversv2.network_bytes_ingress | Network In |
azure.dbforpostgresql_serversv2.storage_percent | Storage percent |
azure.dbforpostgresql_serversv2.storage_used | Storage used |
| Metrics Name | Description |
|---|---|
| azure.network_loadbalancers.allocated_snat_ports | Allocated SNAT Ports |
| azure.network_loadbalancers.byte_count | Byte Count |
| azure.network_loadbalancers.dip_availability | Health Probe Status |
| azure.network_loadbalancers.global_backend_availability | Health Probe Status |
| azure.network_loadbalancers.packet_count | Packet Count |
| azure.network_loadbalancers.snat_connection_count | SNAT Connection Count |
| azure.network_loadbalancers.syn_count | SYN Count |
| azure.network_loadbalancers.used_snat_ports | Used SNAT Ports |
| azure.network_loadbalancers.vip_availability | Data Path Availability |
| Metrics Name | Description |
|---|---|
azure.sql_servers_databases.active_queries | Active queries across all workload groups. Applies only to data warehouses. |
azure.sql_servers_databases.app_cpu_billed | App CPU billed. Applies to serverless databases. |
azure.sql_servers_databases.app_cpu_billed_ha_replicas | Sum of app CPU billed across all HA replicas associated with the primary replica or a named replica. |
azure.sql_servers_databases.app_cpu_percentage | App CPU percentage. Applies to serverless databases. |
azure.sql_servers_databases.app_memory_percentage | App memory percentage. Applies to serverless databases. |
azure.sql_servers_databases.availability | The percentage of SLA compliant availability for the database. |
azure.sql_servers_databases.blocked_by_firewall | Blocked by Firewall |
azure.sql_servers_databases.cache_hit_percentage | Cache hit percentage. Applies only to data warehouses. |
azure.sql_servers_databases.cache_used_percentage | Cache used percentage. Applies only to data warehouses. |
azure.sql_servers_databases.connection_failed | Failed Connections: System Errors |
azure.sql_servers_databases.connection_failed_user_error | Failed Connections: User Errors |
azure.sql_servers_databases.connection_successful | Successful Connections |
azure.sql_servers_databases.cpu_limit | CPU limit. Applies to vCore-based databases. |
azure.sql_servers_databases.cpu_percent | CPU percentage |
azure.sql_servers_databases.cpu_used | CPU used. Applies to vCore-based databases. |
azure.sql_servers_databases.data_space_allocated | Allocated data storage. Not applicable to data warehouses. |
azure.sql_servers_databases.data_storage_size | Data storage size. Applies to Hyperscale databases. |
azure.sql_servers_databases.deadlock | Deadlocks. Not applicable to data warehouses. |
azure.sql_servers_databases.differential_backup_storage_size | Cumulative differential backup storage size. Applies to vCore-based databases. |
azure.sql_servers_databases.dtu_consumption_percent | DTU Percentage. Applies to DTU-based databases. |
azure.sql_servers_databases.dtu_limit | DTU Limit. Applies to DTU-based databases. |
azure.sql_servers_databases.dtu_used | DTU used. Applies to DTU-based databases. |
azure.sql_servers_databases.dwu_consumption_percent | DWU percentage. Applies only to data warehouses. |
azure.sql_servers_databases.dwu_limit | DWU limit. Applies only to data warehouses. |
azure.sql_servers_databases.dwu_used | DWU used. Applies only to data warehouses. |
azure.sql_servers_databases.effective_cap_resource_percent | 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. |
azure.sql_servers_databases.effective_min_resource_percent | Minimum percentage of resources reserved and isolated for the workload group, taking into account the service level minimum. |
azure.sql_servers_databases.free_amount_consumed | Free amount of vCore seconds consumed this month. Applies only to free database offer. |
azure.sql_servers_databases.free_amount_remaining | Free amount of vCore seconds remaining this month. Applies only to free database offer. |
azure.sql_servers_databases.full_backup_storage_size | Cumulative full backup storage size. Applies to vCore-based databases. Not applicable to Hyperscale databases. |
azure.sql_servers_databases.ledger_digest_upload_failed | Ledger digests that failed to be uploaded. |
azure.sql_servers_databases.ledger_digest_upload_success | Ledger digests that were successfully uploaded. |
azure.sql_servers_databases.local_tempdb_percentage | Local tempdb percentage. Applies only to data warehouses. |
azure.sql_servers_databases.log_backup_storage_size | Cumulative log backup storage size. Applies to vCore-based and Hyperscale databases. |
azure.sql_servers_databases.log_write_percent | Log IO percentage. Not applicable to data warehouses. |
azure.sql_servers_databases.memory_percentage | Memory percentage. Applies only to data warehouses. |
azure.sql_servers_databases.physical_data_read_percent | Data IO percentage |
azure.sql_servers_databases.queued_queries | Queued queries across all workload groups. Applies only to data warehouses. |
azure.sql_servers_databases.sessions_count | Number of active sessions. Not applicable to Synapse DW Analytics. |
azure.sql_servers_databases.sessions_percent | Sessions percentage. Not applicable to data warehouses. |
azure.sql_servers_databases.snapshot_backup_size_bytes | Cumulative data backup storage size. Applies to Hyperscale databases. |
azure.sql_servers_databases.sql_instance_cpu_percent | CPU usage by all user and system workloads. Not applicable to data warehouses. |
azure.sql_servers_databases.sql_instance_memory_percent | Memory usage by the database engine instance. Not applicable to data warehouses. |
azure.sql_servers_databases.sql_server_process_core_percent | CPU usage as a percentage of the SQL DB process. Not applicable to data warehouses. |
azure.sql_servers_databases.sql_server_process_memory_percent | Memory usage as a percentage of the SQL DB process. Not applicable to data warehouses. |
azure.sql_servers_databases.storage | Data space used. Not applicable to data warehouses. |
azure.sql_servers_databases.storage_percent | Data space used percent. Not applicable to data warehouses or hyperscale databases. |
azure.sql_servers_databases.tempdb_data_file_size_kilobytes | Space used in tempdb data files in kilobytes. Not applicable to data warehouses. |
azure.sql_servers_databases.tempdb_log_file_size_kilobytes | Space used in tempdb transaction log file in kilobytes. Not applicable to data warehouses. |
azure.sql_servers_databases.tempdb_percent_log_used | Space used percentage in tempdb transaction log file. Not applicable to data warehouses. |
azure.sql_servers_databases.workers_percent | Workers percentage. Not applicable to data warehouses. |
azure.sql_servers_databases.workload_group_active_queries | Active queries within the workload group. Applies only to data warehouses. |
azure.sql_servers_databases.workload_group_allocation_by_cap_resource_percent | Allocated percentage of resources relative to the specified cap resources per workload group. |
azure.sql_servers_databases.workload_group_allocation_by_system_percent | Allocated percentage of resources relative to the entire system per workload group. Applies only to data warehouses. |
azure.sql_servers_databases.workload_group_query_timeouts | Queries that have timed out for the workload group. Applies only to data warehouses. |
azure.sql_servers_databases.workload_group_queued_queries | Queued queries within the workload group. Applies only to data warehouses. |
azure.sql_servers_databases.xtp_storage_percent | In-Memory OLTP storage percent. Not applicable to data warehouses. |
| Metrics Name | Description |
|---|---|
azure.sql_servers_elasticpools.app_cpu_billed | App CPU billed. Applies to serverless elastic pools. |
azure.sql_servers_elasticpools.app_cpu_percent | App CPU percentage. Applies to serverless elastic pools. |
azure.sql_servers_elasticpools.app_memory_percent | App memory percentage. Applies to serverless elastic pools. |
azure.sql_servers_elasticpools.cpu_limit | CPU limit. Applies to vCore-based elastic pools. |
azure.sql_servers_elasticpools.cpu_percent | CPU percentage |
azure.sql_servers_elasticpools.cpu_used | CPU used. Applies to vCore-based elastic pools. |
azure.sql_servers_elasticpools.data_space_allocated | Data space allocated |
azure.sql_servers_elasticpools.data_space_allocated_percent | Data space allocated percent. Not applicable to hyperscale. |
azure.sql_servers_elasticpools.dtu_consumption_percent | DTU Percentage. Applies to DTU-based elastic pools. |
azure.sql_servers_elasticpools.e_dtu_limit | eDTU limit. Applies to DTU-based elastic pools. |
azure.sql_servers_elasticpools.e_dtu_used | eDTU used. Applies to DTU-based elastic pools. |
azure.sql_servers_elasticpools.in_memory_oltp_storage_percent | In-Memory OLTP storage percent. Not applicable to hyperscale. |
azure.sql_servers_elasticpools.log_write_percent | Log IO percentage |
azure.sql_servers_elasticpools.physical_data_read_percent | Data IO percentage |
azure.sql_servers_elasticpools.sessions_count | Number of active sessions |
azure.sql_servers_elasticpools.sessions_percent | Sessions percentage |
azure.sql_servers_elasticpools.sql_instance_cpu_percent | CPU usage by all user and system workloads. Applies to elastic pools. |
azure.sql_servers_elasticpools.sql_instance_memory_percent | Memory usage by the database engine instance. Applies to elastic pools. |
azure.sql_servers_elasticpools.sqlserver_process_core_percent | CPU usage as a percentage of the SQL DB process. Applies to elastic pools. |
azure.sql_servers_elasticpools.sqlserver_process_memory_percent | Memory usage as a percentage of the SQL DB process. Applies to elastic pools. |
azure.sql_servers_elasticpools.storage_limit | Data max size. Not applicable to hyperscale |
azure.sql_servers_elasticpools.storage_percent | Data space used percent. Not applicable to hyperscale |
azure.sql_servers_elasticpools.storage_used | Data space used |
azure.sql_servers_elasticpools.tempdb_data_size | Space used in tempdb data files in kilobytes. |
azure.sql_servers_elasticpools.tempdb_log_size | Space used in tempdb transaction log file in kilobytes. |
azure.sql_servers_elasticpools.tempdb_log_used_percent | Space used percentage in tempdb transaction log file |
azure.sql_servers_elasticpools.workers_percent | Workers percentage |
| Metrics Name | Description |
|---|---|
| azure.compute_virtualmachinescalesets.available_memory_bytes | Available Memory Bytes (Preview) |
| azure.compute_virtualmachinescalesets.cpu_credits_consumed | CPU Credits Consumed |
| azure.compute_virtualmachinescalesets.cpu_credits_remaining | CPU Credits Remaining |
| azure.compute_virtualmachinescalesets.data_disk_bandwidth_consumed_percentage | Data Disk Bandwidth Consumed Percentage |
| azure.compute_virtualmachinescalesets.data_disk_iops_consumed_percentage | Data Disk IOPS Consumed Percentage |
| azure.compute_virtualmachinescalesets.data_disk_latency | Data Disk Latency (Preview) |
| azure.compute_virtualmachinescalesets.data_disk_max_burst_bandwidth | Data Disk Max Burst Bandwidth |
| azure.compute_virtualmachinescalesets.data_disk_max_burst_iops | Data Disk Max Burst IOPS |
| azure.compute_virtualmachinescalesets.data_disk_queue_depth | Data Disk Queue Depth |
| azure.compute_virtualmachinescalesets.data_disk_read_bytes_sec | Data Disk Read Bytes/Sec |
| azure.compute_virtualmachinescalesets.data_disk_read_operations_sec | Data Disk Read Operations/Sec |
| azure.compute_virtualmachinescalesets.data_disk_target_bandwidth | Data Disk Target Bandwidth |
| azure.compute_virtualmachinescalesets.data_disk_target_iops | Data Disk Target IOPS |
| azure.compute_virtualmachinescalesets.data_disk_used_burst_bps_credits_percentage | Data Disk Used Burst BPS Credits Percentage |
| azure.compute_virtualmachinescalesets.data_disk_used_burst_io_credits_percentage | Data Disk Used Burst IO Credits Percentage |
| azure.compute_virtualmachinescalesets.data_disk_write_bytes_sec | Data Disk Write Bytes/Sec |
| azure.compute_virtualmachinescalesets.data_disk_write_operations_sec | Data Disk Write Operations/Sec |
| azure.compute_virtualmachinescalesets.disk_read_bytes | Disk Read Bytes |
| azure.compute_virtualmachinescalesets.disk_read_operations_sec | Disk Read Operations/Sec |
| azure.compute_virtualmachinescalesets.disk_write_bytes | Disk Write Bytes |
| azure.compute_virtualmachinescalesets.disk_write_operations_sec | Disk Write Operations/Sec |
| azure.compute_virtualmachinescalesets.inbound_flows | Inbound Flows |
| azure.compute_virtualmachinescalesets.inbound_flows_maximum_creation_rate | Inbound Flows Maximum Creation Rate |
| azure.compute_virtualmachinescalesets.network_in_total | Network In Total |
| azure.compute_virtualmachinescalesets.network_out_total | Network Out Total |
| azure.compute_virtualmachinescalesets.os_disk_bandwidth_consumed_percentage | OS Disk Bandwidth Consumed Percentage |
| azure.compute_virtualmachinescalesets.os_disk_iops_consumed_percentage | OS Disk IOPS Consumed Percentage |
| azure.compute_virtualmachinescalesets.os_disk_latency | OS Disk Latency (Preview) |
| azure.compute_virtualmachinescalesets.os_disk_max_burst_bandwidth | OS Disk Max Burst Bandwidth |
| azure.compute_virtualmachinescalesets.os_disk_max_burst_iops | OS Disk Max Burst IOPS |
| azure.compute_virtualmachinescalesets.os_disk_queue_depth | OS Disk Queue Depth |
| azure.compute_virtualmachinescalesets.os_disk_read_bytes_sec | OS Disk Read Bytes/Sec |
| azure.compute_virtualmachinescalesets.os_disk_read_operations_sec | OS Disk Read Operations/Sec |
| azure.compute_virtualmachinescalesets.os_disk_target_bandwidth | OS Disk Target Bandwidth |
| azure.compute_virtualmachinescalesets.os_disk_target_iops | OS Disk Target IOPS |
| azure.compute_virtualmachinescalesets.os_disk_used_burst_bps_credits_percentage | OS Disk Used Burst BPS Credits Percentage |
| azure.compute_virtualmachinescalesets.os_disk_used_burst_io_credits_percentage | OS Disk Used Burst IO Credits Percentage |
| azure.compute_virtualmachinescalesets.os_disk_write_bytes_sec | OS Disk Write Bytes/Sec |
| azure.compute_virtualmachinescalesets.os_disk_write_operations_sec | OS Disk Write Operations/Sec |
| azure.compute_virtualmachinescalesets.outbound_flows | Outbound Flows |
| azure.compute_virtualmachinescalesets.outbound_flows_maximum_creation_rate | Outbound Flows Maximum Creation Rate |
| azure.compute_virtualmachinescalesets.percentage_cpu | Percentage CPU |
| azure.compute_virtualmachinescalesets.temp_disk_latency | Temp Disk Latency (Preview) |
| azure.compute_virtualmachinescalesets.temp_disk_queue_depth | Temp Disk Queue Depth |
| azure.compute_virtualmachinescalesets.temp_disk_read_bytes_sec | Temp Disk Read Bytes/Sec |
| azure.compute_virtualmachinescalesets.temp_disk_read_operations_sec | Temp Disk Read Operations/Sec |
| azure.compute_virtualmachinescalesets.temp_disk_write_bytes_sec | Temp Disk Write Bytes/Sec |
| azure.compute_virtualmachinescalesets.temp_disk_write_operations_sec | Temp Disk Write Operations/Sec |
| azure.compute_virtualmachinescalesets.vm_availability_metric | VM Availability Metric (Preview) |
| azure.compute_virtualmachinescalesets.vm_cached_bandwidth_consumedcentage | VM Cached Bandwidth Consumed Percentage |
| azure.compute_virtualmachinescalesets.vm_cached_iops_consumed_percentage | VM Cached IOPS Consumed Percentage |
| azure.compute_virtualmachinescalesets.vm_cached_used_burst_bps_credits_percentage | VM Cached Used Burst BPS Credits Percentage |
| azure.compute_virtualmachinescalesets.vm_cached_used_burst_io_credits_percentage | VM Cached Used Burst IO Credits Percentage |
| azure.compute_virtualmachinescalesets.vm_uncached_bandwidth_consumed_percentage | VM Uncached Bandwidth Consumed Percentage |
| azure.compute_virtualmachinescalesets.vm_uncached_iops_consumed_percentage | VM Uncached IOPS Consumed Percentage |
| azure.compute_virtualmachinescalesets.vm_uncached_used_burst_bps_credits_percentage | VM Uncached Used Burst BPS Credits Percentage |
| azure.compute_virtualmachinescalesets.vm_uncached_used_burst_io_credits_percentage | VM Uncached Used Burst IO Credits Percentage |
| Metrics Name | Description |
|---|---|
| azure.storage_storageaccounts_blobservices.availability | Availability |
| azure.storage_storageaccounts_blobservices.blob_capacity | Blob Capacity |
| azure.storage_storageaccounts_blobservices.blob_count | Blob Count |
| azure.storage_storageaccounts_blobservices.blob_provisioned_size | Blob Provisioned Size |
| azure.storage_storageaccounts_blobservices.container_count | Blob Container Count |
| azure.storage_storageaccounts_blobservices.egress | Egress |
| azure.storage_storageaccounts_blobservices.index_capacity | Index Capacity |
| azure.storage_storageaccounts_blobservices.ingress | Ingress |
| azure.storage_storageaccounts_blobservices.success_e2e_latency | Success E2E Latency |
| azure.storage_storageaccounts_blobservices.success_server_latency | Success Server Latency |
| azure.storage_storageaccounts_blobservices.transactions | Transactions |
Need assistance or want to learn more about Middleware? Contact our support team in Slack.