question

Raju Lalvani avatar image
Raju Lalvani asked

Has anyone tried TDE and seen how it performs in production

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?

securityadministration
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered

Raju

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.

http://www.databasejournal.com/features/mssql/article.php/3815501/Performance-Testing-SQL-2008s-Transparent-Data-Encryption.htm

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.