web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM 2011 UI randomly b...
Microsoft Dynamics CRM (Archived)

CRM 2011 UI randomly becomes unresponsive

(0) ShareShare
ReportReport
Posted on by Glynn 90

We have just upgraded from 4.0 to 2011 and we are now experiencing random timeouts and loss of the UI. It eventually comes back but it can sometimes be down for 20 minutes or more. During the outage both the SQL server and the Dynamics server are both responsive and do not look to be under heavy load. We have added the OLEDBTimeout and ExtendedTimeout registry keys and set them at 30 seconds. I still see lots of messages about exceeding the 10 second timeout. I have also moved all CRM SQL system jobs from the middle of the day to staggered intervals in the middle of the night. I'm not sure what else to look for.

Thanks,

Glynn

*This post is locked for comments

I have the same question (0)
  • Mohammad Atif Profile Picture
    Mohammad Atif on at

    can you please post 2-3 of time out warning message from the event viewer of the CRM server?

    Thanks,

    Moahmmad

  • Glynn Profile Picture
    Glynn 90 on at

    Query execution time of 120.0 seconds exceeded the threshold of 10 seconds. Thread: 95; Database: MYSITE_MSCRM; Server:SQL; Query: WITH __QuickFind__ as (select top 10001 [ContactId] from (

    SELECT "contact0".[ContactId] as [ContactId] from [ContactBase] as "contact0" where ("contact0".FullName like '%Roberts%') OR ("contact0".FirstName like '%Roberts%') OR ("contact0".LastName like '%Roberts%') OR ("contact0".MiddleName like '%Roberts%') OR ("contact0".EMailAddress1 like '%Roberts%')) as [__QuickFindInternal__])select

    top 51 "contact0".FullName as "fullname"

    , "contact0".ParentCustomerId as "parentcustomerid"

    , "contact0".Address1_City as "address1_city"

    , "contact0".Telephone1 as "telephone1"

    , "contact0".EMailAddress1 as "emailaddress1"

    , "contact0".Address1_StateOrProvince as "address1_stateorprovince"

    , "contact0".ContactId as "contactid"

    , "contact0".ParentCustomerIdYomiName as "parentcustomeridyominame"

    , "contact0".ParentCustomerIdType as "parentcustomeridtype"

    , "contact0".ParentCustomerIdName as "parentcustomeridname"

    , case when (select COUNT(*) from [__QuickFind__]) = 10001 then 1 else 0 end as [__QuickFindLimitValue__]

    from

    Contact as "contact0" (NOLOCK)  

    where

    [contact0].[ContactId] in (select [ContactId] from [__QuickFind__]) and (((("contact0".StateCode = 0)))) order by

    "contact0".FullName asc

    , "contact0".ContactId asc.

  • Glynn Profile Picture
    Glynn 90 on at

    Query execution time of 120.0 seconds exceeded the threshold of 10 seconds. Thread: 109; Database: MYSITE_MSCRM; Server:SQL; Query: WITH __QuickFind__ as (select top 10001 [ContactId] from (

    SELECT "contact0".[ContactId] as [ContactId] from [ContactBase] as "contact0" where ("contact0".FullName like '%Sweeney%') OR ("contact0".FirstName like '%Sweeney%') OR ("contact0".LastName like '%Sweeney%') OR ("contact0".MiddleName like '%Sweeney%') OR ("contact0".EMailAddress1 like '%Sweeney%')) as [__QuickFindInternal__])select

    top 51 "contact0".ContactId as "contactid"

    , convert(bigint, "contact0".VersionNumber) as "versionnumber"

    , "contact0".Telephone1 as "telephone1"

    , "contact0".ParentCustomerId as "parentcustomerid"

    , "contact0".EMailAddress1 as "emailaddress1"

    , "contact0".FullName as "fullname"

    , "contact0".ModifiedOn as "modifiedon"

    , "contact0".ParentCustomerIdYomiName as "parentcustomeridyominame"

    , "contact0".ParentCustomerIdType as "parentcustomeridtype"

    , "contact0".ParentCustomerIdName as "parentcustomeridname"

    , case when (select COUNT(*) from [__QuickFind__]) = 10001 then 1 else 0 end as [__QuickFindLimitValue__]

    , "userentityinstancedata".ReminderSet as "userentityinstancedata.reminderset"

    , "userentityinstancedata".ReminderTime as "userentityinstancedata.remindertime"

    , "userentityinstancedata".StartTime as "userentityinstancedata.starttime"

    , "userentityinstancedata".DueDate as "userentityinstancedata.duedate"

    , "userentityinstancedata".FlagStatus as "userentityinstancedata.flagstatus"

    , "userentityinstancedata".ToDoItemFlags as "userentityinstancedata.todoitemflags"

    , "userentityinstancedata".PersonalCategories as "userentityinstancedata.personalcategories"

    , convert(bigint, "userentityinstancedata".VersionNumber) as "userentityinstancedata.versionnumber"

    from

    Contact as "contact0" left outer join UserEntityInstanceData as "userentityinstancedata" on ("contact0".ContactId  =  "userentityinstancedata".ObjectId and (("userentityinstancedata".OwnerId = 'd6fd245c-4eb6-e211-9d05-005056bf0d25')))

    where

    [contact0].[ContactId] in (select [ContactId] from [__QuickFind__]) and (((("contact0".StateCode = 0)))) order by

    "contact0".FullName asc

    , "contact0".ContactId asc.

  • Glynn Profile Picture
    Glynn 90 on at

    RequestUrl: mysite.mysite.com/.../AppGridWebService.ashx, StackTrace: [CrmException: SQL timeout expired.]

      at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

      at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

      at Microsoft.Crm.ApplicationQuery.RetrieveMultipleCommand.RetrieveData()

      at Microsoft.Crm.ApplicationQuery.ExecuteQuery()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

      at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)

      at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)

      at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.GetResetResponseHtml(AppGrid appGrid, StringBuilder sbHtml)

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.Reset(String gridXml, String id, StringBuilder sbXml, StringBuilder sbHtml)

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)

    [XmlException: Microsoft.Crm.CrmException: SQL timeout expired.

      at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.XrmExecuteInternal()

      at Microsoft.Crm.Application.Platform.ServiceCommands.RetrieveMultipleCommand.Execute()

      at Microsoft.Crm.ApplicationQuery.RetrieveMultipleCommand.RetrieveData()

      at Microsoft.Crm.ApplicationQuery.ExecuteQuery()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.GetData(QueryBuilder queryBuilder)

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadQueryData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderQueryBuilder.LoadData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareGridData()

      at Microsoft.Crm.Application.Platform.Grid.GridDataProviderBase.PrepareData()

      at Microsoft.Crm.Application.Controls.GridUIProvider.Render(HtmlTextWriter output)

      at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderData(HtmlTextWriter output)

      at Microsoft.Crm.Application.Components.UI.Grid.DataGrid.RenderInnerHtml(HtmlTextWriter output)

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.GetResetResponseHtml(AppGrid appGrid, StringBuilder sbHtml)

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.Reset(String gridXml, String id, StringBuilder sbXml, StringBuilder sbHtml)

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)]

      at Microsoft.Crm.Application.WebServices.AppGridWebServiceHandler.ProcessRequestInternal(HttpContext context)

      at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

      at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

  • Mohammad Atif Profile Picture
    Mohammad Atif on at

    If you are getting different Warning messages into the CRM server similar to what you have posted above. It’s overall SQL server performance issue where all the Queries from the Application are executing slow at SQL server. If this is something which is happening at a specific time you might want to take any select query from the warning message  of the CRM server event viewer and then execute that from SQL server to see if that is executing slow. If yes, we need take SQL Server PSSDiag to see what all SQL queries are contributing this slowness. Steps to run the PSSDiag are there in Blog PSSDIAG: community.dynamics.com/.../troubleshooting-performance-in-crm-data-tier-part-1-capturing-the-data.aspx

    Thanks,

    Mohammad

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans