I am trouble shooting a prod issue but to keep things simple. On a test server, with nothing else running. DBCC dropfreebuffers between tests I executing a Select Into into that includes a group by. First I run it on the database unencrypted then
I encrypt the database using 256 AES. I flush the cache and execute the statement again. It takes more than twice as long to execute on the encrypted database. An hour on the unencrypted and 2 hours on the encrypted. FYI the server 16 CPU
with 64 Gigs. I have repeated this test multipe times with the same resultes. Is anyone else seeing this type of performance hit with TDE ?
View Complete Post