aws AWS What's New ·

Amazon RDS for SQL Server now supports 18 additional SQL trace flags

dataawsgaengineeraws-rds
feature

Amazon RDS for SQL Server has expanded its support to include 18 more SQL trace flags, which can be enabled through database parameter groups. This enhancement allows database administrators to fine-tune SQL Server engine behavior, optimizing performance and addressing specific workload challenges within the managed RDS environment. The new flags cover scenarios such as query plan optimization, DDL performance improvements, and availability group replication. Customers are advised to test these flags in a non-production environment due to their potential impact on system performance.

Features (1)
  • Support for 18 additional SQL trace flags

    Amazon RDS for SQL Server now supports 18 new SQL trace flags, accessible via database parameter groups. These flags enable database administrators to modify SQL Server engine behavior, allowing for fine-tuning of performance, query optimization, and management of workload-specific issues. The new flags address various scenarios including DDL performance, availability group replication, and automatic plan correction.

Read the original announcement →

https://aws.amazon.com/about-aws/whats-new/2026/09/rds-sqlserver-supports-additional-trace-flags/

Related releases