sys.sp_query_store_clear_message_queues

Description

Clears all queued (non-persisted) Query Store messages pending for the replica against which Query Store for secondary replicas is supported starting in SQL Server 2025 (17.x) and later versions, and in Azure SQL Database. For complete platform support, see Requires the ALTER permission on the database. The following example clears all queued (non-persisted) Query Store messages pending. The

Syntax

sp_query_store_clear_message_queues

Examples

Example 1

sp_query_store_clear_message_queues

Example 2

0

Example 3

1

Example 4

sp_query_store_clear_message_queues
[ ; ]

Example 5

EXECUTE sp_query_store_clear_message_queues;