tencent cloud

TencentDB for SQL Server

Release Notes and Announcements
Release Notes
Product Announcements
User Guide
Product Introduction
Overview
Product Architecture
Strengths
Use Cases
Regions and AZs
Major Version Lifecycle Explanation
Features and Differences
Instance Types
Instance Specifications
Storage Types
Common Concepts
Network Environment
License Statement
Purchase Guide
Billing Overview
Product Pricing
Purchase Methods
Renewal Instructions
Payment Overdue
Refund
From Pay-as-You-Go to Monthly Subscription
Instance Adjustment Fees Description
Local Backup Space Billing
Cross-Region Backup Billing
Viewing Bill Details
Getting Started
Creating TencentDB for SQL Server Instance
Connecting to TencentDB for SQL Server Instance
Managing TencentDB for SQL Server Instance
Operation Guide
Constraints and Limits
Usage Specifications and Suggestions
Maintaining Instance
Adjusting Instance Configuration
Read-Only Instance
Network and Security
Account Management
Database Management
Data Security
Parameter Configuration
Monitoring and Alarms
Backup and Restoration 
Log Management
Publish-Subscribe
SSIS
Data Migration (New)
Data Migration (Legacy)
Data Synchronization (DTS) 
Practical Tutorial
TencentDB for SQL Server Methods for Regular Maintenance
TencentDB for SQL Server Optimization of Slow SQL
How to Better Use Tempdb
Cross-Account Backup Restoration
Creating VPC for TencentDB for SQL Server
Connecting Kingdee K/3 WISE to TencentDB for SQL Server
Account Permissions and Permission Control
Enabling and Disabling the CDC Feature
Shrinking a Database
API Documentation
History
Introduction
API Category
Making API Requests
Sales and fee related APIs
Instance Management related APIs
Operation and maintenance management related APIs
Network management related APIs
Account management related APIs
Database management related APIs
Security group management related APIs
Data security encryption related APIs
Parameter configuration related APIs
Extended Event related APIs
Log management related APIs
Read only instance management related APIs
Publish and subscribe related APIs
Backup related APIs
Rollback related APIs
Data migration (cold standby migration) related APIs
SQL Server Integration Services (SSIS) related APIs
Data migration (DTS old version) related APIs
Data Types
Error Codes
FAQs
Overview
Model Selection
Pricing and Selection
Connection and Network
Account and Permission
Backup and Rollback
Data Migration
Publish/Subscribe
Read-Only Instance
Version and Architecture Upgrade
Disk Space and Specification Adjustment
Monitoring and Alarms
Log-Related
Parameter Modification
Features
Performance, Space, and Memory-Related FAQs
Service Agreement
Service Level Agreement
Terms of Service
Performance Evaluation
Performance Test Report
Glossary
Contact Us

Monitoring Metrics

PDF
フォーカスモード
フォントサイズ
最終更新日: 2025-12-03 10:43:49
This document describes the common monitoring metrics supported by TencentDB for SQL Server.

Monitoring Metrics

TencentDB for SQL Server supports monitoring 45 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.
When you obtain the monitoring data via API calls, see TencentDB for SQL Server Monitoring Metrics for the monitoring metric names used in parameters.
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
KBytes
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.
Total XTP memory usage
KBytes/s
Usage of the XTP memory-optimized temporary table.
Storage
Disk Throughput
KBytes/s
The total size of data written and read to the disk per second
Disk Read Traffic
KBytes/s
Amount of data read from disk to memory per second
Disk Write Traffic
KBytes/s
Amount of data written from memory to disk per second
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
Proportion of remaining disk 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
Count/s
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
Count/s
Number of write IOs per second on disk (for system-level monitoring of machines deployed with dual-node local disk instances)
Total Disk IOPS
Count/s
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
s
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
Count/s
Number of lock requests causing deadlocks per second
Blocking Report Generation Threshold
Count
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.
Number of lock timeouts per second
Count/s
Number of lock requests that timed out per second, including NOWAIT lock requests.
Latch wait delay
ms
Average waiting time of latch resource requests.
Others
Number of User Errors
Times/sec
Average number of errors per second

ヘルプとサポート

この記事はお役に立ちましたか?

フィードバック