tencent cloud

All product documents
TencentDB for SQL Server
DocumentationTencentDB for SQL ServerOperation GuideMonitoring and AlarmsMonitoring Metrics
Monitoring Metrics
Download PDF
Last updated: 2025-02-27 10:41:50
Monitoring Metrics
Last updated: 2025-02-27 10:41:50
Download PDF
This document describes the common monitoring metrics supported by TencentDB for SQL Server.

Monitoring Metrics

TencentDB for SQL Server supports monitoring 43 common metrics of SQL Server. You can collect statistics of other metrics by configuring the performance counters of SQL Server Management Studio (SSMS).
Note:
To view monitoring metrics at the system level, contact us.
Classification
Metric Name
Unit
Descriptions
CPU
CPU Usage
%
Percentage of actual CPU consumption
Note：
When the user's business QPS is less than 5 or there is no business database, the CPU will be displayed as 0.
For instances with cloud disk architecture, the CPU metrics are collected from the CPU of the machine where the instance is deployed. In cases of smaller specifications (such as 2C or 4C), there may be some fluctuations.
Memory
Memory Usage
MB
Total memory usage
Max Memory
KB
Max memory
Memory Usage Rate
%
Memory usage rate
Internal System Locked Memory
KBytes
Internal system locked memory
This monitoring metric can be viewed only in 2014 and later versions.

Internal System Consumed Memory
KBytes
Internal system consumed memory
This monitoring metric can be viewed only in 2014 and later versions.

Storage
Disk Throughput
KBytes/s
The total size of data written and read to the disk per second (for monitoring machines deployed with dual node cloud disk instances)
Disk Read Traffic
KBytes/s
Amount of data read from disk to memory per second (for monitoring machines deployed with dual node cloud disk instances)
Disk Write Traffic
KBytes/s
Amount of data written from memory to disk per second (for monitoring machines deployed with dual node cloud disk instances)
Disk IOPS
Times/sec
Number of disk read and write times
Number of Disk Read Times
Times/sec
Number of disk read times per second
Number of Disk Write Times
Times/sec
Number of disk write times per second
Used Storage
GB
Sum of storage space consumed by instance database files and log files
Remaining Storage Space
%
Percentage of remaining hard disk capacity, calculated as: (Purchased disk - Used storage space) / Purchased disk
Read IO Average Response Time
ms
The average time required to read data from the disk, measured in seconds, for monitoring the machines deployed with two-node cloud disk instances and system-level monitoring of machines deployed with two-node local disk instances.
Write IO Average Response Time
ms
The average time required to write data to the disk, measured in seconds, for monitoring the machines deployed with two-node cloud disk instances and system-level monitoring of machines deployed with two-node local disk instances.
IO Request Average Response Time
ms
Average response time per IO request (for system-level monitoring of machines deployed with dual node local disk instances)
Number of Read IOs Per Second on Disk
Times/sec
Number of read IOs per second on disk (for system-level monitoring of machines deployed with dual node local disk instances)
Number of Write IOs Per Second on Disk
Times/sec
Number of write IOs per second on disk (for system-level monitoring of machines deployed with dual-node local disk instances)
Total Disk IOPS
Times/sec
Total IOPS on disk (for system-level monitoring of machines deployed with dual-node local disk instances)
Disk Queue Length
Count
Disk queue length
Network
Inbound Traffic
KB/s
Sum of inbound packet sizes for all connections
Outbound Traffic
KB/s
Sum of outbound packet sizes for all connections
Average Network I/O Delay
ms
Average network I/O delay time
RO Sync Delay Time
Sec
Data sync delay time between primary instances and read-only instances
Connection
Number of Connections
Connections
Average number of databases connected by users per second
Number of Logins Per Second
Times/sec
Number of logins per second
Number of Logouts Per Second
Times/sec
Number of logouts per second
Access
Slow Queries
Queries
Number of queries running longer than one second
Number of Requests
Times/sec
Average number of requests per second
Number of SQL Compilations
Times/sec
Average number of SQL compilations per second
Number of SQL Recompilations
Times/sec
Average number of SQL recompilations per second
Number of Full-Table Scans for SQL Per Second
Times/sec
Number of full-table scans for SQL per second
Number of Transactions
Times/sec
Average number of transactions per second
Number of Blockings
Blockings
Number of current blockings
Execution Cache Hit Rate
%
Each SQL statement has an execution plan, the hit rate of the execution plan.
Buffer Cache Hit Rate
%
Data cache (memory) hit rate
Lock
Number of Lock Requests
Times/sec
Average number of lock requests per second
Number of Latch Waits Per Second
Times/sec
Number of latch waits per second
Average Latency on a Lock Wait
Ms
Average wait time of each lock request resulting in wait
Number of Deadlocks
Number/sec
Number of lock requests causing deadlocks per second
Blocking Report Generation Threshold
Minute
The specified threshold for generating blocking reports. If the threshold is exceeded, a blocked process report will be generated. By default, blocking process reports are not generated.
Others
Number of User Errors
Times/sec
Average number of errors per second
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon