tencent cloud

Tencent Cloud Observability Platform

DocumentationTencent Cloud Observability PlatformCloud Product MonitoringTencent Cloud Service MetricsRelational DatabaseTencentDB for SQL Server Monitoring Metrics

TencentDB for SQL Server Monitoring Metrics

Download
Focus Mode
Font Size
Last updated: 2026-10-27 11:09:36
AI-Translated

Namespace

Namespace = QCE/SQLSERVER

Monitoring Metrics

Note:
After you enable the read-only standby node feature, you can query the monitoring data of the standby node. The monitoring metrics of the standby node are the same as those of the primary instance, and you can refer to the following table for details. To learn how to view the monitoring data of the standby node, see Viewing Monitoring Charts.
Both host-level and process-level monitoring metrics are supported:
Host-level monitoring metrics: monitoring of the machine where the instance is deployed, including the operating system, database main process, and management and control components. Monitoring metrics are displayed as: host + monitoring metric name. For instances with local disk architecture, host-level monitoring metrics reflect the monitoring status of the physical machine where the instance resides. For instances with cloud disk architecture, host-level monitoring metrics reflect the monitoring status of the CVM where the instance resides.
Process-level monitoring metrics: monitoring of the database instance processes. Monitoring metrics are displayed as: Process + monitoring metric name.
The currently configured host-level and process-level monitoring metrics are as follows:
Host-level (local disk architecture): host_avg_disk_queue_length, host_avg_disk_sec_read, host_avg_disk_sec_transfer, host_avg_disk_sec_write, host_disk_writes_sec, host_disk_reads_sec, host_disk_transfers_sec, host_disk_read_bytes_sec, host_disk_write_bytes_sec, and host_disk_throughput_bytes_sec.
Host-level (cloud disk architecture): CPU utilization, memory utilization, disk capacity percentage, used storage space, host_avg_disk_sec_read, host_avg_disk_sec_write, host_disk_read_bytes_sec, host_disk_write_bytes_sec, and host_disk_throughput_bytes_sec.
Instances with local disk and cloud disk architectures support host-level monitoring metrics. For the specific supported monitoring metrics, see Alarm Configuration > Metric in the console.
Process-level: Process CPU Utilization, process_usage_memory, Process Percentage of remaining capacity of the disk, and Process Used Storage. Only cloud disk instances support process-level monitoring metrics. For the specific supported monitoring metrics, see Alarm Configuration > Metric in the console.
Metric Name
Metrics Description
Unit
Dimension
Statistical Rule
[period, statType]
ActualUsedSpace
Total backup
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
AvgDiskQueueLength
Disk queue length
Count
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
AvgDiskSecRead
Read IO Average Response Time
ms
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
AvgDiskSecTransfer
Average IO request response time
ms
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
AvgDiskSecWrite
Write IO average response time
ms
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
BlockedProcesses
Blocked processes
Count
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
BlockedProcessThreshold
Threshold for generating blocked process reports
Count
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
BufferCacheHitRatio
Buffer cache hit ratio
%
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Connections
Number of connections
Count
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Cpu
CPU Utilization
%
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
CrossActualUsedSpace
Cross-region total backup
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
CrossDataBackupSpace
Cross-region data backup
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
CrossFreeSpace
Cross-region free space
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
CrossLogBackupSpace
Cross-region log backup
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
DataBackupSpace
Data backup
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
DiskReads
Disk read quantity
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DiskReadsSec
Disk read IOPS
Count/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DiskTransfersSec
Total IOPS on disk (system-level monitoring for machines deployed with dual-node local disk instances)
Count/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DiskWrites
Disk write count
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
DiskWritesSec
Disk write IOPS
Count/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
FreeSpace
Free space
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
FreeStorage
Remaining disk capacity percentage
%
resourceId
[10s, min]
[60s, min]
[300s, min]
[3600s, min]
[86400s, min]
FullScans
Number of full table scans per second for SQL
times/s
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
InFlow
Input traffic
KB/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Iops
Disk IOPS
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
LatchWaits
Latch waits per second
times/s
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
LockRequests
Lock requests
times/s
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
LockWaits
Average lock wait latency
ms
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
LogBackupSpace
Log backup
KBytes
RegionId
[300s, max]
[3600s, max]
[86400s, max]
Logins
Logins per second
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Logouts
Logouts per second
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
MaxMemory
Max memory
KBytes
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
NetworkIoWaits
Average network IO latency
ms
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
NumberOfDeadlocks
Number of deadlocks
Count/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
OutFlow
Output traffic
KB/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
PlanCacheHitRatio
Execution cache hit ratio
%
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Requests
Number of Requests
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
ServerMemory
Memory utilization
MB
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
SlowQueries
Slow Query
Count
resourceId
[10s, sum]
[60s, sum]
[300s, sum]
[3600s, sum]
[86400s, sum]
SqlCompilations
SQL compilations
times/s
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
SqlRecompilations
SQL recompilations
times/s
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
Storage
Used storage space
GB
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
TotalAllocatedMemory
Memory locked by internal system
KBytes
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
TotalUsedMemory
Internal system memory consumption
KBytes
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
Transactions
Number of Transactions
times/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
UsageMemory
Memory utilization
%
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
UserErrors
User error quantity
times/s
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]
LockTimeoutSec
Number of lock requests that timed out per second, including NOWAIT lock requests.
Count/s
resourceId
[10s, max]
[60s, max]
[300s, max]
[3600s, max]
[86400s, max]
AvgLatchWaitMs
Average waiting time of latch resource requests.
ms
resourceId
[10s, avg]
[60s, avg]
[300s, avg]
[3600s, avg]
[86400s, avg]

Overview of Parameters in Each Dimension

Parameter Name
Dimension name
Dimension Description
Format
Instances.N.Dimensions.0.Name
resourceId
Dimension name of the instance resource ID
Enter a String type dimension name: resourceId.
Instances.N.Dimensions.0.Value
resourceId
Specific resource ID of the instance
Enter the specific resourceId of the instance, for example: mssql-dh0123456.
Instances.N.Dimensions.1.Name
RegionId
Dimension name of the instance region ID
Enter a String type dimension name: RegionId.
Instances.N.Dimensions.1.Value
RegionId
ID of the instance region dimension
Enter a region dimension name, for example: RegionId = ap-guangzhou.

Description of Input Parameters

To query monitoring data of TencentDB for SQL Server, the input parameters are as follows:
&Namespace = QCE/SQLSERVER
&Instances.N.Dimensions.0.Name = resourceId
&Instances.N.Dimensions.0.Value = resource ID of the instance
&Instances.N.Dimensions.1.Name = RegionId
&Instances.N.Dimensions.1.Value = region ID of the instance
Previous Topic: CBSNext Topic: TencentDB for MySQL Monitoring Metrics

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback

Search
    Enter keywords to search documentation