sql timeouts in crm? RRS feed

  • Question

  • Hello, I've started getting SQL timeouts in CRM and I'm not sure why.  I've never experienced SQL timeouts in CRM in the past. Here's a simple query that's timing out:

    select activityid from task where regardingobjectid = 'F3669B61-669E-E311-87C7-00155D760004'

    I'm probably going to restart my dev server which I'm guessing will fix this issue but I was wondering what is a more structured, systematic approach for addressing/debugging this type of issue when restarting the server is not practical?  For example, if this happens in prod? What are some possible reasons why this sql timeout issue started happening and are there any steps I can take to help avoid this?
    Tuesday, February 25, 2014 10:19 PM

All replies

  • resource issue? Have you tried CRM tracing for any other information? you will need to run the SQL profiler to further investigate. 

    Ibrahim Sukari, Technical Consultant | SharePoint | Dynamics CRM | LinkedIn Profile

    Tuesday, February 25, 2014 11:52 PM
  • most of time out issue were caused by dead lock, you can use below steps to addressing/resolving them:

    1. if possible using 'no-lock' option in both of your queryexpression and fetchexpression

    2. all of sql server time out level issue will be logged in windows event, so you can check it to address root cause

    3. you need to set the max memory of your sql server to promise your OS has enough resource

    4. as lbrahim mentioned, you can use to monitor high time cost sql, and try to tuning it.

    • Proposed as answer by Chen Xiong Tuesday, March 4, 2014 5:00 AM
    Wednesday, February 26, 2014 5:15 AM