Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • iNETZO 93 posts 412 karma points
    Mar 30, 2020 @ 12:43
    iNETZO
    0

    Long SQL waits on umbracoLock

    Hi,

    Since a two weeks where getting quite often long waits on our SQL server on this query:

    SELECT value 
    FROM umbracoLock
    WHERE id=@0
    

    The waits can run up to +40 seconds. umbracoLock is a very small table with only 10 rows an 3 cols. What can be a reason gettings waits on this table?

    Best regards,

    iNETZO

  • Graham Davis 99 posts 332 karma points
    Mar 30, 2020 @ 15:51
    Graham Davis
    0

    Try Using.....

    SELECT value FROM umbracoLock WITH (NOLOCK) WHERE id=@0

  • iNETZO 93 posts 412 karma points
    Mar 30, 2020 @ 17:35
    iNETZO
    0

    Thanks for your reply Graham. Unfortunately the query is coming from Umbraco itself, for example when document-, media- or member properties are saved, so it's not easy to modify it. Are there other Our-member who had the same issue on high traffic sites with members? We’re using Umbraco 8.2.2

  • Graham Davis 99 posts 332 karma points
    Mar 31, 2020 @ 02:16
    Graham Davis
    0

    Sorry that did not work for you. Based on your reply, this may need to be a fix in a future upgrade.

Please Sign in or register to post replies

Write your reply to:

Draft