Posted On: Aug 27, 2020

Amazon RDS for SQL Server now supports trace flag 692 as a startup parameter using DB parameter groups. Enabling this trace flag disables fast inserts while bulk loading data into heap or clustered indexes.

Starting with SQL Server 2016, fast inserts are enabled by default. Fast inserts leverage the minimal logging that occurs while the database is in the simple or bulk logged recovery model. With fast inserts, each bulk load batch acquires new extents, bypassing the allocation lookup for existing extents with available free space to optimize insert performance.

However, with fast inserts bulk loads with small batch sizes can lead to increased unused space consumed by objects. If increasing batch size isn't feasible, enabling trace flag 692 can help reduce unused reserved space. Trace flag 692 can be applied to SQL Server 2016 and later.

To learn more please visit the Amazon RDS for SQL Server User Guide.

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability.