Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Performance impact of encryption

Author  Topic 

WindChaser
Posting Yak Master

225 Posts

Posted - 2014-07-16 : 12:03:29
Hi folks,

On SQLServer 2008, I started encrypting data using EncryptByPassphrase/DecryptByPassphrase and I use a 45-character string as the passphrase. Some clients have reported a drag on performance w.r.t. to prior software versions when encryption was not used at all. So I did a few tests to see if I might not reduce cypher strength to gain performance. However, using a shorter passphrase of 10 characters, there doesn't seem to be any significant difference in performance when encrypting/decrypting a field for 10000 records. Given that a 45-character cypher strength is obviously greater than that of a 10-character cypher, I would have expected a cost in performance with a stronger cypher.

Can anyone provide any reasoning to explain these results?

Thanks!
   

- Advertisement -