理解CRM 4.0异步服务的数据结构AsyncOperationBase ( part 1)
AsyncOperationBase库表随着时间和业务量增长可能会增长到很大程度，从而影响到CRM AsyncService的性能。
如果安装了CRM 4.0 Update Rollup 3 (或更高版本), AsyncOperationBase表格可以有自动清空类型为AsyncOperationType=1 和 10的记录。
- https://support.microsoft.com/kb/957871/ 自动清空AsyncOperationType=1记录 (需手动添加注册表DWORD AsyncRemoveCompletedJobs=1方能生效)
- https://support.microsoft.com/kb/968755/ 自动清空已经完成的工作流中间记录 (需手动添加注册表DWORD AsyncRemoveCompletedWorkflows=1方能生效)
下面文章有手动SQL脚本定向清除某些记录。
https://support.microsoft.com/kb/968520
表1： Asyncoperationbase table - operationtype, status code and state code
| AsyncOperationType | Name | Description |
| 1 | Event | 系统事件，比如WorkflowExpansion Task |
| 2 | BulkEmail | |
| 3 | Parse | |
| 4 | Transform | |
| 5 | Import | |
| 6 | ActivityPropagation | |
| 7 | PublishDuplicateRule | |
| 8 | BulkDetectDuplicates | |
| 9 | CollectSqmData | 收集SQM数据 |
| 10 | Workflow | 工作流 |
| 11 | QuickCampaign | |
| 12 | PersistMatchCode | 生成Match Code用于重复检测 |
| 13 | BulkDelete | |
| 14 | DeletionService | |
| 15 | IndexManagement | |
| 16 | CollectOrgStats | |
| 17 | ImportingFile | |
| 18 | CalculateOrgStorageSize | |
| 19 | CollectOrgDBStats | |
| 20 | CollectOrgSizeStats | |
| 21 | DatabaseTuning | |
| 22 | CalculateOrgMaxStorageSize | |
| 23 | BulkDeleteChild | |
| 24 | UpdateStatisticIntervals | |
| 25 | FullTextCatalogIndex | 生成Full Text Catalog |
| 26 | DatabaseLogBackup | |
| 27 | UpdateContractStates | 更新合同状态信息 |
表2: AsyncOperationState and AsyncOperationStatus
| StateCode | StatusCode | ||
| 0 | Ready | 0 | WaitForResources |
| 1 | Suspended | 10 | Waiting |
| 2 | Locked | 20 | InProgress |
| 21 | Pausing | ||
| 22 | Canceling | ||
| 3 | Completed | 30 | Succeeded |
| 31 | Failed | ||
| 32 | Canceled |
谢谢
张立岩 (Clifford Zhang)