Relational Database ServiceRelational Database Service

Compute
Elastic Cloud Server
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
Domain Name Service
VPC Endpoint
Cloud Connect
Enterprise Switch
Security & Compliance
Anti-DDoS
Web Application Firewall
Host Security Service
Data Encryption Workshop
Database Security Service
Advanced Anti-DDoS
Data Security Center
Container Guard Service
Situation Awareness
Managed Threat Detection
Compass
Cloud Certificate Manager
Anti-DDoS Service
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GaussDB NoSQL
GaussDB(for MySQL)
Distributed Database Middleware
GaussDB(for openGauss)
Developer Services
ServiceStage
Distributed Cache Service
Simple Message Notification
Application Performance Management
Application Operations Management
Blockchain
API Gateway
Cloud Performance Test Service
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
DevCloud
ProjectMan
CodeHub
CloudRelease
CloudPipeline
CloudBuild
CloudDeploy
Cloud Communications
Message & SMS
Cloud Ecosystem
Marketplace
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP License Service
Support Plans
Customer Operation Capabilities
Partner Support Plans
Professional Services
enterprise-collaboration
Meeting
IoT
IoT
Intelligent EdgeFabric
DeveloperTools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Updated at: Apr 02, 2022 GMT+08:00

Configuring Displayed Metrics

The RDS Agent monitors RDS DB instances and collects monitoring metrics only.

Description

This section describes the metrics that can be monitored by Cloud Eye as well as their namespaces and dimensions. You can use APIs provided by Cloud Eye to query the monitoring metrics and alarms generated for RDS.

Namespace

SYS.RDS

DB Instance Monitoring Metrics

  • Table 1 lists details about ECS metrics.
    Table 1 ECS performance metrics

    Metric ID

    Name

    Description

    Value Range

    Monitored Object

    Monitoring Interval (Raw Data)

    rds001_cpu_util

    CPU Usage

    CPU usage of the monitored object

    0%–100%

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds003_iops

    IOPS

    Average number of I/O requests processed by the system in a specified period

    ≥ 0 counts/s

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds039_disk_util

    Storage Space Usage

    Storage space usage of the monitored object

    0%–100%

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds002_mem_util

    Memory Usage

    Memory usage of the monitored object

    0%–100%

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds004_bytes_in

    Network Input Throughput

    Incoming traffic in bytes per second

    ≥ 0 bytes/s

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds005_bytes_out

    Network Output Throughput

    Outgoing traffic in bytes per second

    ≥ 0 bytes/s

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds049_disk_read_throughput

    Disk Read Throughput

    Number of bytes read from the disk per second

    ≥ 0 bytes/s

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds050_disk_write_throughput

    Disk Write Throughput

    Number of bytes written into the disk per second

    ≥ 0 bytes/s

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds047_disk_total_size

    Total Storage Space

    Total storage space of the monitored object

    40–4,000 GB

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds048_disk_used_size

    Used Storage Space

    Used storage space of the monitored object

    0–4,000 GB

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds053_avg_disk_queue_length

    Average Disk Queue Length

    Number of processes to be written into the monitored object

    ≥ 0

    Monitored object: ECS

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds054_db_connections_in_use

    Database Connections in Use

    Number of database connections in use

    ≥0 counts

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

  • Table 2 lists the performance metrics of Microsoft SQL Server databases.
    Table 2 Database metrics

    Metric ID

    Name

    Description

    Value Range

    Monitored Object

    Monitoring Interval (Raw Data)

    rds055_transactions_per_sec

    Transactions per Second

    Number of transactions started for the database per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds056_batch_per_sec

    Batches per Second

    Number of Transact-SQL command batches received per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds057_logins_per_sec

    Logins per Second

    Total number of logins started per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds058_logouts_per_sec

    Logouts per Second

    Total number of logouts started per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds059_cache_hit_ratio

    Cache Hit Ratio

    Ratio of pages found in the buffer cache without having to read from the disk to total pages

    0%–100%

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds060_sql_compilations_per_sec

    SQL Compilations per Second

    Number of SQL compilations per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds061_sql_recompilations_per_sec

    SQL Recompilations per Second

    Number of SQL recompilations per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds062_full_scans_per_sec

    Full Scans per Second

    Number of unrestricted full scans per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds063_errors_per_sec

    Errors per Second

    Number of errors per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds064_latch_waits_per_sec

    Latch Waits per Second

    Number of latch requests that have not been granted immediately

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds065_lock_waits_per_sec

    Lock Waits per Second

    Number of lock wait requests per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds066_lock_requests_per_sec

    Lock Requests per Second

    Number of new locks and lock conversions per second requested from the lock manager

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds067_timeouts_per_sec

    Lock Timeouts per Second

    Number of lock timeouts per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds068_avg_lock_wait_time

    Average Lock Wait Time

    Average wait time (ms) of lock requests

    ≥ 0 ms

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds069_deadlocks_per_sec

    Deadlocks per Second

    Number of deadlocks per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds070_checkpoint_pages_per_sec

    Checkpoint Pages per Second

    Number of pages flushed to the disk per second by a checkpoint or other operations that require all dirty pages to be flushed

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    rds077_replication_delay

    Replication Delay

    Delay for replication between primary and standby DB instances. The replication delay of Microsoft SQL Server DB instances is at the database level because data is synchronized on each database. The instance-level replication delay refers to the maximum replication delay of the database (the delay 0s for single DB instances).

    ≥ 0s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    mssql_mem_grant_pending

    Memory Grants Pending

    Total number of processes waiting for a workspace memory grant

    ≥ 0 counts

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    mssql_lazy_write_per_sec

    Lazy Writes per Second

    Number of lazy writes per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    mssql_page_life_expectancy

    Page Life Expectancy

    Number of seconds a page will stay in the buffer pool without references

    ≥ 0s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

    mssql_page_reads_per_sec

    Page Reads per Second

    Number of page reads per second

    ≥ 0 counts/s

    Monitored object: database

    Monitored instance type: Microsoft SQL Server instance

    1 minute

Dimension

Key

Value

rds_instance_sqlserver_id

Microsoft SQL Server DB instance node ID

Did you find this page helpful?

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel