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 |
Dependency View
The Dependency View tab maps RDS for SQL Server groups based on your customer requirements. Contact support and share your requirements to help us prioritize dependency mapping for the RDS for SQL Server groups in your account.
Common monitored data
Outages
The Outages tab displays outage details, including start time, end time, duration, and related comments, to help track and review downtime events.
Notes
The Notes tab enables you to record descriptions, operational context, runbook steps, recent changes, and reference links to keep your team informed. Format the content using markdown syntax.
Log Report
The Log Report tab provides a unified view of the respective monitor's log status and supports CSV downloads for analysis and auditing.
Alert Logs
The Alert Logs tab provides a comprehensive list of all alerts generated by the monitor. Easily track key details such as the monitored resource name, alert trigger time, root cause, and notification status. Learn more.
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.
