| title | sys.dm_column_encryption_enclave (Transact-SQL) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 10/11/2019 |
| ms.prod | sql |
| ms.reviewer | vanto |
| ms.technology | system-objects |
| ms.topic | language-reference |
| author | jaszymas |
| ms.author | jaszymas |
| monikerRange | >= sql-server-ver15 || = sqlallproducts-allversions |
[!INCLUDE tsql-appliesto-ssver15-xxxx-xxxx-xxx-winonly]
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. |
Requires VIEW SERVER STATE permission.
SELECT * FROM sys.dm_column_encryption_enclave;
GO Configure the enclave type for Always Encrypted Server Configuration Option