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 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. The function handles version-specific settings automatically, supporting SQL Server 2016 through current versions with their respective Query Store features like wait statistics capture and custom capture policies.

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 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 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 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).) MaxPlansPerQuery = 200 (Number of distinct plans per query.