Our Blog

Amazon RDS for SQL Server supports additional SQL trace flags

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

Amazon RDS for SQL Server Updates

Amazon RDS for SQL Server now supports 18 additional SQL trace flags that can be enabled through database parameter groups. These flags allow for fine-tuning performance and addressing workload-specific challenges.

Newly Supported Trace Flags

  • 647
  • 652
  • 1448
  • 3654
  • 4138
  • 4139
  • 7745
  • 8285
  • 8780
  • 9432
  • 9481
  • 9492
  • 9592
  • 11024
  • 11042
  • 12502
  • 12618
  • 12656

These flags address scenarios such as query plan optimization, DDL performance improvements, availability group replication, Query Store behavior, automatic plan correction, and known engine bug mitigations.

What to do

  • Test the trace flags in a non-production environment before applying them to production instances.
  • Update your RDS parameter group to enable the desired trace flags and apply it to your DB instance.

Source: AWS release notes




If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.

Follow our blog

Get the latest insights and advice on AWS services from our experts.

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Related posts

Check out other insights from the team at West Loop Strategy.

View all
https://aws.amazon.com/about-aws/whats-new/2025/10/amazon-ebs-performance-monitoring-metrics-ebs-volumes

Amazon EBS introduces additional performance monitoring metrics for EBS volumes

Amazon EBS now provides additional visibility to monitor the average IOPS and average throughput of your Amazon EBS volumes with two new CloudWatch metrics - VolumeAvgIOPS and VolumeAvgThroughput
Read more
https://aws.amazon.com/about-aws/whats-new/2025/10/amazon-connect-agent-time-off-balance-data/

Amazon Connect now provides agent time-off balance data in analytics data lake

Amazon Connect now provides agent time-off balance data in analytics data lake, making it easier for you to generate reports and insights from this data
Read more
https://aws.amazon.com/about-aws/whats-new/2026/04/aws-lambda-adds-ruby/

AWS Lambda adds support for Ruby 4.0

AWS Lambda now supports creating serverless applications using Ruby 4
Read more
View all