1

I see that you can use notion like the following to set the query store configuration:

ALTER DATABASE <database name>   
SET QUERY_STORE (SIZE_BASED_CLEANUP_MODE = AUTO);  

But how can I check to see what the current value for SIZE_BASED_CLEANUP_MODE is?

2

This can be found (near the end) in the sys.database_query_store_options DMV.

SELECT size_based_cleanup_mode, size_based_cleanup_mode_desc
FROM sys.database_query_store_options
  • 1
    better to accept the answer 2.5 years late than never :P – Zain Rizvi Mar 14 at 19:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.