Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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:
- Monitor performance by using the Query Store
- Query Store for secondary replicas
- sp_query_store_clear_message_queues (Transact-SQL)
- sys.query_store_wait_stats (Transact-SQL)
- sys.query_store_runtime_stats (Transact-SQL)
- sys.query_store_replicas (Transact-SQL)
- sys.query_store_plan_forcing_locations (Transact-SQL)