sys.dm_column_encryption_enclave (Transact-SQL)

Applies to: SQL Server 2019 (15.x) and later - 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 SQL Server, 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