sys.query_store_plan_forcing_locations

Description

Contains information about Query Store plans that have been forced on secondary replicas , when Query Store for secondary replicas is enabled. You can use this information to determine what queries have plans forced on different replica sets. Query Store for secondary replicas is supported starting in SQL Server 2025 (17.x) and later versions, and in Azure SQL Database.

Syntax

plan_forcing_location_id

Examples

Example 1

plan_forcing_location_id

Example 2

query_id

Example 3

query_id

Example 4

plan_id

Example 5

plan_id

Example 6

replica_group_id

Example 7

force_plan_scope

Example 8

replica_group_id

Example 9

VIEW DATABASE STATE

Example 10

sys.query_store_plan_forcing_locations

(. and 1 more examples)