Operational Defect Database
BugZero found this defect 459 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2130492
Resolves a query performance issue that affects change tracking autocleanup and manual cleanup queries. Note You need to turn on trace flags 8286 and 8287, as this forces the cleanup query to use the FORCE ORDER and FORCESEEK hints to speed up the performance.
Last update date:
2/16/2023
Affected products:
SQL Server 2022 on Linux
SQL Server 2022 on Windows
Affected releases:
build lower than 16.0.4003.1
Fixed releases:
16.0.4003.1
Description:
Resolves a query performance issue that affects change tracking autocleanup and manual cleanup queries. Note You need to turn on trace flags 8286 and 8287, as this forces the cleanup query to use the FORCE ORDER and FORCESEEK hints to speed up the performance.
