David Fowler turns it off then back on again, like a true IT professional:
I recently received a complaint that Query Store for a particular database was turned off, which was strange as that particular database has seen quite a few performance issues and I know that I’d ensured Query Store was enabled in the past.
No problem, I flicked the switch and Query Store was enabled again.
Half an hour or so later and I’m being told that Query Store is again disabled. What’s going on?
Read on to learn what to do if you get stuck with this problem.