search

zikato / blogcomments

0 stars 0 forks source link

Query Store default settings - StraightforwardSQL #22

Open utterances-bot opened 2 years ago

utterances-bot commented 2 years ago

Query Store default settings - StraightforwardSQL

Query store is a great tool and comes with a set of default settings. But what are the values exactly?

https://straightforwardsql.com/posts/query-store-default-settings/

deweter commented 2 years ago

Hi Tom, nice post! Just a quick note - the capture mode for 2016 and 2017 is ALL (you mention unintentionally the opposite in your post).

BTW I'd be cautious in general recommendation - turn it on, it's just too good - without an explicit warning about the impact on systems with a big share of adhoc transactional workload. I have seen too many of them severely slowed down by QS (even with an auto/custom capture policy...). It's gonna be a ride with 2022 for these systems :)