September 18, 2025 at 7:37 am
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed in minutes. The default is 60 minutes. Consider using a lower value if you require finer granularity or less time to detect and mitigate issues. Keep in mind that the value directly affects the size of Query Store data. Use SQL Server Management Studio or Transact-SQL to set a different value for Statistics Collection Interval:
does this mean that query store would run after 60 seconds ,please explain?
Stale Query Threshold (Days): Time-based cleanup policy that controls the retention period of persisted runtime statistics and inactive queries, expressed in days. By default, Query Store is configured to keep the data for 30 days, which might be unnecessarily long for your scenario.
Avoid keeping historical data that you don't plan to use. This practice reduces changes to read-only status.
Q2) if 30 days are not expired and 1000 mb size has not reached, does it change the read only status , question is when this state query threshold is going to change the status to read only.
is this sate query is any way related to Size Based Cleanup Mode?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply