Post reply

PREEMPTIVE_OS_ENCRYPTMESSAGE and PREEMPTIVE_OS_DECRYPTMESSAGE wait types

  • October 3, 2014 at 8:04 am

    #291292

    Hello,

    I've see very high wait times and a lot of task waiting for PREEMPTIVE_OS_ENCRYPTMESSAGE and PREEMPTIVE_OS_DECRYPTMESSAGE on my production server. What can be the cause of this waits? While searching the web, i didin't found any information about this waits only the description: When your operating system needs additional resources to run high priority tasks, it interrupts SQL Server scheduling and forces it to yield. SQL Server remains in a preemptive state and can't schedule its own tasks until the external process finishes.

    Maybe someone have some more information about this waits?

    Thanks.

  • October 3, 2014 at 8:09 am

    #1749988

    Running service broker?

    Using any encryption anywhere?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 3, 2014 at 8:12 am

    #1749990

    Yes, we are using service broker.

  • October 3, 2014 at 9:13 am

    #1750009

    That's very likely going to be the source of those waits then. SQL's probably calling out to the OS to do the encryption and decryption of the messages.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 4 (of 4 total)

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