Improve PrincipalObjectAccess (POA) and AsyncoperationBase table performance in MS Dynamics CRM 2011

PrincipalObjectAccess (POA) table

Grant permission for a user to see/edit/delete a record in CRM.

Permissions are granted is through either Direct or Inherited shares. 

Direct Shares are the user shares a record to another user or team through the 'share' button in the ribbon. These records will have a value in the AccessRightsMask colum of the POA table.

Inherited Shares are the result of a number of different configuration rules – such as the shares that cascade to an object based on the ownership of its parent record, Custom code that shares a record, or by the system due to relationship behaviors or system settings. These records will have a value in the InheritedAccessRightsMask colum of the POA table.

The shares granted on objects in CRM are stored in the PrincipalObjectAccess (POA) system table. Since almost every access to CRM data interacts with the POA table.

Dynamics CRM Plugin Registration Tool

Download and Export

1. Download and install latest Dynamics CRM SDK  from Microsoft.
2. Export "pluginprofiler.solution" package (get it from sdk\bin) to your CRM solution.

Connect to the Microsoft Dynamics CRM Server

1. Run the PluginRegistration.exe tool from sdl\bin folder of the SDK download.
2. To run the Plug-in Registration tool, you must first install the Windows Identity Foundation. 
3. Click Create New Connection.
   
4. Click connect to the Microsoft Dynamics CRM Server, you should see a list of available organizations that you belong to in the Connections pane.