tencent cloud

Tencent Cloud Observability Platform

Release Notes and Announcements
Release Notes
Product Introduction
Overview
Strengths
Basic Features
Basic Concepts
Use Cases
Use Limits
Purchase Guide
Tencent Cloud Product Monitoring
Application Performance Management
Mobile App Performance Monitoring
Real User Monitoring
Cloud Automated Testing
Prometheus Monitoring
Grafana
EventBridge
PTS
Quick Start
Monitoring Overview
Instance Group
Tencent Cloud Product Monitoring
Application Performance Management
Real User Monitoring
Cloud Automated Testing
Performance Testing Service
Prometheus Getting Started
Grafana
Dashboard Creation
EventBridge
Alarm Service
Cloud Product Monitoring
Tencent Cloud Service Metrics
Operation Guide
CVM Agents
Cloud Product Monitoring Integration with Grafana
Troubleshooting
Practical Tutorial
Application Performance Management
Product Introduction
Access Guide
Operation Guide
Practical Tutorial
Parameter Information
FAQs
Mobile App Performance Monitoring
Overview
Operation Guide
Access Guide
Practical Tutorial
Tencent Cloud Real User Monitoring
Product Introduction
Operation Guide
Connection Guide
FAQs
Cloud Automated Testing
Product Introduction
Operation Guide
FAQs
Performance Testing Service
Overview
Operation Guide
Practice Tutorial
JavaScript API List
FAQs
Prometheus Monitoring
Product Introduction
Access Guide
Operation Guide
Practical Tutorial
Terraform
FAQs
Grafana
Product Introduction
Operation Guide
Guide on Grafana Common Features
FAQs
Dashboard
Overview
Operation Guide
Alarm Management
Console Operation Guide
Troubleshooting
FAQs
EventBridge
Product Introduction
Operation Guide
Practical Tutorial
FAQs
Report Management
FAQs
General
Alarm Service
Concepts
Monitoring Charts
CVM Agents
Dynamic Alarm Threshold
CM Connection to Grafana
Documentation Guide
Related Agreements
Application Performance Management Service Level Agreement
APM Privacy Policy
APM Data Processing And Security Agreement
RUM Service Level Agreement
Mobile Performance Monitoring Service Level Agreement
Cloud Automated Testing Service Level Agreement
Prometheus Service Level Agreement
TCMG Service Level Agreements
PTS Service Level Agreement
PTS Use Limits
Cloud Monitor Service Level Agreement
API Documentation
History
Introduction
API Category
Making API Requests
Monitoring Data Query APIs
Alarm APIs
Legacy Alert APIs
Notification Template APIs
TMP APIs
Grafana Service APIs
Event Center APIs
TencentCloud Managed Service for Prometheus APIs
Monitoring APIs
Data Types
Error Codes
Glossary

TencentDB for SQL Server Monitoring Metrics

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2024-01-27 17:44:47

Namespace

Namespace=QCE/SQLSERVER

Monitoring Metrics

Common metrics

Parameter
Metric Name
Description
Unit
Dimension
Cpu
CPU utilization
Percentage of instance CPU usage
%
resourceId
Transactions
Number of transactions
Average number of transactions per second
Times/sec
resourceId
Connections
Number of connections
Average number of databases connected by users per second
Count
resourceId
Requests
Number of requests
Number of requests per second
Times/sec
resourceId
Logins
Number of logins
Number of logins per second
Times/sec
resourceId
Logouts
Number of logouts
Number of logouts per second
Times/sec
resourceId
Storage
Used storage
Sum of storage space consumed by instance database files and log files
GB
resourceId
InFlow
Inbound traffic
Sum of inbound packet sizes for all connections
KB/s
resourceId
OutFlow
Outbound traffic
Sum of outbound packet sizes for all connections
KB/s
resourceId
Iops
Disk IOPS
Disk read/write operations per second
Times/sec
resourceId
DiskReads
Number of disk reads
Number of disk reads per second
Times/sec
resourceId
DiskWrites
Number of disk writes
Number of disk writes per second
Times/sec
resourceId
ServerMemory
Memory usage
Actual memory usage
MB
resourceId

Performance optimization metrics

Parameter
Metric Name
Description
Unit
Dimension
SlowQueries
Slow queries
Number of slow queries with a running time greater than one second
Count
resourceId
BlockedProcesses
Number of blocked processes
Number of currently blocked processes
Count
resourceId
LockedRequests
Number of lock requests
Average number of lock requests per second
Times/sec
resourceId
UserErrors
Number of user errors
Average number of user errors per second
Times/sec
resourceId
SqlCompilations
Number of SQL compilations
Average number of SQL compilations per second
Times/sec
resourceId
SqlRecompilations
Number of SQL recompilations
Average number of SQL recompilations per second
Times/sec
resourceId
FullScans
Number of full-table scans for SQL per second
Number of full scans without limitations per second
Times/sec
resourceId
BufferCacheHitRatio
Buffer cache hit rate
Data cache (memory) hit rate
%
resourceId
LatchWaits
Number of latch waits
Number of latch waits per second
Times/sec
resourceId
LockWaits
Average latency on a lock wait
Average wait time of each lock request resulting in lock wait
ms
resourceId
NetworkIoWaits
I/O wait time
Average network I/O wait time
ms
resourceId
PlanCacheHitRatio
Plan cache hit rate
The hit rate of a plan. Each SQL statement has a plan with a hit rate
%
resourceId
FreeStorage
Residual capacity of the hard disk
Percentage of the residual capacity of the hard disk
%
resourceId
Note:
The statistical granularity (period) may vary by metric. The DescribeBaseMetrics API can be used to obtain the period supported by each metric.

Overview of the 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, such as resourceId
Instances.N.Dimensions.0.Value
resourceId
A specific instance resource ID
Enter a specific instance resource ID, such as mssql-dh0123456

Input Parameters

To query the monitoring data of TencentDB for SQL Server, use the following input parameters: &Namespace=QCE/SQLSERVER &Instances.N.Dimensions.0.Name=resourceId &Instances.N.Dimensions.0.Value=Instance resource ID

Ajuda e Suporte

Esta página foi útil?

comentários