Press "Enter" to skip to content

Query Store Cleanup Can Be Blocked

Published 2018-04-23 by Kevin Feasel

Kendra Little shows that you can block Query Store cleanup:

This is an isolated test system, so I went to clean out Query Store as a reset. I didn’t need any of the old information in there, so I ran:

  • ALTER DATABASE BabbyNames SET QUERY_STORE CLEAR ALL;
  • GO

I was surprised when I didn’t see this complete very quickly, as it normally does.

Click through to see how Kendra diagnoses the issue.

Published in Locks, Blocks, and Deadlocks and Query Store