Hello, My DB size is around 5+ TB and some tables are having size more than 600 GB. This database is mainly used for OLAP and OLTP type of transactions. what will be the Performance Impact if I set AES_128 Encryption on SQL 2019?
There is always an impact on using encryption. Since this is TDE you should prefer faster disks or splitting the data across multiple files to spread IO. AES 128 is going to faster than say AEs 256. But that should be decided by the level of protection you need. Additionally check if there is bitlocker already set-up ( OS level encryption) or storage level encryption. In such cases you probably do not need AES unless you're trying to get certified for some compliance process
SQL Server supports several symmetric key encryption algorithms, including DES, Triple DES, RC2, RC4, 128-bit RC4, DESX, 128-bit AES, 192-bit AES, and 256-bit AES. The algorithms are implemented using the Windows Crypto API.
Thank you very much for this concise explanation, Jayanth,
Hello, My DB size is around 5+ TB and some tables are having size more than 600 GB. This database is mainly used for OLAP and OLTP type of transactions. what will be the Performance Impact if I set AES_128 Encryption on SQL 2019?
There is always an impact on using encryption. Since this is TDE you should prefer faster disks or splitting the data across multiple files to spread IO. AES 128 is going to faster than say AEs 256. But that should be decided by the level of protection you need. Additionally check if there is bitlocker already set-up ( OS level encryption) or storage level encryption. In such cases you probably do not need AES unless you're trying to get certified for some compliance process
Can we use TDE AES256 encryption with SQL server 2019 ??
SQL Server supports several symmetric key encryption algorithms, including DES, Triple DES, RC2, RC4, 128-bit RC4, DESX, 128-bit AES, 192-bit AES, and 256-bit AES. The algorithms are implemented using the Windows Crypto API.