Always Encrypted - High Volume OLTP????

  • Has anyone implemented Always Encrypted on a high volume OLTP instance or know anyone that has?

    We are going through the process of vetting Always Encrypted now. It would be nice to hear others experiences, and hopefully successes.

    Thanks!

  • I've heard secondhand from a few people. No one has mentioned issues in busy environments, but they are concerned about the limitations and restrictions.

    The way AE is implemented, there shouldn't really be much additional load on your system. The encryption/decryption is all done client side, so CPU load is distributed.

    The encrypted data is a blog written to disk. For some data, this is going to be larger than the original data, particularly integers, so there is likely additional network load and perhaps more disk, but I haven't seen anyone report significant increases.

  • Thanks Steve, that's nice to hear!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply