Home Forums SQL Server 2008 Security (SS2K8) Is there a way to quantify what extra overhead that TDE might be causing? RE: Is there a way to quantify what extra overhead that TDE might be causing?

  • December 1, 2015 at 1:09 pm

    #1843326

    yakko_Warner (12/1/2015)

    okay, but their isn't a way to track just the TDE cost or is it just straight cpu %?

    I presume just cpu % with getting to peak at the tde portion of the transactions.

    Remember, TDE is "always on," there's no portion of a transaction that relates to TDE. Because it encrypts the data "at rest," it's the actual file on disk (the MDF / LDF / NDF) that's encrypted.

    Really, if you've already encrypted the DBs with TDE, there's no easy way to check how it's impacting your CPU utilization, short of decrypting the DBs, monitoring for a while, then re-encrypting.