Impact of TDE implementation on OLTP database RRS feed

  • Question

  • Hi All,

    i have SQL 2016 ENT - 2 Node Cluster. Database size is 1.2 TB in Production. I tried enabling TDE in UAT with same database size and it took around 7 Hours.  In production i wont get 7 Hours of downtime; i knew that database is accessible while encryption scan operation is going on in background however, will it affect my OLTP system performance? 

    If Total Database size is 1 TB and free space in database is 600 GB will it take same time for encryption with total 1 TB db size with no free space internally.

    Thanks in Advance. 

    Regards, AKash Pawar

    Friday, March 6, 2020 9:40 AM

All replies