22-25 April 2026

Unlock Peak Performance: Mastering RDS SQL Server Optimisation, Migrations and Upgrades

Proposed session for SQLBits 2026

TL; DR

Learn advanced techniques to monitor and optimize Amazon RDS SQL Server performance. Discover how to use CloudWatch Database Insights and query execution plans to identify bottlenecks, troubleshoot inefficient queries, and resolve critical performance gaps. Explore best practices for migrations, upgrades, and uncommon performance issues to keep your RDS instances running at peak efficiency.

Session Details

Is your Amazon RDS SQL Server instance performing optimally? Don't let performance bottlenecks catch you off guard!

This session explores advanced monitoring techniques to uncover hidden performance issues and drive effective tuning strategies. You’ll learn how to use advance CloudWatch Database Insights and query execution plans to identify resource contention, inefficient queries, and critical performance gaps.

We'll also dive deeper into performance considerations during migrations and upgrades ensuring your RDS instances maintain peak performance through version transitions, instance class changes, and migration scenarios. Learn how to proactively identify and resolve performance regressions that can emerge during these critical operations.

We'll also explore uncommon causes of common issues, providing a deeper understanding of complex database workloads.

Whether you're a seasoned database administrator, a developer, or an cloud architect, this session will arm you with the knowledge and tools to proactively manage and optimise your RDS instances. Don't let undetected performance issues hold you back – join us to master the art of RDS performance optimisation!

3 things you'll get out of this session

Optimization Strategies: Discover how to leverage monitoring insights to optimize database configuration, query performance and maximizing RDS efficiency and scalability. Data-Driven Tuning: Understand the power of comprehensive monitoring in guiding effective performance tuning decisions for RDS instances. Upgrades and Migrations: Sail through the performance considerations during migrations and upgrades, ensuring optimal database performance. Real-World Applications: Examine practical examples and real-world case studies that illustrate successful RDS performance optimisation techniques and their impact.