帮你快速理解、总结文档立即下载

云数据库 SQL Server 监控指标

最近更新时间:2026-11-20 14:53:01
本文档已由 AI 辅助审校
我的收藏

命名空间

Namespace = QCE/SQLSERVER

监控指标

CPU

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
Cpu
核心数
CPU 利用率
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CpuProcess
CPU 利用率[进程]
SQL Server 进程级 CPU 使用率
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CpuProcessView
CPU 利用率[进程]
SQL Server 进程级 CPU 使用率
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CpuView
核心数
CPU 利用率
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

其他

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
UserErrors
用户错误数
平均每秒由用户请求触发的错误次数,如语法错误、对象不存在、权限不足、约束冲突
times/s
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
UserErrorsView
用户错误数
平均每秒由用户请求触发的错误次数,如语法错误、对象不存在、权限不足、约束冲突
Count/s
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]

内存

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
MaxMemory
最大内存
SQL Server 当前的目标内存,受 max server memory 限制,是实例打算使用的内存上限,不是机器物理内存
KBytes
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
MaxMemoryView
最大内存
SQL Server 当前的目标内存,受 max server memory 限制,是实例打算使用的内存上限,不是机器物理内存
KBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
ServerMemory
内存使用
SQL Server 当前已提交使用的内存总量
MB
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
ServerMemoryView
内存使用
SQL Server 当前已提交使用的内存总量
MBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
TotalAllocatedMemory
内部系统锁定内存
内部系统的锁定内存,仅 2014 及以上版本支持查看此项监控指标
KBytes
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
TotalAllocatedMemoryView
内部系统锁定内存
内部系统的锁定内存,仅 2014 及以上版本支持查看此项监控指标
KBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
TotalUsedMemory
内部系统消耗内存
内部系统的消耗内存,仅 2014 及以上版本支持查看此项监控指标
KBytes
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
TotalUsedMemoryView
内部系统消耗内存
内部系统的消耗内存,仅 2014 及以上版本支持查看此项监控指标
KBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
UsageMemory
内存使用率
当前已使用内存占最大内存的百分比
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
UsageMemoryProcess
内存使用率[进程]
进程级内存使用率
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
UsageMemoryProcessView
内存使用率[进程]
进程级内存使用率
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
UsageMemoryView
内存使用率
当前已使用内存占最大内存的百分比
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
XtpMemoryUsageView
XTP 内存占用总量
内存优化表(In-Memory OLTP,又称 XTP)占用的内存总量。未使用内存优化表时通常为 0
KBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

