locked
Database size after TDE RRS feed

  • Question

  • Are there anything which can estimate the database size increment after turning on TDE ???
    Wednesday, June 26, 2019 1:47 AM

Answers

  • TDE typically only imposes a slight CPU cost of 3-5% for encryption/unencryption processing. I don't think encryption has any affect on compressed tables, in term of disk cost.

    HTH,


    Phil Streiff, MCDBA, MCITP, MCSA

    • Marked as answer by sakurai_db Monday, July 8, 2019 3:28 AM
    Wednesday, June 26, 2019 2:50 PM

All replies

  • And what about if the existing database has table enable compression ? 
    Wednesday, June 26, 2019 9:17 AM
  • "TDE does not increase the size of the encrypted database"
    About TDE

    HTH,


    Phil Streiff, MCDBA, MCITP, MCSA

    Wednesday, June 26, 2019 2:43 PM
  • TDE typically only imposes a slight CPU cost of 3-5% for encryption/unencryption processing. I don't think encryption has any affect on compressed tables, in term of disk cost.

    HTH,


    Phil Streiff, MCDBA, MCITP, MCSA

    • Marked as answer by sakurai_db Monday, July 8, 2019 3:28 AM
    Wednesday, June 26, 2019 2:50 PM
  • thanks
    Monday, July 8, 2019 3:28 AM