locked
Deadlocks in CRM 2013 RRS feed

  • Question

  • Hi,

    I am facing issue for deadlocks which is occurring due to the following query.

    (@OpportunityId0 uniqueidentifier)select 
    "opportunity0".OwningBusinessUnit as "owningbusinessunit"
    , "opportunity0".OwnerId as "ownerid"
    , "opportunity0".OwnerIdType as "owneridtype" 
    from
    OpportunityBase as "opportunity0" 
    where
    ("opportunity0".OpportunityId = @OpportunityId0)

    No idea when this query is getting triggered and why it is so occurring frequently.

    Any suggestion is helpful.

    Thanks,

    Nibedita


    Wednesday, April 1, 2015 6:00 AM

All replies

  • Hello,

    Where that deadlock error comes from? Do you use some kind of Retrieve/RetrieveMultiple queries from plugin? Could you please describe your scenario?


    Dynamics CRM MVP
    My blog

    Thursday, April 2, 2015 12:25 PM
    Moderator
  • Not sure from where this deadlock error comes from.

    When we trying to update opportunity it is not getting updated and when we checked in DB we found this query causing deadlock.

    It happens when more than 30-40 user working at the same time.

    Regards,

    Nibedita

    Wednesday, April 8, 2015 5:29 AM
  • Yes, we use  Retrieve/RetrieveMultiple queries from plugin.
    Wednesday, April 8, 2015 5:45 AM
  • What Isolation mode are you using for your Database?

    Enabling Read Committed Isolation is recommended if you are experiencing deadlock.  It’s a pretty easy change to make to a CRM Organisation DB although there are some considerations that need to be considered before making this change (notably around tempdb sizing).

    The article below has a number of useful performance tips:

    http://social.technet.microsoft.com/wiki/contents/articles/13661.dynamics-crm-2011-quick-optimization-guide.aspx

    Wednesday, April 8, 2015 7:28 AM