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:
- 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)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru