Enabling and configuring Query Store
As with all new features, Query Store is not active for a database by default. You can enable and configure it in SQL Server Management Studio (SSMS) by using the database properties (Query Store Page) or by using Transact-SQL. To enable Query Store, your account must be db_owner of the database or a member of the sysadmin fixed server role.
Enabling Query Store with SSMS
To enable Query Store for a database, you need to select it and click on Properties. You can find a new Query Store property page at the bottom of the list. As mentioned at the beginning of the section, it is disabled by default, which is indicated by the values Off for both Operation Mode (Actual) and Operation Mode (Requested). To enable it, ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
