I'm using TDE for SQL Server. Querying certificate:
select database_name = d.name,
dek.encryptor_type,
cert_name = c.name
from sys.dm_database_encryption_keys dek
left join sys.certificates c
on dek.encryptor_thumbprint = c.thumbprint
inner join sys.databases d
on dek.database_id = d.database_id;
Output:
database encryptor cert_name
tempdb ASYMMETRIC KEY NULL
TDE_Test CERTIFICATE TestZert3
Querying encryption status:
select db_name(database_id), encryption_state,
percent_complete, key_algorithm, key_length
from sys.dm_database_encryption_keys
Output:
database encrypt_state percent_complete key_algorithm
tempdb 3 0 AES 256
TDE_Test 3 0 AES 256
Why is the complet_percent 0?