This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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 ?
Additional SQL Server features and topics not covered by specific categories
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.)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
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
Answer accepted by question author
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.