QueryStore

Copy-DbaDbQueryStoreOption

Enrico van de Laar (@evdlaar) | Tracy Boggiano (@Tracy Boggiano)

Copy-DbaDbQueryStoreOption View Source Enrico van de Laar (@evdlaar) , Tracy Boggiano (@Tracy Boggiano) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Replicates Query Store configuration settings from one database to multiple target databases across instances. Description Reads the complete Query Store configuration from a source database and applies those exact settings to specified destination databases. This lets you standardize Query Store behavior across your environment using proven configurations from production databases.

Get-DbaDbQueryStoreOption

Enrico van de Laar (@evdlaar) | Klaas Vandenberghe (@PowerDBAKlaas) | Tracy Boggiano (@TracyBoggiano)

Get-DbaDbQueryStoreOption View Source Enrico van de Laar (@evdlaar) , Klaas Vandenberghe (@PowerDBAKlaas) , Tracy Boggiano (@TracyBoggiano) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves Query Store configuration settings from databases across SQL Server instances. Description Returns the complete Query Store configuration for user databases, including capture modes, storage limits, cleanup policies, and retention settings. This function helps DBAs audit Query Store configurations across their environment, identify databases with suboptimal settings, and ensure consistent Query Store policies.

Set-DbaDbQueryStoreOption

Enrico van de Laar (@evdlaar) | Tracy Boggiano (@TracyBoggiano)

Set-DbaDbQueryStoreOption View Source Enrico van de Laar (@evdlaar) , Tracy Boggiano (@TracyBoggiano) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Configures Query Store settings to control query performance data collection and retention. Description Modifies Query Store configuration options for one or more databases, allowing you to control how SQL Server captures, stores, and manages query execution statistics. Query Store acts as a performance data recorder, tracking query plans and runtime statistics over time for performance analysis and plan regression troubleshooting.

Test-DbaDbQueryStore

Jess Pomfret (@jpomfret), jesspomfret.com

Test-DbaDbQueryStore View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Compares Query Store settings against best practices. Description Evaluates Query Store against a set of rules to match best practices. The rules are: ActualState = ReadWrite (This means Query Store is enabled and collecting data.) DataFlushIntervalInSeconds = 900 (Recommended to leave this at the default of 900 seconds (15 mins).