MSCRM Principal Object Access Table
Posted on 2010-09-07
We are using MS CRM 4.0 and are facing some performance issues.
#1 - We have been noticing that the Principal Object Access grows very fast and then the system slows down. Looking at the processes running on the database we found that most of the queries running on the database are inserts and updates on this PrincipalObjectAccess table and they take time. What is the reason for this tale growing and can we clean up the data in this table?
#2 - When users go to the Workplace tab in CRM, the select query to populate the activity screen take a long time or eventually times. The query for this is "ActivityPointerBase". If I change the Paging Limit it works for some time, but after some time it again starts timing out.
What's the best way to deal with this?