Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
When i query data from AsyncOperation from CRM it s very slow, espcialy when the 'data' column is included in the request, But when i query this table directly from sql server management studio it s fast. there is any help? there is a performance issue in the asynchronyous service.
So my question is what are you querying that table for?
I am not sure you need, not can you understand the contents of, the data column.
Could you share the code?
Hi Pham, this the code :
ColumnSet = new ColumnSet(true),
TopCount = 4999
the issue is that the asyncronious service in our application is slow, we run the service with sql server trace and we found that the deadlock took much more time and the tablke AsyncOperation is involved in this Deradlock issue. so i quueryed the table from crm and i found that is very slow comparing other tables.
add NoLock = true,
to your Query Expression.
I would also drop the TopCount down to a smaller number.
Are you saying that you are trying to perform a query to determine why the AsyncService is slow?
Well the AsyncOperationBase table can be the cause of performance issues if there are a lot of records in it, you could try clearing down that table as per the following kb article, this can help to improve performance: support.microsoft.com/.../968520
A couple of other questions:
there is only 5200 records in AsynOperation and the same value mostly in AsyncOperationBase, and there is only one Asyncronious sercie runing in the async server.
Business Applications communities