Share via

Query Store and ad-hoc workload sql server configuration setting

sakuraime 2,351 Reputation points
2021-09-23T10:26:17.33+00:00

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 | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories


Answer accepted by question author

AmeliaGu-MSFT 14,016 Reputation points Microsoft External Staff
2021-09-24T06:59:00.2+00:00

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.

Was this answer helpful?

0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.