As shown in the previous section, to enable Query Store you need to set only one parameter or click once. When you do this, you have enabled it with default values for all of its parameters. There is a collection of Query Store options that can be configured. Again, you can set them through SSMS or Transact-SQL. However, some of them have different names and even metrics in both tools. Here is a list of configurable Query Store parameters:
- Operation Mode defines the operation mode of the Query Store. Only two modes are supported: READ_WRITE and READ_ONLY. The default value is READ_WRITE, which means that Query Store collects query plans and runtime statistics and writes them to the disk. READ_ONLY mode makes sense ...