Transparent Data Encryption for Large DataBase

Question

I am using large database for my application and i have encrypted the database using TDE method. It is taking more time to encrypt. How long need to encrypt the large database? Can we access the DB to insert/retrieve data while encryption is in progress?

Answer 1

You can benchmark how long the encryption takes with this query:

declare @pct float;
select @pct = e.percent_complete from sys.dm_database_encryption_keys e, 
    sys.databases d where e.database_id = d.database_id and d.name = 'mydb';
select @pct 'percent';