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