22-25 April 2026

Unlock Peak Performance: Mastering RDS SQL Server Optimization, Migrations & Upgrades

Proposed session for SQLBits 2026

TL; DR

This session reveals advanced monitoring techniques that uncover hidden performance issues and drive effective tuning strategies. You'll learn how to use Database Insights, and query execution plans to pinpoint resource contention, inefficient queries, and critical performance gaps following with migration and upgrade strategies/best practices.

Session Details

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

This session reveals advanced monitoring techniques that uncover hidden performance issues and drive effective tuning strategies using Database Insights, and query execution plans to pinpoint resource contention, inefficient queries, and critical performance gaps.

Beyond day-to-day optimization, we'll dive 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 optimize your RDS instances. Stay ahead of the curve and ensure your applications perform flawlessly. Don't let undetected performance issues hold you back – join us to master the art of RDS performance optimization!

Don't let undetected bottlenecks or migration challenges hold you back - join us and transform your approach to database performance!

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 optimization techniques and their impact.