Post reply

Enabling TDE

  • May 29, 2011 at 1:58 am

    #75596

    Comments posted to this topic are about the item Enabling TDE

  • May 29, 2011 at 11:29 pm

    #1331504

    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

  • May 30, 2011 at 1:49 am

    This was removed by the editor as SPAM

  • May 30, 2011 at 5:16 am

    #1331583

    Nice question really.

    M&M

  • May 30, 2011 at 5:24 am

    #1331588

    Thanks for the question--educating as always.

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

    Regards,

    Michael

  • May 30, 2011 at 9:29 am

    #1331660

    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

  • May 30, 2011 at 9:34 am

    #1331663

    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

  • May 30, 2011 at 9:46 am

    #1331670

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

  • May 30, 2011 at 6:03 pm

    #1331755

    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

  • May 31, 2011 at 1:44 am

    #1331827

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

    Thanks

  • May 31, 2011 at 3:44 am

    #1331854

    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

  • May 31, 2011 at 4:04 am

    #1331857

    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

  • May 31, 2011 at 4:21 am

    #1331865

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

    Thanks

  • May 31, 2011 at 4:35 am

    #1331871

    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

  • May 31, 2011 at 6:46 am

    #1331943

    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