locked
Issue with "Microsoft CRM Asynchronous Processing Service" when starting up and CPU 100% usage. RRS feed

  • Question

  • I have a performance issue with the CRM Asynchronous Processing Service.

    When I start up the "Microsoft CRM Asynchronous Processing Service" I got an error in the Application Log as follows:

    Host XXXXXXXXXXX: error while processing organization 4cf38201-3ffe-4616-ad6d-72769389fe5b. Exception: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.CrmDbConnection.InternalExecuteNonQuery(IDbCommand command)
    at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command, Boolean impersonate)
    at Microsoft.Crm.CrmDbConnection.ExecuteNonQuery(IDbCommand command)
    at Microsoft.Crm.Asynchronous.DataAccessSharedBase.ExecuteSqlCommand(IDbCommand command, Nullable`1 expectedAffectedRecords)
    at Microsoft.Crm.Asynchronous.QueueDataAccess.MoveSuspendedToReady()
    at Microsoft.Crm.Asynchronous.QueueManager.<OnMoveSuspendedToReadyTimerEvent>b__1(IQueueDataAccess queueDataAccess)
    at Microsoft.Crm.Asynchronous.QueueManager.ExecuteForAllOrganizations(OrganizationQueueDataAccessHandler handler)

    After that, the service is running but the CPU usege grows all the way up to 100% and doesn't decrement. If I stop the service, I got the same error in the Application Log and the CPU usage drops down.

    This is causing that my CRM clients experience low performance.

    Using Microsoft Dynamics CMR 4.0, Microsoft SQLServer 5.0, Windows Server 2003.

    ¿Anyone knows the cause of this?
    • Edited by ckumark Friday, June 26, 2009 7:05 PM Fixing thread title bug
    Monday, June 15, 2009 11:51 PM

Answers