xinyu.wang1 (4/4/2010)
why there is no big performance problem when using transparent data encryption? thanks.
You can expect 3-5% higher CPU utilization.
The primary reason that the cost is so low is that data is only encrypted or decrypted at the page level when pages are written to, or read from, the physical database files. Data in transit or in memory is not encrypted.
See Database Encryption in SQL Server 2008 Enterprise Edition