Monitor RDS SQL Server in Huawei Cloud
Site24x7 monitors Huawei Cloud's RDS SQL Server environment, with insights into CPU, memory, disk latency, throughput, connections, and query activity that can help you detect performance issues early and ensure stable database operations.
Use cases
Latency control: Prevent delays in transactions by monitoring disk read/write latency. This allows for early intervention before slow I/O operations impact query performance.
Connection stability: Avoid connection failures by keeping an eye on usage and total connections. This helps in scaling or tuning connection pooling before reaching critical limits.
Workload insight: Detect anomalies by tracking Data Manipulation Language (DML) rates, which helps identify unusual spikes or drops before they compromise data integrity.
Setup and configuration
RDS SQL Server resources are auto-discovered and monitored during the Huawei Cloud integration. To enable monitoring, follow the steps below:
- Navigate to Cloud > Huawei > Add Huawei Monitor. Follow the steps to add a Huawei Cloud monitor.
- While adding or editing a Huawei Cloud monitor, select RDS SQL Server from the Service/Resource Types drop-down and click Save.
- Go to Cloud > Huawei > Select the created Huawei monitor > RDS SQL Server.
Supported metrics
CPU and Memory
Metric name | Description | Units |
| CPU Utilization | The percentage of CPU capacity currently consumed by the RDS SQL Server instance. | Percentage |
| Memory Utilization | The percentage of memory capacity currently consumed by the RDS SQL Server instance. | Percentage |
| Swap Usage | The percentage of swap space currently consumed by the instance. | Percentage |
Network
Metric name | Description | Units |
| Network Input Throughput | The rate of data received by the instance over the network per second. | KB/second |
| Network Output Throughput | The rate of data transmitted out of the instance over the network per second. | KB/second |
Connections
Metric name | Description | Units |
| Total Connections | The total number of connections currently established to the SQL Server instance. | Count |
| Active Connections | The number of connections currently executing a query or operation. | Count |
| Connection Usage | The percentage of available connection capacity currently in use. | Percentage |
Queries and Transactions
Metric name | Description | Units |
| Queries Per Second | The rate of query statements executed on the instance per second. | Count/second |
| Transactions Per Second | The rate of transactions committed on the instance per second. | Count/second |
| Slow Queries | The number of queries that exceeded the configured slow query threshold. | Count |
DML Operations
Metric name | Description | Units |
| Delete Operations | The rate of DELETE operations executed on the instance per second. | Count/second |
| Insert Operations | The rate of INSERT operations executed on the instance per second. | Count/second |
| Select Operations | The rate of SELECT operations executed on the instance per second. | Count/second |
| Update Operations | The rate of UPDATE operations executed on the instance per second. | Count/second |
Disk and IO
Metric name | Description | Units |
| IOPS | The number of read and write I/O operations processed by the disk per second. | Count/second |
| Disk Utilization | The percentage of total disk storage currently consumed by the instance. | Percentage |
| Disk Total Size | The total disk storage capacity provisioned for the instance. | GB |
| Disk Used Size | The total disk storage currently consumed by the instance. | GB |
| Disk Read Throughput | The rate of data read from disk per second. | Bytes/second |
| Disk Write Throughput | The rate of data written to disk per second. | Bytes/second |
| Avg Disk Read Latency | The average time taken to complete a single disk read operation. | ms |
| Avg Disk Write Latency | The average time taken to complete a single disk write operation. | ms |
| VM I/O Utilization | The percentage of VM-level I/O capacity currently in use. | Percentage |
Threshold configuration
You can configure thresholds and alerts for all RDS SQL Server metrics to proactively detect performance degradation or connection issues.
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit your Threshold Profile for RDS SQL Server.
- Assign the profile to the respective monitors to trigger alerts.
IT Automation
Use Site24x7's IT Automation to resolve common issues with RDS SQL Server performance:
- Go to Admin > IT Automation Templates. Then, click Add Automation Templates.
- Create an automation rule by selecting the automation Type (e.g., Server reboot, clear queue).
- Map the created rules to the RDS SQL Server, for automatic execution during alerts.
Configuration rules
Use Configuration Rules to simplify bulk setup across RDS SQL Server instances. Automatically assign Threshold Profiles, Notification Profiles, Tags, and Monitor Groups when new monitors are discovered.