RDS for SQL Server standard monitoring metrics-ApsaraDB RDS(RDS)-阿里云帮助中心

Standard monitoring displays performance metrics for an ApsaraDB RDS for SQL Server instance in the ApsaraDB RDS console, so you can track resource usage and database performance over a selected time range or in real time.

New and legacy metric sets

ApsaraDB RDS for SQL Server has upgraded standard monitoring and integrated Performance Trend to provide additional monitoring capabilities.

Standard monitoring is available as two metric sets:

New monitoring metrics (recommended) — The default metric set on the current monitoring page. Metrics are grouped into Basic metrics and Advanced metrics, and each metric includes an OpenAPI Key that you can use to retrieve its data through the API.
Legacy monitoring metrics — The metric set of the previous monitoring page, grouped into Basic metrics and Database metrics. Use this set only if your console still displays the previous monitoring page.
The following table lists the categories of the new monitoring metrics:

Category	Metrics
Basic metrics	Instance Storage, Instance Disk Usage, BufferHit, CPU/Memory Utilization, Network Traffic, Abnormal Items, Connections, Transactions, AlwaysOn Availability Group Performance, SQL Compilation Rate, IOPS Utilization, Lock Timeouts, Mirroring Synchronization Performance, Page Life Expectancy, Blocking, Full Table Scan Rate, Throughput Utilization, IOPS, QPS, Checkpoint Pages Written, Deadlocks, Page Performance, Throughput, Logons, Serverless RCU
Advanced metrics	Index Usage, Connections, Cache, Advanced Memory Usage, Backup Performance, Memory Usage, AlwaysOn Availability Group Performance, SQL Compilation Rate, Mirroring Synchronization Performance, Log Growth, Version Store Rate, Log Performance, Lock Wait Times, Page Performance

View standard monitoring

Log on to the ApsaraDB RDS console. In the top navigation bar, select the region where your instance resides, then click the instance ID.
In the left-side navigation pane, click Monitoring and Alerts.
On the Standard Monitoring page, the Basic metrics and Advanced metrics monitoring charts are displayed. You can perform the following operations:
- Query metrics for a specific time range — Select the time range that you want to query to view the corresponding metrics. You can query only monitoring data from the last 30 days.
- Enable real-time mode — Click before the time range box to enable real-time mode. The system refreshes the metrics every 5 seconds so that you can track live changes in database performance.
- Change the monitoring frequency — Set Data Granularity to view metric trends at a different time granularity: 5 seconds, 30 seconds, or 1 minute.
- View metric descriptions — In a metric trend chart, click next to a monitoring item to view the metrics that it contains and what they mean.
- Switch the monitoring perspective — In the Monitoring Perspective section, select DAS Standard Perspective - SQLServer New Metric Dashboard (recommended) or DAS Standard Perspective - SQLServer Metric Dashboard.
- Switch nodes — For an ApsaraDB RDS for SQL Server instance of the Cluster Edition, you can select a different node to view, or select multiple nodes at the same time to compare metrics.
Note
If the page does not display Basic metrics and Advanced metrics, you might be on the previous monitoring page. Click Back to New Version in the upper-right corner.

New monitoring metrics

The following tables list the metrics on the current monitoring page, grouped into Basic metrics and Advanced metrics. When several metrics belong to the same monitoring chart, the OpenAPI Key appears only in the first row of the group and is shared by all metrics in that group.

Basic metrics

Standard monitoring chart name	Standard monitoring metric name	Description	Unit	OpenAPI Key	OpenAPI returned metric name
Instance Storage	`ins_size`	Total space used by the instance.	MB	`SQLServer_DetailedSpaceUsage`	`ins_size`
	`log_size`	Log space used.	MB		`log_size`
	`data_size`	Data space used.	MB		`data_size`
	`other_size`	System space used.	MB		`other_size`
	`tmp_size`	Temporary space used.	MB		`tmp_size`
	`disk_xel`	Disk space used by Extended Event log files.	MB		`disk_xel`
	`disk_trace`	Disk space used to store SQL Server trace files, such as SQL Profiler trace files.	MB		`disk_trace`
	`disk_dump`	Space used by dump files that are generated when the SQL Server kernel encounters an exception.	MB		`disk_dump`
	`disk_mastersize`	Disk space used to store the SQL Server system database master.	MB		`disk_mastersize`
	`disk_modelsize`	Disk space used to store the model database. The model database is the template for each new database.	MB		`disk_modelsize`
	`disk_msdbsize`	Disk space used to store the msdb database. The msdb database manages SQL Server Agent jobs and backup history.	MB		`disk_msdbsize`
	`disk_errorlog`	Disk space used by error log files. You can clear the error logs of an instance from the console or by calling an API operation.	MB		`disk_errorlog`
Instance Disk Usage	`disk_usage`	Space usage.	%	`SQLServer_InstanceDiskUsage`	`InstanceDiskUsage`
BufferHit	`cache_hit_ratio`	Cache hit ratio.	%	`SQLServer_BufferHit`	`Cache_Hit_Ratio`
BufferHit	`bufferpool_hit_ratio`	Percentage of pages found in the buffer cache without a read from disk.	%	`SQLServer_BufferHit`	`sqlserver_bufferpool`
CPU/Memory Utilization	`mem_usage`	Instance memory usage.	%	`SQLServer_InstanceMemUsage`	`sqlserver_insmem`
CPU/Memory Utilization	`cpu_usage`	Instance CPU usage as a percentage of total operating system CPU.	%	`SQLServer_InstanceCPUUsage`	`sqlserver_inscpu`
Network Traffic	`input_traffic`	Average number of bytes received from all clients per second.	KB	`SQLServer_NetworkTraffic`	`read_kb`
Network Traffic	`output_traffic`	Average number of bytes sent to all clients per second.	KB	`SQLServer_NetworkTraffic`	`write_kb`
Abnormal Items	`alarm_abnormal_db`	Number of databases with an abnormal mirroring configuration or a failed mirroring synchronization.	Count	`SQLServer_Alarm`	`alarm_abnormal_db`
Connections	`active_session`	Number of active threads.	Count	`SQLServer_Sessions`	`sqlserver_activesession`
Transactions	`transactions`	Average transactions per second.	Count/S	`SQLServer_Transactions`	`sqlserver_transactions`
Transactions	`write_transactions`	Average write transactions per second.	Count/S	`SQLServer_Transactions`	`sqlserver_write_transactions`
AlwaysOn Availability Group Performance	`sqlserver_alwayson_lagsecs`	SQL Server AlwaysOn replication lag.	S	`SQLServer_AGPerf`	`sqlserver_alwayson_lagsecs`
	`sqlserver_alwayson_redoqueuesize_kb`	Size of the log queue waiting to be redone on the replica, in KB.	KB		`sqlserver_alwayson_redoqueuesize_kb`
	`sqlserver_alwayson_sendqueuesize_kb`	Size of the log queue on the primary replica waiting to be sent to the replica, in KB.	KB		`sqlserver_alwayson_sendqueuesize_kb`
	`ag_unhealthydb_count`	Number of unhealthy databases in the availability group.	Count		`ag_unhealthydb_count`
	`ag_db_not_in_ag_count`	Number of databases that are not in the availability group.	Count		`ag_db_not_in_ag_count`
SQL Compilation Rate	`sql_compilations`	SQL compilations per second.	Count/S	`SQLServer_SQLCompilations`	`sqlserver_sqlcompilations`
SQL Compilation Rate	`resqlcompilations`	Statement recompilations per second.	Count/S	`SQLServer_SQLCompilations`	`sqlserver_resqlcompilations`
IOPS Utilization	`iops_usage_burst`	Actual IOPS usage.	%	`SQLServer_InstanceIOPSUsage`	`InstanceIOPSUsageBurst`
	`iops_usage_no_burst`	IOPS usage when I/O burst is disabled.	%		`InstanceIOPSUsageNoBurst`
	`iops_usage_burst_ratio`	Percentage of IOPS improvement after I/O burst is enabled.	%		`InstanceIOPSBurstRatio`
Lock Timeouts	`locktimeout`	Lock requests that timed out per second, including NOWAIT lock requests.	Count/S	`SQLServer_LockTimeout`	`sqlserver_locktimeout`
Mirroring Synchronization Performance (high-availability series only)	`sqlserver_log_send_queue`	Number of log bytes on the primary replica waiting to be sent to the replica.	KB	`SQLServer_MirrorPerf`	`sqlserver_log_send_queue`
	`sqlserver_redo_queue`	Number of log bytes waiting to be redone on the replica.	KB	`SQLServer_MirrorPerf`	`sqlserver_redo_queue`
Page Life Expectancy	`Page_life_expectancy`	Average time a cached data page stays in memory.	S	`SQLServer_PageLife`	`sqlserver_pagelife`
Blocking	`Wait_for_the_worker`	Length of the worker threads wait queue.	Count	`SQLServer_Block`	`Wait_for_the_worker`
	`uncommited_tran`	Number of uncommitted transactions.	Count		`uncommited_tran`
	`Longest_Transaction_Running_Time`	Duration of the longest-running transaction.	S		`Longest_Transaction_Running_Time`
	`Processes_blocked`	Number of blocked processes.	Count		`Processes_blocked`
Full Table Scan Rate	`fullscans`	Average full table scans per second.	Count/S	`SQLServer_FullScans`	`sqlserver_fullscans`
Throughput Utilization	`mBps_usage_no_burst`	Disk I/O throughput usage when I/O burst is disabled.	%	`SQLServer_InstanceMBPSUsage`	`mBps_usage_no_burst`
	`mBps_usage_burst`	Actual disk I/O throughput usage.	%		`mBps_usage_burst`
	`mBps_burst_ratio`	Percentage of disk I/O throughput improvement after I/O burst is enabled.	%		`mBps_burst_ratio`
IOPS	`db_io_read`	Read I/O requests per second.	Count/S	`SQLServer_IOPS`	`db_io_read`
	`db_io`	Total I/O requests per second.	Count/S		`db_io`
	`db_io_write`	Write I/O requests per second.	Count/S		`db_io_write`
	`iops_of_ecs`	Upper IOPS limit on the computing side.	Count/S		`iops_of_ecs`
	`iops_of_disk`	Upper IOPS limit on the storage side.	Count/S		`iops_of_disk`
	`iops_no_burst`	Upper IOPS limit when I/O burst is disabled.	Count/S		`iops_no_burst`
	`iops_burst`	Upper IOPS limit.	Count/S		`iops_burst`
QPS	`qps`	Average number of SQL statement executions per second.	Count/S	`SQLServer_QPS`	`sqlserver_qps`
Checkpoint Pages Written	`lazy_writes`	Writes to disk per second.	Count/S	`SQLServer_CheckPoint`	`sqlserver_lazy_writes`
Checkpoint Pages Written	`checkpoint`	Pages written to disk by checkpoints per second.	Count/S	`SQLServer_CheckPoint`	`sqlserver_checkpoint`
Deadlocks	`deadlock`	Deadlocks per second.	Count/S	`SQLServer_Deadlock`	`sqlserver_deadlock`
Page Performance	`sqlserver_pagereads`	Data pages read from disk per second (physical I/O).	Count/S	`SQLServer_PagePerf`	`sqlserver_pagereads`
Page Performance	`sqlserver_pagewrites`	Data pages written to disk per second (physical I/O).	Count/S	`SQLServer_PagePerf`	`sqlserver_pagewrites`
Throughput	`mBps_total`	Total disk I/O throughput per second.	MB/S	`SQLServer_MBPS`	`mBps_total`
	`mBps_read`	Disk read I/O throughput per second.	MB/S		`mBps_read`
	`mBps_write`	Disk write I/O throughput per second.	MB/S		`mBps_write`
	`mBps_of_ecs`	Upper disk I/O throughput limit per second on the computing side.	MB/S		`mBps_of_ecs`
	`mBps_of_disk`	Upper disk I/O throughput limit per second on the storage side.	MB/S		`mBps_of_disk`
	`mBps_no_burst`	Upper disk I/O throughput limit per second when I/O burst is disabled.	MB/S		`mBps_no_burst`
	`mBps_burst`	Upper disk I/O throughput limit per second.	MB/S		`mBps_burst`
Logons	`logins`	Logons per second.	Count/S	`SQLServer_Logins`	`sqlserver_logins`
Logons	`logout`	Logouts per second.	Count/S	`SQLServer_Logins`	`sqlserver_logout`
Serverless RCU (serverless instances only)	`rcu`	RDS Capacity Unit.	Count	`SQLServer_RCU`	`rcu`

Advanced metrics

