ApsaraDB RDS:Performance parameters

Value of Key

Returned metrics and descriptions

MySQL_NetworkTraffic

The average inbound traffic and the average outbound traffic of the instance. Unit: KB/s.

MySQL_QPSTPS

The average number of SQL statements executed per second (executions/s) and the average number of transactions per second (TPS).

MySQL_Sessions

The number of active connections and the total number of connections. Unit: connections.

MySQL_InnoDBBufferRatio

The read hit ratio, usage, and percentage of dirty blocks for the InnoDB buffer pool. Unit: %.

MySQL_InnoDBDataReadWriten

The average amount of data read from the InnoDB storage engine per second and the average amount of data written to the InnoDB storage engine per second. Unit: KB.

MySQL_InnoDBLogRequests

The average number of reads from the InnoDB buffer pool per second and the average number of writes to the InnoDB buffer pool per second. Unit: reads/s or writes/s.

MySQL_InnoDBLogWrites

The average number of log write requests per second, the average number of physical writes to the log file per second, and the number of fsync() writes completed to the log file per second. Unit: writes/s.

MySQL_TempDiskTableCreates

The number of temporary tables that are automatically created on disks when statements are executed. Unit: tables.

MySQL_MyISAMKeyBufferRatio

The average usage, read hit ratio, and write hit ratio of the MyISAM key buffer per second. Unit: %.

MySQL_MyISAMKeyReadWrites

The average number of reads from the MyISAM buffer per second, the average number of writes to the MyISAM buffer per second, the average number of reads from disks per second, and the average number of writes to disks per second. Unit: reads/s or writes/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: executions/s.

MySQL_RowDML

The average number of rows read from, updated in, deleted from, and inserted into InnoDB tables per second, and the average number of physical writes to the log file per second. Unit: rows/s or writes/s.

MySQL_MemCpuUsage (for non-serverless instances)

The CPU utilization and memory usage of the non-serverless instance relative to the operating system. Unit: %.

MySQL_RCU_MemCpuUsage (for serverless instances)

Serverless instance CPU usage and MySQL instance memory usage, expressed as a percentage (%) of the total operating system resources.

MySQL_IOPS

The input/output operations per second (IOPS) of the instance. Unit: IOPS.

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: threads.

MySQL_ReplicationDelay

The replication delay of the secondary instance. Unit: seconds.

MySQL_ReplicationThread

The status of the I/O replication thread and the SQL replication thread. 1 indicates Normal. 0 indicates that the thread is lost.

MySQL_ROW_LOCK

The maximum wait time for a row-level lock (ms), the average wait time for a row-level lock (ms), and the number of waits for row-level locks (times).

MySQL_SelectScan

The number of full table scans performed on the instance. Unit: scans.

MySQL_MBPS

The read and write throughput of the instance. Unit: bytes/s.

Value of Key

Returned metric

Description

SQLServer_RCU

rcu

RDS Capacity Unit

SQLServer_DetailedSpaceUsage

ins_size

The total space usage of the instance.

log_size

The log space usage.

data_size

The data space usage.

other_size

The system space usage.

tmp_size

The temporary space usage.

disk_mastersize

The size of the space that stores the SQL Server system database master.

disk_modelsize

The size of the disk space that stores the model database. The model database is used as the template for all databases created on an instance.

disk_msdbsize

The size of the disk space that stores the msdb database. The msdb database is used for SQL Server Agent jobs, backup history, and other information.

disk_errorlog

The disk space occupied by error log files. You can clear the error logs of the instance in the console or by calling an API operation.

disk_xel

The disk space occupied by Extended Event log files.

disk_trace

The disk space that stores SQL Server trace files, such as SQL Profiler trace files.

disk_dump

The space occupied by dump files that are generated when the SQL Server kernel encounters an exception.

SQLServer_InstanceDiskUsage

InstanceDiskUsage

The disk space usage.

SQLServer_IndexUsage

Index_Searches_per_sec

The number of index searches per second.

Forwarded_Records_per_sec

The number of times forwarded records are accessed per second.

SQLServer_BufferHit

Cache_Hit_Ratio

The cache hit ratio.

sqlserver_bufferpool

The percentage of pages found in the buffer cache that do not need to be read from the disk.

SQLServer_InstanceMemUsage

sqlserver_insmem

The memory usage of the instance.

SQLServer_NetworkTraffic

read_kb

The average outbound traffic of the instance per second.

write_kb

The average inbound traffic of the instance per second.

SQLServer_Alarm

alarm_abnormal_db

The number of databases for which database mirroring is not correctly configured or fails to be synchronized.

SQLServer_Sessions

Active_Temp_Tables

The number of active temporary tables.

Active_Transactions

The number of active transactions.

Active_cursors

The number of active cursors.

sqlserver_activesession

The number of active threads.

sqlserver_connectionreset

The total number of logons initiated from the connection pool per second.

sqlserver_sessions

The total number of connections.

SQLServer_Transactions

sqlserver_transactions

The average number of transactions per second.

sqlserver_write_transactions

The average number of write transactions per second.

SQLServer_Cache

Cache_Object_Counts

The total number of objects in the cache.

Cache_Objects_in_use

The number of cache objects that are in use.

Cache_Pages

The number of pages occupied by the cache.

SQLServer_AdvancedMemUsage

CACHESTORE_SQLCP_KB

The memory occupied by the SQL compiled plan cache. Unit: KB.

CACHESTORE_PHDR_KB

The memory occupied by the physical driver cache. Unit: KB.

CACHESTORE_OBJCP_KB

The memory occupied by the object compiled plan cache. Unit: KB.

MEMORYCLERK_SOSNODE_KB

The memory allocated to operating system nodes. Unit: KB.

MEMORYCLERK_SQLCLR_KB

The memory occupied by the common language runtime (CLR). Unit: KB.

MEMORYCLERK_SQLSTORENG_KB

The memory occupied by the SQL storage engine. Unit: KB.

USERSTORE_SCHEMAMGR_KB

The memory occupied by the user schema manager. Unit: KB.

MEMORYCLERK_SOSMEMMANAGER

The memory occupied by the operating system memory manager. Unit: KB.

CACHESTORE_SQLCP_VMCommitted_KB

The plan cache (SQL Plan) in the virtual memory.

CACHESTORE_PHDR_VMCommitted_KB

The temporary memory cache of the algebrizer tree in the virtual memory.

CACHESTORE_OBJCP_VMCommitted_KB

The plan cache (Object Plan) in the virtual memory.

MEMORYCLERK_SOSNODE_VMCommitted_KB

The SOSNODE (part of SQLOS) in the virtual memory.

MEMORYCLERK_SQLCLR_VMCommitted_KB

The SQLCLR in the virtual memory.

MEMORYCLERK_SQLSTORENG_VMCommitted_KB

The storage engine component in the virtual memory.

USERSTORE_SCHEMAMGR_VMCommitted_KB

The metadata of different types of database objects in the virtual memory.

MEMORYCLERK_SOSMEMMANAGER_VMCommitted_KB

The SOSMEMMANAGER (part of SQLOS) in the virtual memory.

SQLServer_BackupPerf

Backup_per_Restore_Throughput_per_sec

The number of bytes processed per second during a backup or restore operation (throughput).

SQLServer_MemUsage

Lock_Memory_KB

The memory occupied by lock structures. Unit: KB.

Connection_Memory_KB

The memory occupied by connections. Unit: KB.

Database_Cache_Memory_KB

The memory occupied by the database buffer pool. Unit: KB.

Free_Memory_KB

The available memory. Unit: KB.

Optimizer_Memory_KB

The memory occupied by the query optimizer. Unit: KB.

Total_Server_Memory_KB

The total memory currently occupied by SQL Server. Unit: KB.

SQL_Cache_Memory_KB

The memory occupied by the SQL plan cache. Unit: KB.

Stolen_Server_Memory_KB

The memory occupied for other purposes. Unit: KB.

SQLServer_AGPerf

sqlserver_alwayson_lagsecs

The replication lag between the primary and secondary instances in a SQL Server Always On availability group.

sqlserver_alwayson_redoqueuesize_kb

The size of the log queue to be redone on the replica. Unit: KB.

sqlserver_alwayson_sendqueuesize_kb

The size of the log queue to be sent from the primary replica to the secondary replica. Unit: KB.

Bytes_Received_from_Replica_per_sec

The number of bytes received from the replica per second.

ag_unhealthydb_count

The number of unhealthy databases in the availability group.

ag_db_not_in_ag_count

The number of databases that are not in the availability group.

ag_redo_finish_time

The timestamp when the replica finishes redoing logs.

Bytes_Sent_to_Replica_per_sec

The number of bytes sent to the replica per second.

Flow_Control_Time_ms_per_sec

The duration of flow control per second. Unit: ms.

Flow_Control_per_sec

The number of times flow control is triggered per second.

SQLServer_SQLCompilations

sqlserver_sqlcompilations

The number of SQL compilations per second.

sqlserver_resqlcompilations

The number of statement recompilations per second.

Safe_AutoParams_per_sec

The number of safe auto-parameterization attempts per second.

Failed_AutoParams_per_sec

The number of failed auto-parameterization attempts per second.

Forced_Parameterizations_per_sec

The number of successful forced parameterizations per second.

Unsafe_AutoParams_per_sec

The number of unsafe auto-parameterization attempts per second.

AutoParam_Attempts_per_sec

The number of auto-parameterization attempts per second.

SQLServer_InstanceIOPSUsage

InstanceIOPSUsageBurst

The actual IOPS usage.

InstanceIOPSUsageNoBurst

The IOPS usage, assuming that I/O burst is disabled for the instance.

InstanceIOPSBurstRatio

The IOPS improvement rate after I/O burst is enabled.

SQLServer_LockTimeout

sqlserver_locktimeout

The number of lock requests that time out per second, including requests for NOWAIT locks.

SQLServer_MirrorPerf

sqlserver_log_send_queue

The number of log bytes to be sent from the primary replica to the secondary replica.

sqlserver_redo_queue

The number of log bytes to be redone on the replica.

Redo_Bytes_Remaining

The number of log bytes that remain to be redone on the replica.

Redone_Bytes_per_sec

The number of log bytes redone on the replica per second.

SQLServer_LogGrowth

Log_Shrinks

The number of times the transaction log is shrunk.

Log_Truncations

The number of times the transaction log is truncated.

Log_Growths

The number of times the transaction log is automatically grown.

SQLServer_PageLife

sqlserver_pagelife

The average time that a cached data page stays in the memory.

SQLServer_OptimizeConcurrent

Version_Cleanup_rate_KB_per_s

The size of row versioning store that is cleaned up per second. Unit: KB.

Version_Generation_rate_KB_per_s

The size of row versioning store that is generated per second. Unit: KB.

SQLServer_Block

Wait_for_the_worker

The length of the worker thread wait queue.

uncommited_tran

The number of uncommitted transactions.

Longest_Transaction_Running_Time

The duration of the longest-running transaction.

Processes_blocked

The number of blocked processes.

SQLServer_FullScans

sqlserver_fullscans

The average number of full table scans per second.

SQLServer_LogPerf

Log_Bytes_Flushed_per_sec

The number of log bytes flushed to the disk per second (physical writes to the transaction log).

Log_Bytes_Received_per_sec

The number of log bytes received per second (transaction log generation rate).

Log_Cache_Reads_per_sec

The number of reads from the log cache per second. These reads do not require disk reads.

Log_buffer_waits

The number of waits for the log buffer. A high value for this metric indicates severe contention for the log buffer. In this case, increase the size of the log buffer or optimize transactions.

Log_Flushes_per_sec

The number of times the log is flushed to the disk per second. A high value for this metric indicates frequent transactions. In this case, you may need to optimize batch operations.

Log_Pool_Requests_per_sec

The number of requests for the log buffer per second. This metric indicates the usage pressure on the log buffer.

SQLServer_InstanceMBPSUsage

mBps_usage_no_burst

The disk I/O throughput usage, assuming that I/O burst is disabled for the instance.

mBps_usage_burst

The actual disk I/O throughput usage.

mBps_burst_ratio

The disk I/O throughput improvement rate after I/O burst is enabled.

SQLServer_IOPS

db_io_read

The number of read I/O requests per second.

db_io

The number of I/O requests per second.

db_io_write

The number of write I/O requests per second.

iops_of_ecs

