Dynamics CRM performance slow and resolution tips

CRM slow performance….hmm so many times we hear about this. Why we face this slow performance in crm application what could be the reason…so many questions we have in our mind.

We have so many situations causes slow performance in crm application.

1.       POA table in CRM

What happens in crm when a user clicks any button or any link, how every request works whatever user do.

In crm world every action we do records in POA table in database. When we open CRM online or on premise using web or outlook every action stores as one record.

We need to monitor this POA table frequently as this table grows with the actions we do in CRM.  If we don’t monitor and delete old records in POA this leads to CRM slow performance. Sometimes this leads to application crash while accessing.

Generic SQL Error while running Plugin in CRM 2011

In CRM 2011 we faced Generic SQL Error while running plugin to update records, this issue generally occurs when too many operations happening at the same time like updating same records by another request or too many conditions to update records.

To resolve this issue we need first identify and optimise the query and also remove unnecessary requests to database and apply indexing to database records.