sys.sp_query_store_flush_db

Description

2016 (13.x) and later versions SQL database in Microsoft Fabric Flushes the in-memory portion of the Query Store data to disk. Query Store for readable secondaries executed on a secondary replica, that secondary replica’s cache is forced to flush to the cache on the primary replica. This can accelerate the Query Store cache data being synced to the primary replica, if the secondary replica cache flush is otherwise delayed under heavy workload.

Syntax

sys.sp_query_store_flush_db

Examples

Example 1

0

Example 2

1

Example 3

sys.sp_query_store_flush_db

Example 4

sp_query_store_flush_db
[ ; ]

Example 5

EXECUTE sp_query_store_flush_db;