sys-dm-column-encryption-enclave.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
sys.dm_column_encryption_enclave (Transact-SQL)	sys.dm_column_encryption_enclave (Transact-SQL)	jaszymas	jaszymas	vanto	02/24/2023	sql	system-objects	reference	TSQL	>=sql-server-ver15

sys.dm_column_encryption_enclave (Transact-SQL)

[!INCLUDE sqlserver2019-windows-only]

Returns performance counters for the secure enclave for Always Encrypted. For more information, see Always Encrypted with secure enclaves.

If the enclave is configured and has been correctly initialized after the last restart of [!INCLUDEssNoVersion], the view contains exactly one row. If the enclave is not configured or it has not been correctly initialized, the view returns no rows.

Column name	Data type	Description
current_enclave_session_count	int	The current number of client sessions using the enclave.
current_column_encryption_key_count	int	The count of column encryption keys the enclave currently holds.
current_memory_size_kb	bigint	Enclave memory size in KB
total_evicted_session_count	bigint	The total count of enclave sessions evicted since the last server restart.

Permissions

Requires VIEW SERVER STATE permission.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER SECURITY STATE permission on the server.

Examples

SELECT * FROM sys.dm_column_encryption_enclave;  
GO  

See also

Configure the enclave type for Always Encrypted Server Configuration Option