The upper limit of IOPS on the computing side.

iops_of_disk

The upper limit of IOPS on the storage side.

iops_no_burst

The upper limit of IOPS, assuming that I/O burst is disabled for the instance.

iops_burst

The upper limit of IOPS.

SQLServer_QPS

sqlserver_qps

The average number of SQL statements executed per second.

SQLServer_CheckPoint

sqlserver_lazy_writes

The number of writes to the disk per second.

sqlserver_checkpoint

The number of pages written by checkpoints per second.

SQLServer_Deadlock

sqlserver_deadlock

The number of deadlocks per second.

SQLServer_LockWaits

Lock_Requests_per_sec

The total number of lock requests that SQL Server receives per second.

Lock_Wait_Time_ms

The average lock wait time.

sqlserver_lockwaits

The number of lock requests that a caller waits for per second.

Table_Lock_Escalations_per_sec

The number of times locks on a table are escalated to the TABLE or HoBT granularity.

Average_Latch_Wait_Time

The average wait time for latch requests.

Average_Lock_Wait_Time

The average wait time for lock requests.

Total_Latch_Wait_Time_ms

The total wait time for latches in the last second.

sqlserver_latchwaits

The number of latch requests that cannot be granted immediately per second.

Lock_waits

The performance statistics of processes that are waiting for locks.

SQLServer_PagePerf

Page_lookups_per_sec

The number of times pages in the buffer pool are queried per second.

sqlserver_pagereads

The number of data pages read from the disk per second (physical I/O).

sqlserver_pagewrites

The number of data pages written to the disk per second (physical I/O).

Pages_compressed_per_sec

The number of data pages that are compressed per second.

Page_IO_latch_waits

The number of waits to obtain a page I/O latch.

sqlserver_pagesplits

The number of page splits per second.

Readahead_pages_per_sec

The number of pages on which read-ahead operations are performed per second.

Background_writer_pages_per_sec

The number of pages written to the disk by the background writer process per second.

Page_latch_waits

The total number of waits to obtain a page latch.

SQLServer_InstanceCPUUsage

sqlserver_inscpu

The CPU utilization of the instance relative to the operating system.

SQLServer_MBPS

mBps_total

The disk I/O throughput per second.

mBps_read

The disk read I/O throughput per second.

mBps_write

The disk write I/O throughput per second.

mBps_of_ecs

The upper limit of the disk I/O throughput per second on the computing side.

mBps_of_disk

The upper limit of the disk I/O throughput per second on the storage side.

mBps_no_burst

The upper limit of the disk I/O throughput per second, assuming that I/O burst is disabled for the instance.

mBps_burst

The upper limit of the disk I/O throughput per second.

SQLServer_Logins

sqlserver_logins

The number of logons per second.

sqlserver_logout

The number of logouts per second.

Value of Key

Returned metrics and descriptions

Corresponding enhanced monitoring metric

MemoryUsage

The memory usage. Unit: %.

os.mem_usage.total.avg

CpuUsage

The CPU utilization. Unit: %.

os.cpu_usage.total.avg

PgSQL_SpaceUsage

The space usage of the instance. Unit: bytes.

os.fs_size.wal_dir.avg + os.fs_size.base_dir.avg Unit: MB

PgSQL_IOPS

IOPS (input/output operations per second) is measured in operations per second.

(os.iops.data.avg+os.iops.wal.avg) / os.iops.total.avg * 100

PgSQL_Session

The total number of connections. Unit: connections.

db.connections.total.avg

PolarDBConnections

The returned parameters and their descriptions are as follows:

• mean_active_session: The number of active connections.

• mean_idle_connection: The number of connections that are in an idle session state.

• mean_total_session: The total number of connections.

• mean_waiting_connection: The number of connections that are in a waiting state.

• db.connections.active.avg

• db.connections.idle.avg

• db.connections.total.avg

• db.connections.waiting.avg



PolarDBRowDML

The returned parameters and their descriptions are as follows:

• mean_tup_returned_delta: The number of rows scanned per second during full table scans.

• mean_tup_fetched_delta: The number of rows fetched from tables per second using index scans.

• mean_tup_inserted_delta: The number of rows inserted per second.

• mean_tup_updated_delta: The number of rows updated per second.

