sys-database-query-store-internal-state-transact-sql.md

title	sys.database_query_store_internal_state (Transact-SQL)
description	sys.database_query_store_internal_state (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	4/26/2022
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.technology	system-objects
ms.topic	reference
ms.custom	event-tier1-build-2022
f1_keywords	QUERY_STORE_INTERNAL_STATE SYS.QUERY_STORE_INTERNAL_STATE_TSQL SYS.QUERY_STORE_INTERNAL_STATE QUERY_STORE_INTERNAL_STATE_TSQL
helpviewer_keywords	query_store_query catalog view sys.query_store_query catalog view
dev_langs	TSQL
monikerRange	=azuresqldb-current||>=sql-server-2016||=azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.database_query_store_internal_state (Transact-SQL)

[!INCLUDE sqlserver2022]

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.

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)