KB4571296 - Improvement: Option to forcefully turn QDS off by specifying the additional option in ALTER DB command

Applies to: SQL Server 2019 on WindowsSQL Server 2016 Service Pack 2SQL Server 2016 Developer


Disables the Query Store. OFF is the defaultvalue. FORCED is optional. FORCED aborts all running Query Store backgroundtasks, and skips the synchronous flush when Query Store is turned off. CausesQuery Store to shut down as fast as possible. Effectively turns off Query Storeimmediately. 


This improvement is included in the following cumulative updates for SQL Server:
About cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Learn about the terminology that Microsoft uses to describe software updates.