Standard monitoring chart name	Standard monitoring metric name	Description	Unit	OpenAPI Key	OpenAPI returned metric name
Index Usage	`Index_Searches_per_sec`	Index searches per second.	Count/S	`SQLServer_IndexUsage`	`Index_Searches_per_sec`
Index Usage	`Forwarded_Records_per_sec`	Forwarded records accessed per second.	Count/S	`SQLServer_IndexUsage`	`Forwarded_Records_per_sec`
Connections	`active_temp_tables`	Number of active temporary tables.	Count	`SQLServer_Sessions`	`Active_Temp_Tables`
	`active_transactions`	Number of active transactions.	Count		`Active_Transactions`
	`active_cursors`	Number of active cursors.	Count		`Active_cursors`
	`connection_reset`	Logons initiated from the connection pool per second.	Count/S		`sqlserver_connectionreset`
	`user_connections`	Total number of connections.	Count		`sqlserver_sessions`
Cache	`Cache_Object_Counts`	Total number of objects in the cache.	Count	`SQLServer_Cache`	`Cache_Object_Counts`
	`Cache_Objects_in_use`	Number of cache objects currently in use.	Count		`Cache_Objects_in_use`
	`Cache_Pages`	Number of pages used by the cache.	Count		`Cache_Pages`
Advanced Memory Usage	`CACHESTORE_SQLCP_KB`	Memory used by the SQL compiled plan cache, in KB.	KB	`SQLServer_AdvancedMemUsage`	`CACHESTORE_SQLCP_KB`
	`CACHESTORE_PHDR_KB`	Memory used by the physical driver cache, in KB.	KB		`CACHESTORE_PHDR_KB`
	`CACHESTORE_OBJCP_KB`	Memory used by the object compiled plan cache, in KB.	KB		`CACHESTORE_OBJCP_KB`
	`MEMORYCLERK_SOSNODE_KB`	Memory allocated to operating system nodes, in KB.	KB		`MEMORYCLERK_SOSNODE_KB`
	`MEMORYCLERK_SQLCLR_KB`	Memory used by the common language runtime (CLR), in KB.	KB		`MEMORYCLERK_SQLCLR_KB`
	`MEMORYCLERK_SQLSTORENG_KB`	Memory used by the SQL storage engine, in KB.	KB		`MEMORYCLERK_SQLSTORENG_KB`
	`USERSTORE_SCHEMAMGR_KB`	Memory used by the user schema manager, in KB.	KB		`USERSTORE_SCHEMAMGR_KB`
	`MEMORYCLERK_SOSMEMMANAGER`	Memory used by the operating system memory manager, in KB.	KB		`MEMORYCLERK_SOSMEMMANAGER`
	`CACHESTORE_SQLCP_VMCommitted_KB`	Virtual memory used by the plan cache for SQL plans.	KB		`CACHESTORE_SQLCP_VMCommitted_KB`
	`CACHESTORE_PHDR_VMCommitted_KB`	Virtual memory used by the temporary memory cache for algebrizer trees.	KB		`CACHESTORE_PHDR_VMCommitted_KB`
	`CACHESTORE_OBJCP_VMCommitted_KB`	Virtual memory used by the plan cache for object plans.	KB		`CACHESTORE_OBJCP_VMCommitted_KB`
	`MEMORYCLERK_SOSNODE_VMCommitted_KB`	Virtual memory used by SOSNODE, a component of SQLOS.	KB		`MEMORYCLERK_SOSNODE_VMCommitted_KB`
	`MEMORYCLERK_SQLCLR_VMCommitted_KB`	Virtual memory used by SQLCLR.	KB		`MEMORYCLERK_SQLCLR_VMCommitted_KB`
	`MEMORYCLERK_SQLSTORENG_VMCommitted_KB`	Virtual memory used by storage engine components.	KB		`MEMORYCLERK_SQLSTORENG_VMCommitted_KB`
	`USERSTORE_SCHEMAMGR_VMCommitted_KB`	Virtual memory used by different types of metadata for database objects.	KB		`USERSTORE_SCHEMAMGR_VMCommitted_KB`
	`MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB`	Virtual memory used by SOSMEMMANAGER, a component of SQLOS.	KB		`MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB`
