RDS for SQL Server Metrics
Description
This section describes namespaces, descriptions, and dimensions of metrics reported by RDS for SQL Server to Cloud Eye. You can use APIs provided by Cloud Eye to retrieve metrics and alarms generated for RDS for SQL Server.
Namespace
SYS.RDS
Metrics
Metric ID |
Name |
Description |
Value Range |
Monitored Object and Instance Type |
---|---|---|---|---|
rds001_cpu_util |
CPU Usage |
CPU usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds002_mem_util |
Memory Usage |
Memory usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
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: RDS for SQL Server instance |
rds004_bytes_in |
Network Input Throughput |
Incoming traffic in bytes per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds005_bytes_out |
Network Output Throughput |
Outgoing traffic in bytes per second |
≥ 0 bytes/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds039_disk_util |
Storage Space Usage |
Storage space usage of the monitored object |
0–100% |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds047_disk_total_size |
Total Storage Space |
Total storage space of the monitored object |
40–4000, in GB |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds048_disk_used_size |
Used Storage Space |
Used storage space of the monitored object |
0–4000, in GB |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
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: RDS for SQL Server instance |
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: RDS for SQL Server instance |
rds053_avg_disk_queue_length |
Average Disk Queue Length |
Number of processes to be written into the monitored object |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds054_db_connections_in_use |
Database Connections in Use |
Number of database connections in use |
≥ 0 counts |
Monitored object: database Monitored instance type: RDS for SQL Server instance |
rds055_transactions_per_sec |
Transactions per Second |
Number of transactions started for the database per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds056_batch_per_sec |
Batches per Second |
Number of Transact-SQL command batches received per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds057_logins_per_sec |
Logins per Second |
Total number of logins started per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds058_logouts_per_sec |
Logouts per Second |
Total number of logouts started per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
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: ECS Monitored instance type: RDS for SQL Server instance |
rds060_sql_compilations_per_sec |
SQL Compilations per Second |
Number of SQL compilations per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds061_sql_recompilations_per_sec |
SQL Recompilations per Second |
Number of SQL recompilations per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds062_full_scans_per_sec |
Full Scans per Second |
Number of unrestricted full scans per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds063_errors_per_sec |
Errors per Second |
Number of errors per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds064_latch_waits_per_sec |
Latch Waits per Second |
Number of latch requests that have not been granted immediately |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds065_lock_waits_per_sec |
Lock Waits per Second |
Number of lock wait requests per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
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: ECS Monitored instance type: RDS for SQL Server instance |
rds067_timeouts_per_sec |
Lock Timeouts per Second |
Number of lock timeouts per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds068_avg_lock_wait_time |
Average Lock Wait Time |
Average wait time (ms) of lock requests |
≥ 0 ms |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
rds069_deadlocks_per_sec |
Deadlocks per Second |
Number of deadlocks per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
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: ECS Monitored instance type: RDS for SQL Server instance |
rds077_replication_delay |
Replication Delay |
Delay for replication between primary and standby DB instances. The replication delay of RDS for 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 databases (the delay 0s for single-node DB instances). |
≥ 0s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
mssql_mem_grant_pending |
Memory Grants Pending |
Total number of processes waiting for a workspace memory grant |
≥ 0 counts |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
mssql_lazy_write_per_sec |
Lazy Writes per Second |
Number of lazy writes per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
mssql_page_life_expectancy |
Page Life Expectancy |
Number of seconds a page will stay in the buffer pool without references |
≥ 0s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
mssql_page_reads_per_sec |
Page Reads per Second |
Number of page reads per second |
≥ 0 counts/s |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
mssql_tempdb_disk_size |
Temporary Tablespace Size |
Disk space occupied by the current temporary tablespace |
≥ 0 MB |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
mssql_worker_threads_usage_rate |
Usage of Worker Threads |
Ratio of the total worker threads to the value of Max Worker Threads |
0–100% |
Monitored object: ECS Monitored instance type: RDS for SQL Server instance |
Dimension
Key |
Value |
---|---|
rds_cluster_sqlserver_id |
RDS for SQL Server instance ID |
API Calling
Use APIs to search for RDS monitoring metrics. For details about calling methods and parameter description, see Querying Monitoring Data in the Cloud Eye API Reference.
Examples:
- Request
/V1.0/{project_id}/metric-data?namespace=SYS.RDS&metric_name=rds001_cpu_util&dim.0=rds_cluster_id,5ea170ad-cc6b-49cd-9020-e94fdbeea391&from=1484123686000&to=1568188853000&period=300&filter=average
- Response:
{ "datapoints": [ { "average": 0.35, "timestamp": 1484123400000, "unit": "Ratio" }, { "average": 0.11, "timestamp": 1484123700000, "unit": "Ratio" } ], "metric_name": "rds001_cpu_util", "httpcode" : 200, "header" : { "Transfer-Encoding" : "chunked", "Server" : "Web Server", "X-Request-Id" : "te-I-CES-APISVR25.id-0418d62a-1e76-46ff-9a5f-9ce40b336e29.ts-1484123744291.c-15046", "X-Content-Type-Options" : "nosniff", "Connection" : "keep-alive", "X-Download-Options" : "noopen", "Date" : "Wed, 11 Jan 2017 08:35:44 GMT", "X-Frame-Options" : "DENY", "Strict-Transport-Security" : "max-age=31536000; includeSubdomains;", "Cache-Control" : "no-cache", "X-XSS-Protection" : "1; mode=block;", "Content-Length" : "165", "Content-Type" : "application/json" } }
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot