Alibaba Cloud RDS for SQL Server Monitoring Integration
Site24x7 offers comprehensive monitoring for Alibaba Cloud RDS for SQL Server, providing insights into query throughput, locking behavior, disk I/O, and buffer cache performance. When you integrate your Alibaba Cloud account with Site24x7, all RDS for SQL Server instances are automatically discovered and monitored.
Use cases
- Performance optimization: Track CPU load, QPS/TPS rates, and buffer cache efficiency to detect and fix bottlenecks.
- Lock analysis: Identify lock waits, deadlocks, and timeouts to optimize transaction concurrency.
- Storage monitoring: Observe disk utilization and checkpoint page activity to prevent I/O overloads.
- Network visibility: Monitor network throughput to detect communication delays and potential saturation.
- Automation and alerts: Set thresholds and automate corrective actions for performance anomalies.
Setup and configuration
- Log in to your Site24x7 account and navigate to Cloud > Alibaba Cloud > Add Monitor.
- In the Edit Alibaba Cloud Monitor page, select RDS for SQL Server from the Service Types list.
- Once added, go to Cloud > Alibaba > RDS for SQL Server to view dashboards and performance metrics.
Supported metrics
Performance
| Metric name | Description | Unit |
|---|---|---|
| SQL Server CPU Usage | The percentage of CPU utilization for the SQL Server instance. | Percentage |
| SQL Server QPS | The number of queries executed per second. | Count/second |
| SQL Server TPS | The number of transactions processed per second. | Count/second |
Cache & Buffer
| Metric name | Description | Unit |
|---|---|---|
| SQL Server Cache Hit Ratio | The percentage of pages found in the cache without reading from disk. | Percentage |
| SQL Server Buffer Cache Hit Ratio | The ratio of SQL Server buffer cache hits to total lookups. | Percentage |
| SQL Server Lazy Writes/sec | The number of lazy writes to disk per second. | Count/second |
Locking & Deadlock
| Metric name | Description | Unit |
|---|---|---|
| SQL Server Lock Waits/sec | The number of lock requests per second that had to wait. | Count/second |
| SQL Server Deadlocks/sec | The number of deadlocks detected per second. | Count/second |
| SQL Server Lock Timeouts/sec | The number of lock requests per second that timed out. | Count/second |
Network
| Metric name | Description | Unit |
|---|---|---|
| SQL Server Network Read | The total number of bytes read from the network. | Bytes/second |
| SQL Server Network Write | The total number of bytes written to the network. | Bytes/second |
| SQL Server Network In | The inbound network throughput of the SQL Server instance. | Bytes/second |
| SQL Server Network Out | The outbound network throughput of the SQL Server instance. | Bytes/second |
Connection & Session
| Metric name | Description | Unit |
|---|---|---|
| SQL Server Logins/sec | The number of logins processed per second. | Count/second |
| SQL Server Logouts/sec | The number of logouts processed per second. | Count/second |
| SQL Server Total Connections | The total number of active connections to the SQL Server instance. | Count |
Disk & I/O
| Metric name | Description | Unit |
|---|---|---|
| SQL Server IOPS | The number of input/output operations per second performed by SQL Server. | Count/second |
| SQL Server Disk Usage | The percentage of disk space utilized by the SQL Server instance. | Percentage |
| SQL Server Checkpoint Pages/sec | The number of pages flushed to disk during checkpoints per second. | Count/second |
Query Execution
| Metric name | Description | Unit |
|---|---|---|
| SQL Server SQL Compilations | The number of SQL statement compilations per second. | Count/second |
| SQL Server Full Scans | The number of full table or index scans per second. | Count/second |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for RDS for SQL Server.
- Assign the profile to the respective monitors to trigger alerts.
IT automation
Site24x7's IT Automation tools help with automatically resolving performance degradation issues. When a breach occurs, the alarm engine continuously examines the system events for which thresholds have been defined and performs the mapped automation.
- Go to Admin > IT Automation Templates.
- Create a new automation rule.
- Map the rule to the monitor for proactive resolution.
How to configure IT Automation for a monitor
Configuration rules
With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors and automate the configuration settings of your monitoring resources. Automatically assign these settings when new RDS for SQL Server monitors are added.
How to add a Configuration Rule