存储

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
AvgDiskQueueLength
磁盘队列长度
整机级磁盘队列长度
Count
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskQueueLengthView
磁盘队列长度
整机级磁盘队列长度
Count
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskSecRead
读 IO 平均响应时间
整机级读 IO 平均响应时间
ms
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskSecReadView
读 IO 平均响应时间
整机级读 IO 平均响应时间
ms
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskSecTransfer
IO 请求平均响应时间
整机级 IO 请求平均响应时间
ms
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskSecTransferView
IO 请求平均响应时间
整机级 IO 请求平均响应时间
ms
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskSecWrite
写 IO 平均响应时间
整机级写 IO 平均响应时间
ms
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgDiskSecWriteView
写 IO 平均响应时间[整机]
整机级写 IO 平均响应时间
ms
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
DiskReadBytesSec
磁盘读流量
整机级磁盘读流量
KBytes/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskReadBytesSecView
磁盘读流量
整机级磁盘读流量
KBytes/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskReads
读取磁盘次数
磁盘每秒的读 IO 数量(针对双节点本地盘版实例所部署机器的系统维度监控)
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskReadsSec
磁盘每秒读 IO 数量
整机级磁盘每秒读 IO 数量
Count/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskReadsSecView
磁盘每秒读 IO 数量
整机级磁盘每秒读 IO 数量
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskReadsView
读取磁盘次数
磁盘每秒的读 IO 数量(针对双节点本地盘版实例所部署机器的系统维度监控)
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskThroughputBytesSec
磁盘吞吐量
整机级磁盘吞吐量
KBytes/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskThroughputBytesSecView
磁盘吞吐量
整机级磁盘吞吐量
KBytes/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskTransfersSec
磁盘 IOPS 总数
整机级磁盘 IOPS 总数
Count/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskTransfersSecView
磁盘 IOPS 总数
整机级磁盘 IOPS 总数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskWriteBytesSec
磁盘写流量
整机级磁盘写流量
KBytes/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskWriteBytesSecView
磁盘写流量
整机级磁盘写流量
KBytes/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskWrites
写入磁盘次数
磁盘每秒的写 IO 数量(针对双节点本地盘版实例所部署机器的系统维度监控)
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskWritesSec
磁盘每秒写 IO 数量
整机级磁盘每秒写 IO 数量
Count/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskWritesSecView
磁盘每秒写 IO 数量
整机级磁盘每秒写 IO 数量
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DiskWritesView
写入磁盘次数
磁盘每秒的写 IO 数量(针对双节点本地盘版实例所部署机器的系统维度监控)
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
FreeStorage
硬盘剩余容量百分比
硬盘剩余容量百分比,计算方式为:(购买磁盘 - 已用存储空间) / 购买磁盘
%
resourceId
[ 10s, min ] [ 60s, min ] [ 300s, min ] [ 3600s, min ] [ 86400s, min ]
FreeStorageProcess
硬盘剩余容量百分比[进程]
进程级硬盘剩余容量百分比
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
FreeStorageProcessView
硬盘剩余容量百分比[进程]
进程级硬盘剩余容量百分比
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
FreeStorageView
硬盘剩余容量百分比
硬盘剩余容量百分比,计算方式为:(购买磁盘 - 已用存储空间) / 购买磁盘
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
Iops
磁盘 IOPS
磁盘读写次数
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
IopsView
磁盘 IOPS
磁盘读写次数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
Storage
已用存储空间
实例数据库文件和日志文件占用的空间总和
GBytes
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
StorageProcess
已用存储空间[进程]
进程级已用存储空间
GBytes
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
StorageProcessView
已用存储空间[进程]
进程级已用存储空间
GBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
StorageView
已用存储空间
实例数据库文件和日志文件占用的空间总和
GBytes
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

网络

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
InFlow
输入流量
所有客户端连接发送到实例的数据包大小总和
KBytes/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
InFlowView
输入流量
所有客户端连接发送到实例的数据包大小总和
KBytes/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
NetworkIoWaits
平均网络 IO 延迟
平均网络 IO 的延迟时间
ms
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
NetworkIoWaitsView
平均网络 IO 延迟
平均网络 IO 的延迟时间
ms
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
OutFlow
输出流量
实例返回给所有客户端连接的数据包大小总和
kb/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
OutFlowView
输出流量
实例返回给所有客户端连接的数据包大小总和
KBytes/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
ReplicaDelayView
RO 同步延迟时间
只读副本相对主实例的数据延迟,指主库事务日志发送到只读副本并重做完成的滞后时间,延迟越大,只读副本读到的数据越旧
s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

访问

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
BlockedProcesses
阻塞数
当前处于被阻塞状态的会话数(对应 Processes blocked),是瞬时值,不是累计值。持续大于 0 说明存在锁等待链
Count
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
BlockedProcessesView
阻塞数
当前处于被阻塞状态的会话数(对应 Processes blocked),是瞬时值,不是累计值。持续大于 0 说明存在锁等待链
Count
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
BufferCacheHitRatio
缓冲区缓存命中率
数据缓存(内存)命中率
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
BufferCacheHitRatioView
缓冲区缓存命中率
数据缓存(内存)命中率
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
FullScans
每秒钟 SQL 做全表扫描数目
每秒不受限制的完整扫描次数,包括基表扫描和全索引扫描。偏高通常意味着缺少合适索引或查询未走索引
times/s
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
FullScansView
每秒钟 SQL 做全表扫描数目
每秒不受限制的完整扫描次数,包括基表扫描和全索引扫描。偏高通常意味着缺少合适索引或查询未走索引
Count/s
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
PlanCacheHitRatio
执行计划缓存命中率
查询执行时在计划缓存里找到已有执行计划的比例。越高说明计划复用越好、编译开销越小。低于 90% 需关注
%
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
PlanCacheHitRatioView
执行计划缓存命中率
查询执行时在计划缓存里找到已有执行计划的比例。越高说明计划复用越好、编译开销越小。低于 90% 需关注
%
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
Requests
请求数
平均每秒的请求数
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
RequestsView
请求数
平均每秒的请求数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
SlowQueries
慢查询
统计周期内运行时间超过设定阈值(默认为 1 秒,但支持设置,请关注实际设置值)的查询数量
Count
resourceId
[ 10s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ]
SlowQueriesView
慢查询
统计周期内运行时间超过设定阈值(默认为 1 秒,但支持设置,请关注实际设置值)的查询数量
Count
appid instanceid
[ 10s, sum ] [ 60s, sum ] [ 300s, sum ] [ 3600s, sum ] [ 86400s, sum ]
SqlCompilations
SQL 编译数
平均每秒 SQL 编译次数
times/s
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
SqlCompilationsView
SQL 编译数
平均每秒 SQL 编译次数
Count/s
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
SqlRecompilations
SQL 重编译数
平均每秒 SQL 重编译数
times/s
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
SqlRecompilationsView
SQL 重编译数
平均每秒 SQL 重编译数
Count/s
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
Transactions
事务数
平均每秒的事务数
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
TransactionsView
事务数
平均每秒的事务数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

连接

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
Connections
连接数
平均每秒用户连接数据库的个数
Count
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
ConnectionsView
连接数
平均每秒用户连接数据库的个数
Count
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
Logins
每秒登录次数
每秒新建的数据库连接(登录)次数
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LoginsView
每秒登录次数
每秒新建的数据库连接(登录)次数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
Logouts
每秒登出次数
每秒断开的数据库连接次数
times/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LogoutsView
每秒登出次数
每秒断开的数据库连接次数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

锁

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
AvgLatchWaitMs
闩锁等待延迟
每秒无法立即获得、必须等待的闩锁请求次数。闩锁是保护内存数据结构(如缓冲页)的轻量同步机制,与事务锁不同,偏高多见于内存页或分配页争用
ms
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
AvgLatchWaitMsView
闩锁等待延迟
每秒无法立即获得、必须等待的闩锁请求次数。闩锁是保护内存数据结构(如缓冲页)的轻量同步机制,与事务锁不同,偏高多见于内存页或分配页争用
ms
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
BlockedProcessThreshold
阻塞报告生成阀值
所指定的生成阻塞报告的阈值,超过该阈值将生成阻塞的进程报告,默认情况下,不生成阻塞的进程报告
Count
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
BlockedProcessThresholdView
阻塞报告生成阀值
所指定的生成阻塞报告的阈值,超过该阈值将生成阻塞的进程报告,默认情况下,不生成阻塞的进程报告
Count
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LatchWaits
每秒闩锁等待数量
每秒发生的闩锁等待次数
times/s
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
LatchWaitsView
每秒闩锁等待数量
每秒发生的闩锁等待次数
Count/s
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
LockRequests
锁请求次数
每秒向锁管理器请求新锁及锁转换的次数,反映并发事务对锁的使用强度
times/s
resourceId
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
LockRequestsView
锁请求次数
每秒向锁管理器请求新锁及锁转换的次数,反映并发事务对锁的使用强度
Count/s
appid instanceid
[ 10s, avg ] [ 60s, avg ] [ 300s, avg ] [ 3600s, avg ] [ 86400s, avg ]
LockTimeoutSec
每秒锁超时次数
每秒超时的锁请求数,包括对 NOWAIT 锁的请求
Count/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LockTimeoutSecView
每秒锁超时次数
每秒超时的锁请求数,包括对 NOWAIT 锁的请求
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LockWaits
平均锁等待延迟
每个发生等待的锁请求的平均等待时长
ms
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LockWaitsView
平均锁等待延迟
每个发生等待的锁请求的平均等待时长
ms
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
NumberOfDeadlocks
死锁数
每秒导致死锁的锁请求数
Count/s
resourceId
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]
NumberOfDeadlocksView
死锁数
每秒导致死锁的锁请求数
Count/s
appid instanceid
[ 10s, max ] [ 60s, max ] [ 300s, max ] [ 3600s, max ] [ 86400s, max ]

备份

