Amazon RDS for SQL Server supports additional SQL trace flags
News
Amazon RDS for SQL Server now supports 18 additional SQL trace flags that enable database administrators to fine-tune performance and optimize workloads.
- Newly supported trace flags: 647, 652, 1448, 3654, 4138, 4139, 7745, 8285, 8780, 9432, 9481, 9492, 9592, 11024, 11042, 12502, 12618, 12656
- Trace flags modify SQL Server engine behavior including query optimizer, lock escalation, statistics, and memory handling
- Address scenarios like query plan optimization, DDL performance, availability groups, Query Store, and engine bug mitigations
- Available in all AWS Regions supporting Amazon RDS for SQL Server
- Test in non-production environments first as flags can impact performance, memory usage, and query execution plans
Administrators can enable trace flags through RDS parameter groups to optimize SQL Server workloads in managed environments.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Aug 25
2026
2026
Amazon RDS now supports the latest CU for Microsoft SQL Server
Sep 8
2026
2026
Amazon RDS now supports the latest CU and GDR updates for Microsoft SQL Server
Sep 24
2026
2026
Amazon RDS supports Multi-AZ for SQL Server Developer Edition
Sep 1
2026
2026
Amazon RDS Custom now supports the latest CU and GDR updates for Microsoft SQL Server
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.