Hi,

the posts help a lot.

I did some testing in our environment and I get about 10% slower performance with TDE enabled. Which is quite okay. 🙂

Thanks for the info about the index fragmentation, I will keep an eye on it, usually we perform an index defragmentation each night, so it should keep the indexes in a good shape.

Our databases are around 600 GB-800 GB each with a high OLTP load on it.

Thanks.

Best Regards,

Akki