Backup Performance	`Backup_per_Restore_Throughput_per_sec`	Bytes processed per second by backup or restore operations (throughput).	Count/S	`SQLServer_BackupPerf`	`Backup_per_Restore_Throughput_per_sec`
Memory Usage	`Lock_Memory`	Memory used by lock structures, in KB.	KB	`SQLServer_MemUsage`	`Lock_Memory_KB`
	`Connection_Memory`	Memory used by connections, in KB.	KB		`Connection_Memory_KB`
	`Database_Cache_Memory`	Memory used by the database buffer pool, in KB.	KB		`Database_Cache_Memory_KB`
	`Free_Memory`	Available memory, in KB.	KB		`Free_Memory_KB`
	`Optimizer_Memory`	Memory used by the query optimizer, in KB.	KB		`Optimizer_Memory_KB`
	`Total_Server_Memory`	Total memory currently used by SQL Server, in KB.	KB		`Total_Server_Memory_KB`
	`SQL_Cache_Memory`	Memory used by the SQL plan cache, in KB.	KB		`SQL_Cache_Memory_KB`
	`Stolen_Server_Memory`	Memory used for other purposes, in KB.	KB		`Stolen_Server_Memory_KB`
AlwaysOn Availability Group Performance	`Bytes_Received_from_Replica_per_sec`	Bytes received from the replica per second.	B/S	`SQLServer_AGPerf`	`Bytes_Received_from_Replica_per_sec`
	`ag_redo_finish_time`	Timestamp at which the replica finished the redo operation.	S		`ag_redo_finish_time`
	`Bytes_Sent_to_Replica_per_sec`	Bytes sent to the replica per second.	B/S		`Bytes_Sent_to_Replica_per_sec`
	`Flow_Control_Time_ms_per_sec`	Flow control duration per second, in milliseconds.	MS/S		`Flow_Control_Time_ms_per_sec`
	`Flow_Control_per_sec`	Flow control events triggered per second.	Count/S		`Flow_Control_per_sec`
SQL Compilation Rate	`safe_autoparams_per_sec`	Safe auto-parameterization attempts per second.	Count/S	`SQLServer_SQLCompilations`	`Safe_AutoParams_per_sec`
	`failed_autoparams_per_sec`	Failed auto-parameterization attempts per second.	Count/S		`Failed_AutoParams_per_sec`
	`forced_parameterizations_per_sec`	Successful forced parameterizations per second.	Count/S		`Forced_Parameterizations_per_sec`
	`unsafe_autoparams_per_sec`	Unsafe auto-parameterization attempts per second.	Count/S		`Unsafe_AutoParams_per_sec`
	`autoparam_attempts_per_sec`	Auto-parameterization attempts per second.	Count/S		`AutoParam_Attempts_per_sec`
Mirroring Synchronization Performance (high-availability series only)	`Redo_Bytes_Remaining`	Number of log bytes that the replica still needs to redo.	B	`SQLServer_MirrorPerf`	`Redo_Bytes_Remaining`
	`Redone_Bytes_per_sec`	Number of log bytes redone by the replica per second.	B/S	`SQLServer_MirrorPerf`	`Redone_Bytes_per_sec`
Log Growth	`Log_Shrinks`	Number of transaction log shrinks.	Count	`SQLServer_LogGrowth`	`Log_Shrinks`
	`Log_Truncations`	Number of transaction log truncations.	Count		`Log_Truncations`
	`Log_Growths`	Number of automatic transaction log growths.	Count		`Log_Growths`
Version Store Rate	`Version_Cleanup_rate_KB_per_s`	Size of the row version store cleaned up per second, in KB.	KB/S	`SQLServer_OptimizeConcurrent`	`Version_Cleanup_rate_KB_per_s`
Version Store Rate	`Version_Generation_rate_KB_per_s`	Size of the row version store generated per second, in KB.	KB/S	`SQLServer_OptimizeConcurrent`	`Version_Generation_rate_KB_per_s`
Log Performance	`Log_Bytes_Flushed_per_sec`	Log bytes written to disk per second (physical transaction log writes).	B/S	`SQLServer_LogPerf`	`Log_Bytes_Flushed_per_sec`
	`Log_Bytes_Received_per_sec`	Log bytes received per second (transaction log generation rate).	B/S		`Log_Bytes_Received_per_sec`
	`Log_Cache_Reads_per_sec`	Reads from the log cache per second, which do not require a read from disk.	Count/S		`Log_Cache_Reads_per_sec`
	`Log_buffer_waits`	Number of waits for the log buffer. A high value indicates heavy log buffer contention. Increase the log buffer size or optimize transactions.	B		`Log_buffer_waits`
	`Log_Flushes_per_sec`	Log flushes to disk per second. A high value indicates frequent transactions. Consider optimizing batch operations.	Count/S		`Log_Flushes_per_sec`
	`Log_Pool_Requests_per_sec`	Log buffer requests per second. Use this metric to monitor log buffer pressure.	Count/S		`Log_Pool_Requests_per_sec`
Lock Wait Times	`lock_requests_per_sec`	Total lock requests received by SQL Server per second.	Count/S	`SQLServer_LockWaits`	`Lock_Requests_per_sec`
	`lock_wait_time_ms`	Average lock wait time.	MS		`Lock_Wait_Time_ms`
	`lock_waits_per_sec`	Lock requests per second for which the caller waited.	Count/S		`sqlserver_lockwaits`
	`table_lock_escalations_per_sec`	Times per second that locks on a table were escalated to the TABLE or HoBT granularity.	Count/S		`Table_Lock_Escalations_per_sec`
	`average_latch_wait_time`	Average wait time for latch requests.	MS		`Average_Latch_Wait_Time`
	`average_lock_wait_time`	Average wait time for lock requests.	MS		`Average_Lock_Wait_Time`
	`total_latch_wait_time_ms`	Total lock wait time in the last second.	MS		`Total_Latch_Wait_Time_ms`
	`latchwaits`	Latch requests not granted immediately per second.	Count/S		`sqlserver_latchwaits`
	`lock_waits`	Statistics about processes waiting for a lock.	Count		`Lock_waits`
Page Performance	`Page_lookups_per_sec`	Number of buffer pool page lookups per second.	Count/S	`SQLServer_PagePerf`	`Page_lookups_per_sec`
	`Pages_compressed_per_sec`	Data pages compressed per second.	Count/S		`Pages_compressed_per_sec`
	`Page_IO_latch_waits`	Number of waits to acquire a page I/O latch.	Count		`Page_IO_latch_waits`
	`sqlserver_pagesplits`	Page splits per second.	Count/S		`sqlserver_pagesplits`
	`Readahead_pages_per_sec`	Pages read ahead per second.	Count/S		`Readahead_pages_per_sec`
	`Background_writer_pages_per_sec`	Pages written to disk per second by the background writer process.	Count/S		`Background_writer_pages_per_sec`
	`Page_latch_waits`	Total number of waits to acquire a page latch.	Count		`Page_latch_waits`

Legacy monitoring metrics

The following tables list the metrics on the previous monitoring page, grouped into Basic metrics and Database metrics. Use this set only if your console still displays the previous monitoring page.

Basic metrics

Monitoring item	Metric name	Unit	Description
CPU/Memory Utilization	`cpu_usage`	%	Instance CPU usage as a percentage of total operating system CPU.
CPU/Memory Utilization	`mem_usage`	%	Instance memory usage.
IOPS Utilization	`iops_usage_no_burst`	%	IOPS usage when I/O burst is disabled.
	`iops_usage_burst`	%	Actual IOPS usage.
	`iops_usage_burst_ratio`	%	Percentage of IOPS improvement after I/O burst is enabled.
IOPS	`db_io_read`	Count	Read I/O requests per second.
	`db_io`	Count	Total I/O requests per second.
	`db_io_write`	Count	Write I/O requests per second.
	`iops_of_ecs`	Count	Upper IOPS limit on the computing side.
	`iops_of_disk`	Count	Upper IOPS limit on the storage side.
	`iops_no_burst`	Count	Upper IOPS limit when I/O burst is disabled.
	`iops_burst`	Count	Upper IOPS limit.
Instance Storage	`disk_mastersize`	MB	Disk space used to store the SQL Server system database master.
	`disk_modelsize`	MB	Disk space used to store the model database. The model database is the template for each new database.
	`disk_msdbsize`	MB	Disk space used to store the msdb database. The msdb database manages SQL Server Agent jobs and backup history.
	`disk_errorlog`	MB	Disk space used by error log files. You can clear the error logs of an instance from the console or by calling an API operation.
	`disk_xel`	MB	Disk space used by Extended Event log files.
	`disk_trace`	MB	Disk space used to store SQL Server trace files, such as SQL Profiler trace files.
	`disk_dump`	MB	Space used by dump files that are generated when the SQL Server kernel encounters an exception.
	`log_size`	MB	Log space used.
	`ins_size`	MB	Total space used by the instance.
	`tmp_size`	MB	Temporary space used.
	`data_size`	MB	Data space used.
	`other_size`	MB	System space used.
