Applies to: SQL Server 2022 (16.x) Preview
Contains information about queue length and memory usage for the Query Store when Query Store for secondary replicas is enabled.
|Column name||Data type||Description|
|pending_message_count||bigint||The number of messages waiting in the queue on the primary for the replica where the system view is being viewed from. Not nullable.|
|messaging_memory_used_mb||bigint||The amount of memory in total taken up by the messages in the queue. Not nullable.|
Requires the VIEW DATABASE STATE permission.
Learn more about Query Store and related concepts in the following articles: