Tencent Cloud

Recent Pages

Monitoring Metrics

Last updated: 2024-07-30 16:09:09

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 (for system-level monitoring of machines deployed with dual-node local disk instances)
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

Contact Us

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

Technical Support

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

7x24 Phone Support

tencent cloud

Recent Pages

Monitoring Metrics

Monitoring Metrics

Was this page helpful?

Was this page helpful?

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 (for system-level monitoring of machines deployed with dual-node local disk instances)
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

tencent cloud

Sign Up

Log in

Recent Pages

Monitoring Metrics

Monitoring Metrics

Was this page helpful?

Was this page helpful?