• mean_tup_deleted_delta: The number of rows deleted per second.

• db.sql.tup_returned.avg

• db.sql.tup_fetched.avg

• db.sql.tup_inserted.avg

• db.sql.tup_updated.avg

• db.sql.tup_deleted.avg

PolarDBQPSTPS

The returned parameters and their descriptions are as follows:

• mean_commits_delta: The number of committed transactions per second.

• mean_rollbacks_delta: The number of rolled-back transactions per second.

• mean_deadlocks_delta: The number of deadlocks per second.

• mean_tps: The number of transactions per second.

• db.transactions.xact_commit.avg

• db.transactions.xact_rollback.avg

• Deadlock-Free Operation Count

• db.transactions.xact_commit.avg+db.transactions.xact_rollback.avg

PolarDBSwellTime

The longest bloat duration for garbage collection. This indicates that garbage older than this duration can be collected. The value is in seconds.

db.swell.swell_time.avg

PolarDBCPU

The CPU utilization.

• os.cpu_usage.sys.avg

• os.cpu_usage.user.avg

• os.cpu_usage.total.avg

PolarDBMemory

The memory usage.

os.mem_usage.total.avg

PolarDBReplication

The returned parameters and their descriptions are as follows:

• mean_replay_latency_in_mb: The synchronization latency of the secondary database. Unit: bytes.

• mean_send_latency_in_mb: The send latency of the primary database. Unit: bytes.

• mean_logical_rep_latency_in_mb: The logical replication delay. Unit: bytes.

/

PolarDBLongSQL

The returned parameters and their descriptions are as follows:

• mean_one_second_executing_sqls: The number of SQL statements that have been running for more than 1 second.

• mean_three_seconds_executing_sqls: The number of SQL statements that have been running for more than 3 seconds.

• mean_five_seconds_executing_sqls: The number of SQL statements that have been running for more than 5 seconds.

• db.slow_sql.one_second.avg

• db.slow_sql.three_seconds.avg

• db.slow_sql.five_seconds.avg

PolarDBLongIdleTransaction

The returned parameters and their descriptions are as follows:

• mean_one_second_idle_transactions: The number of transactions that have been idle for more than 1 second.

• mean_three_seconds_idle_transactions: The number of transactions that have been idle for more than 3 seconds.

• mean_five_seconds_idle_transactions: The number of transactions that have been idle for more than 5 seconds.

• db.long_transactions.idle_one_second.avg

• db.long_transactions.idle_three_seconds

• db.long_transactions.idle_five_seconds.avg

PolarDBLongTransaction

The returned parameters and their descriptions are as follows:

• mean_one_second_transactions: The number of transactions that have been running for more than 1 second.

• mean_three_seconds_transactions: The number of transactions that have been running for more than 3 seconds.

• db.long_transactions.active_one_second.avg

• db.long_transactions.active_three_seconds.avg

PolarDBLongTwoPCTransaction

The returned parameters and their descriptions are as follows:

• mean_one_second_two_pc_transactions: The number of two-phase commit (2PC) transactions that have been running for more than 1 second.

• mean_three_seconds_two_pc_transactions: The number of 2PC transactions that have been running for more than 3 seconds.

• mean_five_seconds_two_pc_transactions: The number of 2PC transactions that have been running for more than 5 seconds.

• db.long_transactions.two_pc_one_second.avg

• db.long_transactions.two_pc_three_seconds.avg

• db.long_transactions.two_pc_five_seconds.avg

PolarDBLocalIOSTAT

The returned parameters and their descriptions are as follows:

• mean_local_iops_read: The number of read operations on the data disk per second.

• mean_local_iops_write: The number of write operations on the data disk per second.

• os.iops.read.avg

• os.iops.write.avg

PolarDBLocalDiskUsage

The returned parameters and their descriptions are as follows:

• mean_local_pg_wal_dir_size: The Write-Ahead Logging (WAL) space usage. Unit: MB.

• mean_local_pg_log_dir_size: The log space usage. Unit: MB.

• mean_local_base_dir_size: The data space usage. Unit: MB.

• os.fs_size.wal_dir.avg

• os.fs_size.log_dir.avg

• os.fs_size.base_dir.avg