sys.database_query_store_internal_state (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Managed Instance

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.

Permissions

Requires the VIEW DATABASE STATE permission.

Remarks

For information on configured replicas for Query Store, see sys.query_store_replicas (Transact-SQL).

Next steps

Learn more about Query Store and related concepts in the following articles: