SQL Server Query Store
The Microsoft SQL Server Query Store feature is available for SQL Server 2016, and is enabled by default for the databases installed with NetForum Enterprise version 2017.1. The following default settings are established during installation and deployment. These settings can be adjusted depending on the needs of your organization. For more information about using the SQL Server Query Store feature, see https://msdn.microsoft.com/en-us/library/mt604821.aspx.
| Setting | Default Value | Notes |
|---|---|---|
| Operation Mode (Actual) | on | |
| Operation Mode (Requested) | read/write | |
| Data Flush Interval (Minutes) | 15 | |
| Statistics Collection Interval | 1 hour | |
| Max Size (MB) | 100 | The default size might not be sufficient if the workload generates large number of different queries and plans, or if you want to keep query history for a longer period of time. Keep track of current space usage and increase the Max Size to prevent Query Store from transitioning to read-only mode. |
| Query Store Capture Mode | All | |
| Size Based Cleanup Mode | Auto | |
| State Query Threshold (Days) | 30 |