Has anyone used TDE on SQL Server 2008? What are the performance overheads?
A:
Basically the largest overhead when using TDE is CPU resource requirements. If your server has sufficient processing power then you are most likely good to go.
For further reading take a look at the following resources.
SQL Server Optimization And The Performance Impact Of Encryption
Understanding Transparent Data Encryption(TDE)
Transparent Data Encryption Considerations
I hope this helps and if you have further questions just let me know.
John Sansom
2010-06-14 12:37:52