We are planning to use TDE for security purposes but are worried as to how much will the performance overhead be. Does anyone have experience to share?
Like most things like this I would test the specific databases in a non-prod environment to base-line any changes to SQL Server.
However there is an excellent article that will give you some idea of the overhead.
No one has followed this question yet.