Troubleshooting SQL Server query performance on Amazon RDS

A complete DBA workflow for troubleshooting T-SQL query performance degradation on Amazon RDS for SQL Server using three integrated tools. CloudWatch Database Insights detects high CPU and identifies top resource-consuming queries. Query Store then diagnoses execution plan regressions, revealing when the optimizer switched from an efficient Index Seek to a costly Index Scan. Resource Governor is then configured to cap analytical/BI workloads at 25% CPU, preventing them from starving transactional workloads. The post covers enabling Query Store, reading the Regressed Queries report, forcing plans, updating statistics, configuring Resource Governor pools and classifier functions, and validating results via CloudWatch metrics.

Source: https://aws.amazon.com/blogs/database/troubleshooting-sql-server-query-performance-on-amazon-rds. 8sync News only summarizes and links out; content copyright belongs to the authors and original sources.