none
Performance Issue for SQL Jobs with Disk Encryption RRS feed

  • Question

  • Hi,

    I have noticed that the SQL Jobs are taking very long to complete on the VM on which we have Disk Encryption enabled. I couldn't find any documentation that speaks about Impact of ADE on Performance. Could you please point me to the document. Appreciate your response.

    Wednesday, November 13, 2019 7:31 PM

All replies

  • For better understanding can you elaborate what exactly are you trying to accomplish?

    What is the performance you're measuring? Is it the install of the extension? Or the overall VM performance after enabling ADE? May I know the OS version?

    VM performance after encryption:  There will be no impact on VM performance after encryption.

    This blogs explain how the ADE performance impact on IaaS VM 

    The databases on SQL Database managed instance are encrypted by default using Transparent Data Encryption. Transparent Data Encryption encrypts/decrypts every page that is exchanged with the disk storage. This spends more CPU resources, and introduces additional latency in the process of fetching and saving the data pages to or from disk storage. Make sure that both databases on SQL Database managed instance and SQL Server have Transparent Data Encryption either turned on or off, and that database encryption/decryption operations have completed before starting performance testing.

    For more information refer to this article

    You can use the following query to determine whether the databases are encrypted:

    select name, is_encrypted from sys.databases
    


    Performance guidelines for SQL Server in Azure Virtual Machines

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there.

    There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet. 

    Hope this helps! 

    Kindly let us know if the above helps or you need further assistance on this issue.

    ------------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Thursday, November 14, 2019 11:31 AM
    Moderator
  • Is there any update on the issue?

    If the suggested answer helped for your issue, do click on "Mark as Answer" and “Vote as Helpful” on the post that helps you, this can be beneficial to other community members.

    Monday, November 18, 2019 5:40 AM
    Moderator
  • @RSyed1 Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

    If the suggested answer helped for your issue, do click on "Mark as Answer" and Up-Vote” on the post that helps you, this can be beneficial to other community members.

    Tuesday, November 19, 2019 3:55 AM
    Moderator
  • @RSyed1 Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
    Thursday, November 21, 2019 8:47 AM
    Moderator