question

sakuraime avatar image
0 Votes"
sakuraime asked AmeliaGu-msft commented

Query Store and ad-hoc workload sql server configuration setting

given that my query store is set to capture mode as ALL, while if I also turned on ad-hoc workload on sql server , what if the query run only once, will the plan still be capture on Query store ?

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Why don't you test it and tell us the result? Should be faster than waiting 11 hours for a response...

(And I don't have the time to make that test now. I am already past my bedtime.)

0 Votes 0 ·

Hi sakuraime,

Did the answer help you?
Please feel free to let us know if you have any other question. If you find any post in the thread is helpful, you could kindly accept it as answer.

Best Regards,
Amelia

0 Votes 0 ·

1 Answer

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi sakuraime,

Yes, the plan will be stored in the query store.
Please check this article which might help you.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.