指标名
指标中文名
说明
单位
维度
统计规则
[period, statType]
ActualUsedSpace
总备份
实例当前备份占用的实际总存储空间,即数据备份加日志备份,超出免费额度的部分计费
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CrossActualUsedSpace
跨地域总备份
复制到其他地域的备份占用的实际总存储空间
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CrossDataBackupSpace
跨地域数据备份
跨地域复制的完整备份(数据备份)占用的空间
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CrossFreeSpace
跨地域免费空间
跨地域备份可享受的免费存储额度
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
CrossLogBackupSpace
跨地域日志备份
跨地域复制的事务日志备份占用的空间
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
DataBackupSpace
数据备份
数据库完整备份占用的存储空间
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
FreeSpace
免费空间
备份存储中免赠的空间额度,已用备份在该额度内不计费
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
LogBackupSpace
日志备份
事务日志备份占用的存储空间,增长速度与业务写入量和日志备份频率有关
KBytes
appid regionid
[ 300s, max ] [ 3600s, max ] [ 86400s, max ]
说明:
开启 备节点只读 功能后,支持查询备节点的监控,其监控指标与主实例一致,均可参考下表。如何查看备节点的监控请参见 查看监控图表。
支持整机级和进程级监控指标:
整机级监控指标:实例所部署机器的监控,包括操作系统、数据库主进程、管控组件等。监控指标显示为:监控指标名称 + [整机]。其中本地盘架构实例的整机级监控指标为实例所在的物理机监控情况,云盘架构实例的整机级监控指标为实例所在的 CVM 监控情况。
进程级监控指标:数据库实例的进程监控。监控指标显示为:监控指标名称 + [进程]。
当前设置了整机级和进程级的监控指标如下:
整机级(本地盘架构):磁盘队列长度 [整机]、读 IO 平均响应时间 [整机]、IO 请求平均响应时间 [整机]、写 IO 平均响应时间 [整机]、磁盘每秒写 IO 数量 [整机]、磁盘每秒读 IO 数量 [整机]、磁盘 IOPS 总数 [整机]、磁盘读流量 [整机]、磁盘写流量 [整机]、磁盘吞吐量 [整机]。
整机级(云盘架构):CPU 利用率、内存使用率、硬盘容量百分比、已用存储空间、读 IO 平均响应时间 [整机]、写 IO 平均响应时间 [整机]、磁盘读流量 [整机]、磁盘写流量 [整机]、磁盘吞吐量 [整机]。
本地盘和云盘架构实例支持整机级监控指标,具体支持的监控指标请以控制台告警配置 > 指标为准。
进程级:CPU 利用率 [进程]、内存使用率 [进程]、硬盘容量百分比 [进程]、已用存储空间 [进程]。仅云盘版实例支持进程级监控指标,具体支持的监控指标请以控制台告警配置 > 指标为准。

各维度对应参数总览

参数名称
维度名称
维度解释
格式
Instances.N.Dimensions.0.Name
resourceId
实例资源 ID 的维度名称
输入 String 类型维度名称:resourceId
Instances.N.Dimensions.0.Value
resourceId
实例具体的资源 ID
输入实例的具体 resourceId,例如:mssql-dh0123456
Instances.N.Dimensions.1.Name
regionid
实例地域 ID 的维度名称
输入 String 类型维度名称:regionid
Instances.N.Dimensions.1.Value
regionid
实例地域维度的 ID
输入地域维度名称,例如:regionid = ap-guangzhou
Instances.N.Dimensions.2.Name
appid
实例所属账号的 appid 的维度名称
输入 String 类型维度名称:appid
Instances.N.Dimensions.2.Value
appid
实例所属账号的 appid 维度的 ID
输入实例所属账号的 appid 维度名称,例如:appid = 1312364321
Instances.N.Dimensions.3.Name
instanceid
实例 ID 的维度名称
输入 String 类型维度名称:instanceid
Instances.N.Dimensions.3.Value
instanceid
具体的实例 ID
输入具体实例 ID,例如:mssql-dh0123654

入参说明

查询云数据库 SQL Server 监控数据,入参取值如下:
&Namespace = QCE/SQLSERVER
&Instances.N.Dimensions.0.Name = resourceId
&Instances.N.Dimensions.0.Value = 实例的资源 ID
&Instances.N.Dimensions.1.Name = regionid
&Instances.N.Dimensions.1.Value = 实例的地域 ID
&Instances.N.Dimensions.2.Name = appid
&Instances.N.Dimensions.2.Value = 实例所属账号的 appid
&Instances.N.Dimensions.3.Name = instanceid
&Instances.N.Dimensions.3.Value = 实例 ID