云服务器特惠 99/年起
  1. 腾讯云优惠网首页
  2. 腾讯云产品

腾讯云可观测平台 云数据库 SQL Server 监控指标

• 腾讯云产品

这篇说说了腾讯云数据库 SQL Server 的监控数据查询相关内容，包括命名空间、监控指标及各维度对应参数总览、入参说明。入参说明: 查询云数据库 SQL Server 监控数据的入参取值，如 Namespace 为 QCE/SQLSERVER ，Instances.N.Dimensions.0.Name 为 resourceId 及其对应值为实例的资源 ID ，Instances.N.Dimensions.1.N。

相关产品
腾讯云可观测平台 产品页，含版本规格、价格与购买入口。

一、命名空间

Namespace = QCE/SQLSERVER

二、监控指标

注意：说明：

指标名 指标中文名 指标说明 单位 维度 统计规则
[period, statType]
ActualUsedSpace 总备份 总备份 KBytes RegionId [300s, max]
[3600s, max]
[86400s, max]
AvgDiskQueueLength 磁盘队列长度 磁盘队列长度 Count resourceId [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]
AvgDiskSecTransfer IO 请求平均响应时间 IO 请求平均响应时间 ms resourceId [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]
BlockedProcesses 阻塞数 阻塞数 Count resourceId [10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
BlockedProcessThreshold 阻塞报告生成阀值 阻塞报告生成阀值 Count resourceId [10s, avg][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 [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]
DiskWrites 写入磁盘次数 写入磁盘次数 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]
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 [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]
NumberOfDeadlocks 死锁数 死锁数 Count/s resourceId [10s, max][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 [10s, max][60s, max][300s, max][3600s, max][86400s, max]
TotalUsedMemory 内部系统消耗内存 内部系统消耗内存 KBytes resourceId [10s, max][60s, max][300s, max][3600s, max][86400s, max]
Transactions 事务数 事务数 times/s resourceId [10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
UsageMemory 内存使用率 内存使用率 % resourceId [10s, max][60s, max][300s, max][3600s, max][86400s, max]
UserErrors 用户错误数 用户错误数 times/s resourceId [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]
AvgLatchWaitMs 闩锁等待延迟 请求闩锁资源的平均等待时间 ms 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

相关内容：

  1. 腾讯云可观测平台 云数据库 PostgreSQL 监控指标 这篇列出腾讯云PostgreSQL实例的监控指标，包括活跃连接数、CPU利用率、QPS、存储空间等，并说明各指标的单位、维度和统计规则，用于监控实例性能与健康状态。 - 核心指标：涵盖连接数、CPU、内存、存储、QPS、TPS等关键性能指标。 - 统计规则：每个指标支持多种统计粒度（如5秒、60秒、300秒）和统计类型（如first、max、sum）。 - 入参说明：查询监控数据需指定Namespace为QCE/PO。...
  2. 腾讯云可观测平台 腾讯云数据仓库 TCHouse-P 监控指标 &Instances.N.Dimensions.0.Name=ClusterName&Instances.N.Dimensions.0.Value=集群 id。...
  3. 腾讯云可观测平台 云数据库 MariaDB 监控指标 云数据库 MariaDB 监控指标入参说明如下&Namespace=QCE/MARIADB &Instances.N.Dimensions.0.Name= InstanceId &Instances.N.Dimensions.0.Value=具体实例 ID &Instances.N.Dimensions.1.Name=NodeId &Instances.N.Dimensions.1.Value=具体节点 ID。...
  4. 腾讯云可观测平台 向量存储桶 COS Vectors 监控指标 这篇说说腾讯云向量存储桶（QCE/COSVECTORS）的监控指标与查询参数，涵盖容量、向量数、请求数、时延、QPS等指标，并说明按appid、bucket、index维度入参查询的方法。 - 指标分桶级与索引级两类，统计周期含60s至86400s。 - 查询需指定Namespace及appid、bucket、index三个维度。...
  5. 腾讯云可观测平台 云数据库 MongoDB 监控指标 这篇是关于腾讯云 MongoDB 监控指标的介绍，涵盖了命名空间、不同类型的监控指标及各维度对应参数、入参说明等内容。包括 MongoDB、MongoDB 副本集、Mongod 节点、Mongos 节点的各类监控指标，还说明了云数据库不同查询维度及相关参数取值，并介绍了查询监控数据的入参设定。监控指标分类: 详细列举了 MongoDB 的请求类、时延请求类等多种监控指标类别，以及副本集和 Mongod 节点的相关指标。...
  6. 腾讯云可观测平台 云开发 CloudBase 监控指标 这里说明了腾讯云云开发 CloudBase 的监控指标相关内容，包括命名空间及不同数据（版本、服务、环境）查询的入参说明。入参说明: 详细说明了查询云开发 CloudBase 版本数据、服务数据和环境数据时入参的取值方式，包括命名空间固定为“QCE/TCB_DOCKER”，以及维度名称和对应的具体值（如具体环境 ID、具体版本 ID、具体服务号等）。...
  7. 腾讯云可观测平台 游戏数据库 TcaplusDB 监控指标 查询游戏数据库 TcaplusDB 监控数据，入参取值如下： &Namespace=QCE/TCAPLUS &Instances.N.Dimensions.0.Name=TableInstanceId &Instances.N.Dimensions.0.Value=数据库的具体 ID &Instances.N.Dimensions.1.Name=ClusterId &Instances.N.Dimensions.1.。...
  8. 腾讯云可观测平台 云 HDFS 监控指标 &Namespace =QCE/CHDFS &Instances.N.Dimensions.0.Name = appid &Instances.N.Dimensions.0.Value = 主账号的 APPID &Instances.N.Dimensions.1.Name = filesystemid &Instances.N.Dimensions.1.Value = 具体文件系统 ID。...
赞 (0)
上一篇 5天前
下一篇 5天前