Instance Disk Usage	`disk_usage`	%	Space usage.
Network Traffic	`write_kb`(`output_traffic`)	KB	Average number of bytes sent to all clients per second.
Network Traffic	`read_kb`(`input_traffic`)	KB	Average number of bytes received from all clients per second.
Throughput Utilization	`mBps_usage_burst`	%	Actual disk I/O throughput usage.
	`mBps_usage_no_burst`	%	Disk I/O throughput usage when I/O burst is disabled.
	`mBps_burst_ratio`	%	Percentage of disk I/O throughput improvement after I/O burst is enabled.
Throughput	`mBps_total`	MB/s	Total disk I/O throughput per second.
	`mBps_read`	MB/s	Disk read I/O throughput per second.
	`mBps_write`	MB/s	Disk write I/O throughput per second.
	`mBps_of_ecs`	MB/s	Upper disk I/O throughput limit per second on the computing side.
	`mBps_of_disk`	MB/s	Upper disk I/O throughput limit per second on the storage side.
	`mBps_no_burst`	MB/s	Upper disk I/O throughput limit per second when I/O burst is disabled.
	`mBps_burst`	MB/s	Upper disk I/O throughput limit per second.

Database metrics

Monitoring item	Metric name	Unit	Description
QPS	`qps`	Count	Average number of SQL statement executions per second.
Connections	`connection_reset`	Count	Logons initiated from the connection pool per second.
	`active_temp_tables`	Count	Number of active temporary tables.
	`active_session`	Count	Number of active threads.
	`active_cursors`	Count	Number of active cursors.
	`sessions`	Count	Total number of connections.
	`active_transactions`	Count	Number of active transactions.
Transactions	`transactions`	Count	Average transactions per second.
Transactions	`write_transactions`	Count	Average write transactions per second.
BufferHit	`cache_hit_ratio`	%	Cache hit ratio.
BufferHit	`bufferpool_hit_ratio`	%	Percentage of pages found in the buffer cache without a read from disk.
Full Table Scan Rate	`fullscans`	Count/S	Average full table scans per second.
SQL Compilation Rate	`autoparam_attempts_per_sec`	Count	Auto-parameterization attempts per second.
	`forced_parameterizations_per_sec`	Count	Successful forced parameterizations per second.
	`sql_compilations`	Count	SQL compilations per second.
	`unsafe_autoparams_per_sec`	Count	Unsafe auto-parameterization attempts per second.
	`failed_autoparams_per_sec`	Count	Failed auto-parameterization attempts per second.
	`safe_autoparams_per_sec`	Count	Safe auto-parameterization attempts per second.
	`resqlcompilations`	Count	Statement recompilations per second.
Checkpoint Pages Written	`lazy_writes`	Count	Writes to disk per second.
Checkpoint Pages Written	`checkpoint`	Count	Pages written to disk by checkpoints per second.
Logons	`logout`	Count	Logouts per second.
Logons	`logins`	Count	Logons per second.
Lock Timeouts	`locktimeout`	Count	Lock requests that timed out per second, including NOWAIT lock requests.
Deadlocks	`deadlock`	Count	Deadlocks per second.
Lock Wait Times	`average_latch_wait_time`	ms	Average wait time for latch requests.
	`table_lock_escalations_per_sec`	Count	Times per second that locks on a table were escalated to the TABLE or HoBT granularity.
	`average_lock_wait_time`	ms	Average wait time for lock requests.
	`total_latch_wait_time_ms`	ms	Total lock wait time in the last second.
	`lock_requests_per_sec`	Count	New locks and lock conversions requested per second.
	`lockwaits`	Count	Lock requests per second for which the caller waited.
	`latchwaits`	Count	Latch requests not granted immediately per second.
	`lock_waits`	Count	Statistics about processes waiting for a lock.
	`lock_wait_time_ms`	ms	Average lock wait time.
SQL Server AlwaysOn Replication Lag	`ag_sync_lag_secs`	s	Displayed only for the Cluster Edition. SQL Server AlwaysOn replication lag.
Page Life Expectancy	`Page_life_expectancy`	s	Average time a cached data page stays in memory.