Enabling TDE

  • Comments posted to this topic are about the item Enabling TDE

  • Great question to start the week. Thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • Nice question really.

    M&M

  • Thanks for the question--educating as always.

    You may want to do some more reading on TDE from this MSDN Technical Article.

    Regards,

    Michael

  • Great question. This one is useful for those cert exams.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Good question, with excellent false answers.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes


    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • Glad you enjoyed it. This is one of those tricky subjects.

  • What I hoped to be a logical guess, and got it right! 🙂

    Great question!

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • Please clarify why tempdb is encrypted...Because tempdb is used by all the databases.

    Thanks

  • forsqlserver (5/31/2011)


    Please clarify why tempdb is encrypted...Because tempdb is used by all the databases.

    I guess this has to do with the following:

    When TDE is enabled on any user database, encryption is also automatically enabled for the temporary database (tempdb). This prevents temporary objects that are used by the user database from leaking to disk.

    (from BOL; the link to the article is included in my previous post)

    Regards,

    Michael

  • why tempdb is encrypted....

    as you mentioned tempdb is used by all the databases so its being used by that database as well which is encrypted.

    ----------
    Ashish

  • If TempDb is encrypted and the databases which are in normal stage means not encrypt..Will it not affect the performance with accessibilty?

    Thanks

  • I will say it depends on the frequency of IO on disk as TDE works only when data is moved from buffer pool to disk.

    So yes it will have impact if we have more pages moving in and out from disk

    and

    No if requried pages are already available in memory.

    I havent seen performance imapct after enabling TDE, but have seen in some microsoft document that overall performance impact estimatimation would be around 3-5%

    ----------
    Ashish

  • Had to bone up on TDE to get this one... which btw, is exactly what Steve is looking for in the QOD anyway, right? Good question. Learned a few things from this one, which is the point, right or wrong on the answer.

Viewing 15 posts - 1 through 15 (of 23 total)

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