Query Store Size Based Cleanup Causes Performance Problems - How to Avoid It

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

I’m a huge fan of SQL Server’s Query Store feature. Query Store collects query execution plans and aggregate query performance metrics, including wait stats. Having Query Store enabled makes troubleshooting performance issues such as bad parameter sniffing, much, much easier. Because Query Store is integrated into SQL Server itself, it also can catch query plans in a lightweight way…

Read on kendralittle.com ↗