命名空间
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