What are the most important settings, and are default values a good starting point for using Query Store in your database? The most important values are Max Size, Size Based Cleanup Mode, Statistics Collection Interval, and Query Capture Mode, which are explained as follows:
- Max Size: When the maximum storage size allocated for Query Store is reached, then Query Store switches to Read-Only operation mode and no info is captured anymore: you can only read already captured data. In most of the cases, this is not what you want—you are usually interested in recent data. To leave the most recent data in Query Store the you would need to set Size Based Cleanup Mode to Auto, which instructs a background process ...