Query Store (Performance)

Query Store (Performance) is a SQL statement in the Administration category. SQL Server 2016+: captures query execution history, plans, and performance metrics automatically. The syntax is ALTER DATABASE db_name SET QUERY_STORE = ON;. It returns query store enabled. A typical example: ALTER DATABASE my_company SET QUERY_STORE = ON; ALTER DATABASE my_company SET QUERY_STORE (OPERATION_MODE = READ_WRITE, MAX_STORAGE_SIZE_MB = 500); -- View regressed queries: SELECT * FROM sys.query_store_runtime_stats JOIN sys.query_store_query_text ON ...; -- Force a specific plan: EXEC sp_query_store_force_plan @query_id = 42, @plan_id = 123; A close relative is CREATE USER, which creates a new database user account. A close relative is GRANT, which grants specific privileges (SELECT, INSERT, UPDATE, DELETE, ALL) to a user on a database/table. A close relative is REVOKE, which removes previously granted privileges from a user. More about this category: Database administration — CREATE DATABASE, GRANT, REVOKE, SHOW, DESCRIBE. Related Administration entries: CREATE USER, GRANT, REVOKE, SHOW TABLES, DESCRIBE / DESC, SHOW INDEX, SHOW CREATE TABLE, SHOW DATABASES.