使用 Amazon CloudWatch 監控 Aurora DSQL

使用 CloudWatch 監控 Aurora DSQL，它會收集原始資料並將其處理為可讀且近乎即時的指標。CloudWatch 會保留這些統計資料 15 個月，協助您更清楚 Web 應用程式或服務效能。設定警示以監控特定閾值，並在符合時傳送通知或採取動作。檢閱下列適用於 Aurora DSQL 的用量和可觀測性指標。

如需更多資訊，請參閱 Amazon CloudWatch 使用者指南。

可觀測性和效能

此資料表概述 Aurora DSQL 的可觀測性指標。它包含用於追蹤唯讀和總交易的指標，以提供整體工作負載特性。包括查詢逾時和 OCC 衝突率等可行指標，以協助識別效能問題和並行衝突。與工作階段相關的指標，包括作用中和總計，都提供對系統目前負載的洞見。

CloudWatch 指標名稱	指標	單位	描述
ReadOnlyTransactions	Read-only transactions	none	The number of read-only transactions
TotalTransactions	Total transactions	none	The total number of transactions executed on the system, including read-only transactions.
QueryTimeouts	Query timeouts	none	The number of queries which have timed out due to hitting the maximum transaction time
OccConflicts	OCC conflicts	none	The number of transactions aborted due to key level OCC
CommitLatency	Commit Latency	milliseconds	Time spent by commit phase of query execution (P50)
BytesWritten	Bytes Written	bytes	Bytes written to storage
BytesRead	Bytes Read	bytes	Bytes read from storage
ComputeTime	QP compute time	milliseconds	QP wall clock time
ClusterStorageSize	Cluster Storage Size	bytes	Cluster size

用量指標

Aurora DSQL 會使用稱為分散式處理單元 (DPU) 的單一標準化帳單單位，測量所有以請求為基礎的活動，例如查詢處理、讀取和寫入。

CloudWatch 指標名稱	指標	維度：ResourceId	單位	描述
WriteDPU	Write Units	<cluster-id>	DPU	Approximates the write active-use component of your Aurora DSQL cluster DPU usage.
MultiRegionWriteDPU	Multi-Region Write Units	<cluster-id>	DPU	Applicable for Multi-Region clusters: Approximates the multi-Region write active-use component of your Aurora DSQL cluster DPU usage.
ReadDPU	Read Units	<cluster-id>	DPU	Approximates the read active-use component of your Aurora DSQL cluster DPU usage.
ComputeDPU	Compute Units	<cluster-id>	DPU	Approximates the compute active-use component of your Aurora DSQL cluster DPU usage.
TotalDPU	Total Units	<cluster-id>	DPU	Approximates the total active-use component of your Aurora DSQL cluster DPU usage.