Query Store Entering Error State

Extremely rarely Query Store can end up in ERROR state because of internal errors or due to race condition when failover/restart happens while QDS cleanup running. Query Store can be recovered by executing sp_query_store_consistency_check stored procedure within the affected database. Please remember if QDS in ERROR state in that case it may affect Automatic plan… Read more