Enabling Query Store

Question

Hello!

I've enabled Query Store in the Read-Write mode on my SQL Server - as a result the corresponding Query Store containers have appeared in the Management Studio, but no single query was ever added to the store even after setting the both monitoring options to 1 minutes:

What should I check to make it working?

Thank you in advance,
Michael

Answer 1

What you may what to change if you are only playing around is to change the capture mode to ALL. This can have detrimental effcet on a system witn lot of unparameterised queries. Then again, this was the default setting in SQL 2016 and 2017.

The other two may not have as much effect as you think, because when you query store views, they take data both from what is on disk and what is buffered in memory. The effect of the flush parameter is how much you lose in case of a crash or a failover.

ï also like to point that when we recommend you to stick to the defaults, we have a production scenario in mind.

I'm afraid that I did not watch the video.

Answer 2

"to change if you are only playing around is to change the capture mode to ALL" - oh, that's it! I didn't even bother to check that this parameter is set to None although according to documentation it must be "Auto" by default (and all articles on enabling Query Story were saying nothing about capture mode) !

Now it works!

Thank you all for your help!

Regards,
Michael