Monday, May 09, 2011

Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM 4.0

Dear Readers,

If your CRM is behaving very slow, Just see the option of AsyncOperationBase Table, do the query on Query Analyzer of SQL server and see

select * from AsyncOperationBase

You will see the response time.

Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM 4.0

Follow this article

http://support.microsoft.com/kb/968520

Regards,
Imran


[MVP CRM] = https://mvp.support.microsoft.com/profile/imran.mustafa

MSN/IM= mscrmexpert@gmail.com
SKYPE= mscrmexpert
BLOG= http://microsoftcrm3.blogspot.com
Linkedin = http://www.linkedin.com/in/mscrmexpert
Twitter = @mscrmexpert

See table usage of Dynamics CRM in SQL Server

How we can see which table is how many rows and index size etc etc

1. OPEN Query analyzer of SQL Server
2. OPEN MS CRM database

Run the query like this

exec sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

It will show you all table statistics with index size, row size etc etc.

Hopeful it will help

Regards,
Imran


[MVP CRM] = https://mvp.support.microsoft.com/profile/imran.mustafa

MSN/IM= mscrmexpert@gmail.com
SKYPE= mscrmexpert
BLOG= http://microsoftcrm3.blogspot.com
Linkedin = http://www.linkedin.com/in/mscrmexpert
Twitter = @mscrmexpert