Use the DescribeDBInstancePerformance operation to query instance performance data. When you call this operation, specify the time range (StartTime and EndTime), the instance (DBInstanceId), and the performance metric (Key). The supported values for Key and the structure of the return values vary by database type:
MySQL and MariaDB
RDS for MySQL and RDS for MariaDB share the same performance parameter names.
|
|
Description |
|
MySQL_NetworkTraffic |
The average rate of inbound and outbound traffic for the instance. Unit: KB/s. |
|
MySQL_QPSTPS |
The average number of SQL statements executed and transactions per second. Unit: count/s. |
|
MySQL_Sessions |
The number of active and total connections. Unit: count. |
|
MySQL_InnoDBBufferRatio |
The read hit rate, utilization, and dirty block percentage in the InnoDB buffer pool. Unit: %. |
|
MySQL_InnoDBDataReadWriten |
The average amount of data read from and written to InnoDB per second. Unit: KB. |
|
MySQL_InnoDBLogRequests |
The average number of reads from and writes to the InnoDB buffer pool per second. Unit: count/s. |
|
MySQL_InnoDBLogWrites |
The average number of log write requests, physical writes to the log file, and completed |
|
MySQL_TempDiskTableCreates |
The number of on-disk temporary tables created during statement execution. Unit: count. |
|
MySQL_MyISAMKeyBufferRatio |
The average utilization, read hit rate, and write hit rate of the MyISAM key buffer. Unit: %. |
|
MySQL_MyISAMKeyReadWrites |
For MyISAM, the average number of buffer reads, buffer writes, disk reads, and disk writes per second. Unit: count/s. |
|
MySQL_COMDML |
The average number of executions per second for the following statements: DELETE, INSERT, INSERT_SELECT, REPLACE, REPLACE_SELECT, SELECT, and UPDATE. Unit: count/s. |
|
MySQL_RowDML |
The average number of rows read, updated, deleted, and inserted per second in InnoDB tables, and the average number of physical writes to the log file per second. Unit: rows/s or count/s. |
|
MySQL_MemCpuUsage (For non-Serverless instances) |
The CPU and memory utilization of a non-Serverless instance, expressed as a percentage of total operating system resources. Unit: %. |
|
MySQL_RCU_MemCpuUsage (For Serverless instances) |
The CPU and memory utilization of a Serverless instance, expressed as a percentage of total operating system resources. Unit: %. |
|
MySQL_IOPS |
The IOPS of the instance. Unit: count/s. |
|
MySQL_DetailedSpaceUsage |
The total, data, log, temporary, and system space usage of the instance. Unit: MB. |
|
slavestat |
The replication delay of the read-only instance. Unit: seconds. |
|
MySQL_ThreadStatus |
The number of active threads and connected threads. Unit: count. |
|
MySQL_ReplicationDelay |
The replication delay of the replica instance. Unit: seconds. |
|
MySQL_ReplicationThread |
The status of the I/O replication thread and the SQL replication thread. A status of 1 indicates normal, while 0 indicates a missing thread. |
|
MySQL_ROW_LOCK |
The maximum wait time (ms), average wait time (ms), and number of waits (count) for a row lock. |
|
MySQL_SelectScan |
The number of full table scans performed by the instance. Unit: count. |
|
MySQL_MBPS |
The read and write throughput of the instance. Unit: B/s. |
SQL Server
Multiple metrics for a single key are separated by &.
Basic metrics
Chart name | Metric name | Description | Unit | OpenAPI key | OpenAPI metric name |
Instance space | ins_size | The total storage space that the instance occupies. | MB | SQLServer_DetailedSpaceUsage | ins_size |
log_size | The total space that logs occupy. | MB | log_size | ||
data_size | The total space that data occupies. | MB | data_size | ||
other_size | The amount of system space used. | MB | other_size | ||
tmp_size | The amount of temporary space used. | MB | tmp_size | ||
disk_xel | The disk space occupied by Extended Events log files. | MB | disk_xel | ||
disk_trace | The disk space used to store SQL Server trace files, such as SQL Profiler trace files. | MB | disk_trace | ||
disk_dump | The space used by dump files, which the SQL Server engine generates when it encounters an exception. | MB | disk_dump | ||
disk_mastersize | The disk space used to store the SQL Server master system database. | MB | disk_mastersize | ||
disk_modelsize | The disk space used for the model database, which serves as a template for all new databases. | MB | disk_modelsize | ||
disk_msdbsize | The disk space used for the msdb database, which manages SQL Server Agent jobs, backup history, and more. | MB | disk_msdbsize | ||
disk_errorlog | The disk space used by error log files. You can clear the instance's error logs from the console or by calling an API. | MB | disk_errorlog | ||
Instance disk utilization | disk_usage | The instance's disk utilization. | % | SQLServer_InstanceDiskUsage | InstanceDiskUsage |
Cache hit ratio | cache_hit_ratio | The percentage of page requests that are served from the buffer cache. | % | SQLServer_BufferHit | Cache_Hit_Ratio |
bufferpool_hit_ratio | The percentage of pages found in the buffer cache without requiring a read from disk. | % | sqlserver_bufferpool | ||
CPU/Memory utilization | mem_usage | The instance's memory utilization. | % | SQLServer_InstanceMemUsage | sqlserver_insmem |
cpu_usage | The instance's CPU utilization, as a percentage of the total available from the operating system. | % | SQLServer_InstanceCPUUsage | sqlserver_inscpu | |
Network traffic | input_traffic | The average number of kilobytes received from all clients per second. | KB | SQLServer_NetworkTraffic | read_kb |
output_traffic | The average number of kilobytes sent to all clients per second. | KB | write_kb | ||
Alarms | alarm_abnormal_db | The number of databases with abnormal database mirroring configurations or failed mirroring synchronization. | Count | SQLServer_Alarm | alarm_abnormal_db |
Active sessions | active_session | The current number of active sessions. | Count | SQLServer_Sessions | sqlserver_activesession |
Transactions | transactions | The average number of transactions per second. | Count/s | SQLServer_Transactions | sqlserver_transactions |
write_transactions | The average number of write transactions per second. | Count/s | sqlserver_write_transactions | ||
AlwaysOn Availability Group performance | sqlserver_alwayson_lagsecs | The replication lag between the primary replica and a secondary replica. | s | SQLServer_AGPerf | sqlserver_alwayson_lagsecs |
sqlserver_alwayson_redoqueuesize_kb | The size of a secondary replica's redo queue, which holds log records waiting to be redone. | KB | sqlserver_alwayson_redoqueuesize_kb | ||
sqlserver_alwayson_sendqueuesize_kb | The size of the primary replica's send queue, which holds log records waiting to be sent to a secondary replica. | KB | sqlserver_alwayson_sendqueuesize_kb | ||
ag_unhealthydb_count | The number of unhealthy databases in the Availability Group. | Count | ag_unhealthydb_count | ||
ag_db_not_in_ag_count | The number of databases that are not in an Availability Group. | Count | ag_db_not_in_ag_count | ||
SQL compilation rate | sql_compilations | The number of SQL compilations per second. | Count/s | SQLServer_SQLCompilations | sqlserver_sqlcompilations |
resqlcompilations | The number of statement recompilations per second. | Count/s | sqlserver_resqlcompilations | ||
IOPS utilization | iops_usage_burst | The actual IOPS utilization. | % | SQLServer_InstanceIOPSUsage | InstanceIOPSUsageBurst |
iops_usage_no_burst | The IOPS utilization, assuming I/O bursting is disabled for the instance. | % | InstanceIOPSUsageNoBurst | ||
iops_usage_burst_ratio | The percentage increase in IOPS due to I/O bursting. | % | InstanceIOPSBurstRatio | ||
Lock timeouts | locktimeout | The number of lock requests that time out per second, including requests for | Count/s | SQLServer_LockTimeout | sqlserver_locktimeout |
Mirroring sync performance (high availability series only) | sqlserver_log_send_queue | The amount of log data (in KB) in the primary replica's send queue waiting to be sent to the secondary replica. | KB | SQLServer_MirrorPerf | sqlserver_log_send_queue |
sqlserver_redo_queue | The amount of log data (in KB) in the secondary replica's redo queue waiting to be redone. | KB | sqlserver_redo_queue | ||
Page life expectancy | Page_life_expectancy | The average time, in seconds, a data page remains in the buffer cache. | s | SQLServer_PageLife | sqlserver_pagelife |
Blocking | Wait_for_the_worker | The number of threads in the worker wait queue. | Count | SQLServer_Block | Wait_for_the_worker |
uncommited_tran | The number of uncommitted transactions. | Count | uncommited_tran | ||
Longest_Transaction_Running_Time | The duration of the longest-running transaction. | s | Longest_Transaction_Running_Time | ||
Processes_blocked | The number of blocked processes. | Count | Processes_blocked | ||
Full table scan rate | fullscans | The average number of full table scans per second. | Count/s | SQLServer_FullScans | sqlserver_fullscans |
MBps utilization | MBps_usage_no_burst | The disk I/O throughput utilization, assuming I/O bursting is disabled for the instance. | % | SQLServer_InstanceMBPSUsage | MBps_usage_no_burst |
MBps_usage_burst | The actual disk I/O throughput utilization. | % | MBps_usage_burst | ||
MBps_burst_ratio | The percentage increase in disk I/O throughput due to I/O bursting. | % | MBps_burst_ratio | ||
IOPS | db_io_read | The number of read I/O requests per second. | Count/s | SQLServer_IOPS | db_io_read |
db_io | The number of I/O requests per second. | Count/s | db_io | ||
db_io_write | The number of write I/O requests per second. | Count/s | db_io_write | ||
iops_of_ecs | The maximum IOPS allowed by the instance's compute resources. | Count/s | iops_of_ecs | ||
iops_of_disk | The maximum IOPS allowed by the instance's storage resources. | Count/s | iops_of_disk | ||
iops_no_burst | The maximum IOPS, assuming I/O bursting is disabled for the instance. | Count/s | iops_no_burst | ||
iops_burst | The maximum possible IOPS for the instance. | Count/s | iops_burst | ||
QPS | qps | The average number of SQL statements executed per second. | Count/s | SQLServer_QPS | sqlserver_qps |
Checkpoint page writes | lazy_writes | The number of buffers per second that the lazy writer process writes to disk. | Count/s | SQLServer_CheckPoint | sqlserver_lazy_writes |
checkpoint | The number of pages per second written to disk by a checkpoint. | Count/s | sqlserver_checkpoint | ||
Deadlocks | deadlock | The number of deadlocks per second. | Count/s | SQLServer_Deadlock | sqlserver_deadlock |
Page performance | sqlserver_pagereads | The number of data pages read from disk per second (physical I/O). | Count/s | SQLServer_PagePerf | sqlserver_pagereads |
sqlserver_pagewrites | The number of data pages written to disk per second (physical I/O). | Count/s | sqlserver_pagewrites | ||
MBps | MBps_total | The total disk I/O throughput per second. | MB/s | SQLServer_MBPS | MBps_total |
MBps_read | The disk read I/O throughput per second. | MB/s | MBps_read | ||
MBps_write | The disk write I/O throughput per second. | MB/s | MBps_write | ||
MBps_of_ecs | The maximum disk I/O throughput allowed by the instance's compute resources. | MB/s | MBps_of_ecs | ||
MBps_of_disk | The maximum disk I/O throughput allowed by the instance's storage resources. | MB/s | MBps_of_disk | ||
MBps_no_burst | The maximum disk I/O throughput per second, assuming I/O bursting is disabled for the instance. | MB/s | MBps_no_burst | ||
MBps_burst | The maximum possible disk I/O throughput for the instance. | MB/s | MBps_burst | ||
Logins | logins | The number of logins per second. | Count/s | SQLServer_Logins | sqlserver_logins |
logout | The number of logouts per second. | Count/s | sqlserver_logout | ||
Serverless RCU (Serverless instances only) | rcu | A measure of the RDS Capacity Units (RCUs) used by the serverless instance. | Count | SQLServer_RCU | rcu |
Advanced metrics
Chart | Metric | Description | Unit | OpenAPI key | API metric |
Index usage | Index_Searches_per_sec | Number of index searches per second. | Count/s | SQLServer_IndexUsage | Index_Searches_per_sec |
Forwarded_Records_per_sec | Number of forwarded records accessed per second. | Count/s | Forwarded_Records_per_sec | ||
Sessions | 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 | Number of logins per second from the connection pool. | Count/s | sqlserver_connectionreset | ||
user_connections | Number of user connections. | Count | sqlserver_sessions | ||
Cache | Cache_Object_Counts | Number of objects in the cache. | Count | SQLServer_Cache | Cache_Object_Counts |
Cache_Objects_in_use | Number of cache objects 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 compilation plan cache. | KB | SQLServer_AdvancedMemUsage | CACHESTORE_SQLCP_KB |
CACHESTORE_PHDR_KB | Memory used by the cache for algebrizer trees. | KB | CACHESTORE_PHDR_KB | ||
CACHESTORE_OBJCP_KB | Memory used by the object compilation plan cache. | KB | CACHESTORE_OBJCP_KB | ||
MEMORYCLERK_SOSNODE_KB | Memory allocated by the SQLOS node. | KB | MEMORYCLERK_SOSNODE_KB | ||
MEMORYCLERK_SQLCLR_KB | Memory used by the Common Language Runtime (CLR). | KB | MEMORYCLERK_SQLCLR_KB | ||
MEMORYCLERK_SQLSTORENG_KB | Memory used by the SQL storage engine. | KB | MEMORYCLERK_SQLSTORENG_KB | ||
USERSTORE_SCHEMAMGR_KB | Memory used by the user schema manager. | KB | USERSTORE_SCHEMAMGR_KB | ||
MEMORYCLERK_SOSMEMMANAGER | Memory used by the SQLOS memory manager. | KB | MEMORYCLERK_SOSMEMMANAGER | ||
CACHESTORE_SQLCP_VMCommitted_KB | Committed virtual memory for the SQL compilation plan cache. | KB | CACHESTORE_SQLCP_VMCommitted_KB | ||
CACHESTORE_PHDR_VMCommitted_KB | Committed virtual memory for the temporary memory cache used by the algebrizer tree. | KB | CACHESTORE_PHDR_VMCommitted_KB | ||
CACHESTORE_OBJCP_VMCommitted_KB | Committed virtual memory for the object compilation plan cache. | KB | CACHESTORE_OBJCP_VMCommitted_KB | ||
MEMORYCLERK_SOSNODE_VMCommitted_KB | Committed virtual memory used by the SQLOS node. | KB | MEMORYCLERK_SOSNODE_VMCommitted_KB | ||
MEMORYCLERK_SQLCLR_VMCommitted_KB | Committed virtual memory used by SQLCLR. | KB | MEMORYCLERK_SQLCLR_VMCommitted_KB | ||
MEMORYCLERK_SQLSTORENG_VMCommitted_KB | Committed virtual memory used by storage engine components. | KB | MEMORYCLERK_SQLSTORENG_VMCommitted_KB | ||
USERSTORE_SCHEMAMGR_VMCommitted_KB | Committed virtual memory used for metadata of various database objects. | KB | USERSTORE_SCHEMAMGR_VMCommitted_KB | ||
MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB | Committed virtual memory used by the SQLOS memory manager. | KB | MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB | ||
Backup performance | Backup_per_Restore_Throughput_per_sec | Throughput of backup or restore operations. | Bytes/s | SQLServer_BackupPerf | Backup_per_Restore_Throughput_per_sec |
Memory usage | Lock_Memory | Memory used by lock structures. | KB | SQLServer_MemUsage | Lock_Memory_KB |
Connection_Memory | Memory used by connections. | KB | Connection_Memory_KB | ||
Database_Cache_Memory | Memory used by the database buffer pool. | KB | Database_Cache_Memory_KB | ||
Free_Memory | Available memory. | KB | Free_Memory_KB | ||
Optimizer_Memory | Memory used by the query optimizer. | KB | Optimizer_Memory_KB | ||
Total_Server_Memory | Total memory used by SQL Server. | KB | Total_Server_Memory_KB | ||
SQL_Cache_Memory | Memory used by the SQL compilation plan cache. | KB | SQL_Cache_Memory_KB | ||
Stolen_Server_Memory | Memory diverted from the buffer pool for other uses. | KB | Stolen_Server_Memory_KB | ||
AlwaysOn Availability Group performance | Bytes_Received_from_Replica_per_sec | Bytes received per second from an Availability Group replica. | Bytes/s | SQLServer_AGPerf | Bytes_Received_from_Replica_per_sec |
ag_redo_finish_time | Timestamp when the replica finished the redo operation. | s | ag_redo_finish_time | ||
Bytes_Sent_to_Replica_per_sec | Bytes sent per second to an Availability Group replica. | Bytes/s | Bytes_Sent_to_Replica_per_sec | ||
Flow_Control_Time_ms_per_sec | Flow control duration per second. | ms/s | Flow_Control_Time_ms_per_sec | ||
Flow_Control_per_sec | Number of flow control events triggered per second. | Count/s | Flow_Control_per_sec | ||
SQL compilation rate | safe_autoparams_per_sec | Number of safe auto-parameterization attempts per second. | Count/s | SQLServer_SQLCompilations | Safe_AutoParams_per_sec |
failed_autoparams_per_sec | Number of failed auto-parameterization attempts per second. | Count/s | Failed_AutoParams_per_sec | ||
forced_parameterizations_per_sec | Number of successful forced parameterizations per second. | Count/s | Forced_Parameterizations_per_sec | ||
unsafe_autoparams_per_sec | Number of unsafe auto-parameterization attempts per second. | Count/s | Unsafe_AutoParams_per_sec | ||
autoparam_attempts_per_sec | Number of auto-parameterization attempts per second. | Count/s | AutoParam_Attempts_per_sec | ||
Mirroring sync performance (high-availability series only) | Redo_Bytes_Remaining | Amount of log data (in bytes) waiting to be redone on the replica. | Bytes | SQLServer_MirrorPerf | Redo_Bytes_Remaining |
Redone_Bytes_per_sec | Log bytes redone per second on the replica. | Bytes/s | Redone_Bytes_per_sec | ||
Log growth | Log_Shrinks | Number of transaction log shrink operations. | Count | SQLServer_LogGrowth | Log_Shrinks |
Log_Truncations | Number of transaction log truncation operations. | Count | Log_Truncations | ||
Log_Growths | Number of transaction log auto-growth operations. | Count | Log_Growths | ||
Version store rate | Version_Cleanup_rate_KB_per_s | Row version store cleanup rate. | KB/s | SQLServer_OptimizeConcurrent | Version_Cleanup_rate_KB_per_s |
Version_Generation_rate_KB_per_s | Row version store generation rate. | KB/s | Version_Generation_rate_KB_per_s | ||
Log performance | Log_Bytes_Flushed_per_sec | Number of log bytes flushed to disk per second (physical transaction log writes). | Bytes/s | SQLServer_LogPerf | Log_Bytes_Flushed_per_sec |
Log_Bytes_Received_per_sec | Rate of transaction log generation, in bytes per second. | Bytes/s | Log_Bytes_Received_per_sec | ||
Log_Cache_Reads_per_sec | Reads from the log cache per second. These reads do not require disk access. | Count/s | Log_Cache_Reads_per_sec | ||
Log_buffer_waits | Number of waits for log buffer availability. A high value indicates contention, which may require increasing the log buffer size or optimizing transactions. | Count | Log_buffer_waits | ||
Log_Flushes_per_sec | Number of log flushes to disk per second. A high value suggests frequent transaction commits and may indicate a need to optimize batching. | Count/s | Log_Flushes_per_sec | ||
Log_Pool_Requests_per_sec | Number of log buffer requests per second. Monitor this metric to track log buffer pressure. | Count/s | Log_Pool_Requests_per_sec | ||
Lock waits | lock_requests_per_sec | Number of lock requests 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 | Number of lock requests per second that required a wait. | Count/s | sqlserver_lockwaits | ||
table_lock_escalations_per_sec | Number of times 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 wait time for latch requests in the last second. | ms | Total_Latch_Wait_Time_ms | ||
latchwaits | Number of latch requests per second that could not be granted immediately. | Count/s | sqlserver_latchwaits | ||
lock_waits | Number of processes waiting for a lock. | Count | Lock_waits | ||
Page performance | Page_lookups_per_sec | Page lookups in the buffer pool 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 | Number of 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. | Count/s | Background_writer_pages_per_sec | ||
Page_latch_waits | Number of waits to acquire page latches. | Count | Page_latch_waits |
PostgreSQL
ApsaraDB RDS for PostgreSQL offers enhanced monitoring to provide more granular metrics in the console. This table maps the values of the Key parameter for the DescribeDBInstancePerformance operation to their corresponding metrics in enhanced monitoring.
|
|
Metric and description |
Enhanced monitoring metric |
|
MemoryUsage |
Memory usage. Unit: %. |
os.mem_usage.total.avg |
|
CpuUsage |
CPU utilization. Unit: %. |
os.cpu_usage.total.avg |
|
PgSQL_SpaceUsage |
Instance space usage. Unit: byte. |
os.fs_size.wal_dir.avg + os.fs_size.base_dir.avg (Unit: MB) |
|
PgSQL_IOPS |
IOPS (I/O operations per second). Unit: count/s. |
(os.iops.data.avg+os.iops.wal.avg) / os.iops.total.avg * 100 |
|
PgSQL_Session |
Total current connections. Unit: count. |
db.connections.total.avg |
|
PolarDBConnections |
|
|
|
PolarDBRowDML |
|
|
|
PolarDBQPSTPS |
|
|
|
PolarDBSwellTime |
Minimum age of garbage, in seconds, before it can be collected (swell point). |
db.swell.swell_time.avg |
|
PolarDBCPU |
CPU utilization. Unit: %. |
|
|
PolarDBMemory |
Memory usage. Unit: %. |
os.mem_usage.total.avg |
|
PolarDBReplication |
|
/ |
|
PolarDBLongSQL |
|
|
|
PolarDBLongIdleTransaction |
|
|
|
PolarDBLongTransaction |
|
|
|
PolarDBLongTwoPCTransaction |
|
|
|
PolarDBLocalIOSTAT |
|
|
|
PolarDBLocalDiskUsage |
|
|