Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • iNETZO 136 posts 499 karma points c-trib
    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

    Copy Link
  • Graham Davis 110 posts 376 karma points
    Mar 30, 2020 @ 15:51
    Graham Davis
    0

    Try Using.....

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

    Copy Link
  • iNETZO 136 posts 499 karma points c-trib
    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

    Copy Link
  • Graham Davis 110 posts 376 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.

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies