Does anybody know how long it takes on Azure SQL Database for the FORCE LAST GOOD PLAN to kick in? We had a very obvious regression this morning, and it ran in a bad state (causing issues with our system) for about 4 hours, CPU hitting 100% before (an hour later) it started forcing the last good plan. I thought this would happen sooner?
#Azure #AzureSQL #QueryStore #AutomaticPlanCorrection