have query cache clear have options to leave forced plans
tscstc opened this issue · 1 comments
tscstc commented
I talked with Erin about this tool after releasing it, and moderated her pre-con session on Query Store during last week's PASS.
That "forced plans not dropped" is a problem with the "default" Query Store cleanup process, and one of the reasons I wrote my own: the QDSCacheCleanup unforces those plans before dropping them.
I haven't implemented "Drop everything but forced plans" yet, but is something I could do: just open an issue in the project and I'll try to get it ready by next week
SQLozano commented
(This comes from a discussion in the SQL Community Slack)