The Curious Case of… very long failover times with a large ad hoc workload
In this case, the cause of the long failover time was enabling Query Store after upgrading, for a database with a large workload of ad hoc queries, meaning there was 100GB of Query Store data to load.
2019-05-31