Enabling Query Store in PolicyCenter

It is possible to enable the use of Query Store in Guidewire PolicyCenter through any of the following methods.

Start Query Store from SQL Server Management Studio

Navigate to the Query Store screen in the SQL Server Management Studio and change the Operation Mode (Requested) option from Off to Read Write.

Start Query Store using Transaction-SQL

ALTER DATABASE database_name SET QUERY_STORE = ON

In addition, Guidewire automatically enables Query Store on SQL Server by default if you drop the PolicyCenter database using the gwb dropDb build command.