有奖捉虫:云通信与企业服务文档专题,速来> HOT

命名空间

Namespace = QCE/SQLSERVER

监控指标

指标英文名
指标中文名
指标说明
单位
维度
统计规则 [period, statType]
ActualUsedSpace
总备份
总备份
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
AvgDiskQueueLength
磁盘队列长度
磁盘队列长度
Count
resourceId
[60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
AvgDiskSecRead
读 IO 平均响应时间
读 IO 平均响应时间
ms
resourceId
[60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
AvgDiskSecTransfer
IO 请求平均响应时间
IO 请求平均响应时间
ms
resourceId
[60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
AvgDiskSecWrite
写 IO 平均响应时间
写 IO 平均响应时间
ms
resourceId
[60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
BlockedProcesses
阻塞数
阻塞数
Count
resourceId
[10s, avg] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
BlockedProcessThreshold
阻塞报告生成阀值
阻塞报告生成阀值
Count
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
BufferCacheHitRatio
缓冲区缓存命中率
缓冲区缓存命中率
%
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
Connections
连接数
连接数
Count
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
Cpu
核心数
CPU 利用率
%
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
CrossActualUsedSpace
跨地域总备份
跨地域总备份
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
CrossDataBackupSpace
跨地域数据备份
跨地域数据备份
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
CrossFreeSpace
跨地域免费空间
跨地域免费空间
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
CrossLogBackupSpace
跨地域日志备份
跨地域日志备份
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
DataBackupSpace
数据备份
数据备份
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
DiskReads
读取磁盘次数
读取磁盘次数
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
DiskReadsSec
磁盘每秒读 IO 数量
磁盘每秒读 IO 数量
Count/s
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
DiskTransfersSec
磁盘 IOPS 总数
磁盘 IOPS 总数
Count/s
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
DiskWrites
写入磁盘次数
写入磁盘次数
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
DiskWritesSec
磁盘每秒写 IO 数量
磁盘每秒写 IO 数量
Count/s
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
FreeSpace
免费空间
免费空间
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
FreeStorage
硬盘剩余容量百分比
硬盘剩余容量百分比
%
resourceId
[10s, min] [60s, min] [300s, min] [3600s, min] [86400s, min]
FullScans
每秒钟 SQL 做全表扫描数目
每秒钟 SQL 做全表扫描数目
times/s
resourceId
[10s, avg] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
InFlow
输入流量
输入流量
KB/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
Iops
磁盘 IOPS
磁盘 IOPS
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
LatchWaits
每秒闩锁等待数量
每秒闩锁等待数量
times/s
resourceId
[10s, avg] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
LockRequests
锁请求次数
锁请求次数
times/s
resourceId
[10s, avg] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
LockWaits
平均锁等待延迟
平均锁等待延迟
ms
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
LogBackupSpace
日志备份
日志备份
KBytes
RegionId
[300s, max] [3600s, max] [86400s, max]
Logins
每秒登录次数
每秒登录次数
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
Logouts
每秒登出次数
每秒登出次数
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
MaxMemory
最大内存
最大内存
KBytes
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
NetworkIoWaits
平均网络 IO 延迟
平均网络 IO 延迟
ms
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
NumberOfDeadlocks
死锁数
死锁数
Count/s
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
OutFlow
输出流量
输出流量
KB/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
PlanCacheHitRatio
执行缓存缓存命中率
执行缓存缓存命中率
%
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
Requests
请求数
请求数
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
ServerMemory
内存使用
内存占用
MB
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
SlowQueries
慢查询
慢查询
Count
resourceId
[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]
SqlRecompilations
SQL 重编译数
SQL 重编译数
times/s
resourceId
[10s, avg] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]
Storage
已用存储空间
已用存储空间
GB
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
TotalAllocatedMemory
内部系统锁定内存
内部系统锁定内存
KBytes
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
TotalUsedMemory
内部系统消耗内存
内部系统消耗内存
KBytes
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
Transactions
事务数
事务数
times/s
resourceId
[10s, max] [60s, max] [300s, max] [3600s, max] [86400s, max]
UsageMemory
内存使用率
内存使用率
%
resourceId
[60s, max] [300s, max] [3600s, max] [86400s, max]
UserErrors
用户错误数
用户错误数
times/s
resourceId
[10s, avg] [60s, avg] [300s, avg] [3600s, avg] [86400s, avg]

各维度对应参数总览

参数名称
维度名称
维度解释
格式
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

入参说明

查询云数据库 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