???? ?????? ??? ???? ?????? AsyncOperationBase ????? ???? ?? Microsoft Dynamics CRM 4.0

?????? ????????? ?????? ?????????
???? ???????: 968520 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

??? ????? Microsoft Dynamics CRM 4.0 ????? ??? ?????? AsyncOperationBase ????? ????. ????? ????? ?????? ??? ?????? ????? ? ???? ?????? ????.

???????? ??? ???? ??? ????? ????? ???? ?? ??? ??? ???? Microsoft Dynamics CRM ?? ??? ????? ???????:
??? ?????: ???
???? ?????: MSCRMDeletionService
??? ?????: ???
????? ?????: 16387
?????: 2009/01/26
?????: 11:41:54 ?
????????: N/A
???? ?????????: CRMSERVER
???: ???: ???? ???? ????? ?????? ?????? = CleanupInactiveWorkflowAssembliesProcedure ?????? ??? ???? ?? ?????????? ???? ????????? ?????? ?? http://go.microsoft.com/fwlink/events.asp.

????

??? ??? ???????? ????? ????? ?????? AsyncOperationBase ?? ???? ????? ???????? ????? ?????? ????? <OrgName> _MSCRM ????? ???????? ??? <orgname>???? ???? ????? ?????? ??????? ?????? ??.

?????:???? ??? ????? ???????? ?????? ?????? ????? ?????? ???? ???? ????? ?? ??? ??????? ??? ??? ????? ????? ????? ??? ?????? ?????? ?? ???? ??????? orgnization ????? ?? ?????.

???? ?????? effected:
  • ????? ???????? SQM. -?????? ???? ??????? ???? ???? ???????? ?????? ????? ????????.
  • ???? SQL ???????? ????? ???????. ????? ??? ?????? ??? ????? ?? ??? ??? ????? ?????. ????? ??? ?????? ???? ?????? ???????? ??? ???? ????????.
  • ???? ?????? ???? ?????? ??????? - ???? ???? ???? ?????? ?? ????? ?????? ????? ?????? ???????? ?? CRM.

?? ???? ????? ???? ?????? ???? ?????.

?????????
  • ?????? ??? SQL ?? ??? ?????? KB ??? ???? ????? ???. ????? ????? ??? ????? SQL ?????? ??? ???? ?????? ??? ?? ????? ?? ?????? ?? ???? ???? ". ??? ????? ?? CRM ????? ? ????? ??? ??? ????? ??? ??????? ??? ???? ???????? ???????? ??? ????? ????? ?? ????? ???? ?????? ???? DELETE ????? ????? ?????? writting (?????? ?????? ??? ????? SDK CRM ????? ??? ?? ????? BulkDeleteRequest.QuerySet ??? BulkDeleteRequest ? ????? ?????).
  • ???? ?? ??? ??????? AsyncOperation ????? ??? ????? "?" ??????? ???????? ?? ?????? WorkflowLogBase.
  • ???? ?? ??? ???? ??????? bulkdeletefailure ???????.
  • ???? ?? ??? ??? ??? ??????? ??????? ??????? ??????? ??? ??? ??? ?????? ?? ??????? 3 ???? ??? ?????? ?? ??????? ?? 30 ?? 32:
    • ?????? ????? ??? ????? (1)
    • ????? ?????? SQM (9)
    • PersistMatchCode (12)
    • FullTextCatalogIndex (25)
    • UpdateContractStates (27)
    • ??? ????? (10)
IF EXISTS (SELECT name from sys.indexes
                  WHERE name = N'CRM_AsyncOperation_CleanupCompleted')
      DROP Index AsyncOperationBase.CRM_AsyncOperation_CleanupCompleted
GO
CREATE NONCLUSTERED INDEX CRM_AsyncOperation_CleanupCompleted
ON [dbo].[AsyncOperationBase] ([StatusCode],[StateCode],[OperationType])
GO

declare @DeleteRowCount int
Select @DeleteRowCount = 2000
declare @DeletedAsyncRowsTable table (AsyncOperationId uniqueidentifier not null primary key)
declare @continue int, @rowCount int
select @continue = 1
while (@continue = 1)
begin
      begin tran
      insert into @DeletedAsyncRowsTable(AsyncOperationId)
      Select top (@DeleteRowCount) AsyncOperationId
      from AsyncOperationBase
      where OperationType in (1, 9, 12, 25, 27, 10) AND StateCode = 3 AND StatusCode in (30, 32)     
 
      Select @rowCount = 0
      Select @rowCount = count(*) from @DeletedAsyncRowsTable
      select @continue = case when @rowCount <= 0 then 0 else 1 end     
 
        if (@continue = 1)
        begin
            delete WorkflowLogBase from WorkflowLogBase W, @DeletedAsyncRowsTable d
            where W.AsyncOperationId = d.AsyncOperationId
            
delete BulkDeleteFailureBase From BulkDeleteFailureBase B, @DeletedAsyncRowsTable d
            where B.AsyncOperationId = d.AsyncOperationId
 
            delete AsyncOperationBase From AsyncOperationBase A, @DeletedAsyncRowsTable d
            where A.AsyncOperationId = d.AsyncOperationId            
 
            delete @DeletedAsyncRowsTable
      end
 
      commit
end

--Drop the Index on AsyncOperationBase

DROP INDEX AsyncOperationBase.CRM_AsyncOperation_CleanupCompleted


????? ???? ???????? ????? ?????

  • ?????? ?????? ????? Microsoft CRM ????? "????? CRM ?????Microsoft" ???? ?????? ????? ????? ?????? Microsoft CRM. ?????????? ??? ????? ?????? ?? ????? ???? ?? ????? Microsoft CRM. ??? ???? ???? ????? ?????? ???????? ?? 10: 00 ? ????? ?? ????? ?????????. ?????? ????? ?????? ???? ScaleGroup ?????? ?? Microsoft CRM. ????? ?? ?????????? ?? ?????? ???? MSDN ??????:
    http://code.msdn.microsoft.com/ScaleGroupJobEditor/Release/ProjectReleases.aspx?ReleaseId=676
    ?????? ?? ???? ??? ??????? ??? ???? ???????? ????? ??????.
  • ?????? ???? ??????? ?????? ????? ?? ??? ??????? ? ????? ????????? ???????? Microsoft CRM DeletionService ???? ???? ?????? ???? ?????? ????? ??????? three??????? ??? ????? ?????? OrganizationName_MSCRM ??? ????? ???????? ????? ????? ?? ??? ???????:
    CREATE NONCLUSTERED INDEX CRM_WorkflowLog_AsyncOperationID ON [dbo].[WorkflowLogBase] ([AsyncOperationID])
    GO 
    
    CREATE NONCLUSTERED INDEX CRM_DuplicateRecord_AsyncOperationID ON [dbo].[DuplicateRecordBase] ([AsyncOperationID])
    GO
    
    CREATE NONCLUSTERED INDEX CRM_BulkDeleteOperation_AsyncOperationID ON [dbo].[BulkDeleteOperationBase]
    (AsyncOperationID)
    GO
    
    ?????? ?? ???? ??? ????? ??? ??????? ?? ?????? ???????? ????? ????? ???? ??????.
  • ????? CRM ?????? ???????? ???? Microsoft ????? ????? ??? ???????? ?????.
  • OPTIONAL: ????? ??????? ??????? ??????? ?? ????? ??????????:
    -- Rebuild Indexes & Update Statistics on AsyncOperationBase Table 
    ALTER INDEX ALL ON AsyncOperationBase REBUILD WITH (FILLFACTOR = 80, ONLINE = OFF,SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = OFF)
    GO 
    -- Rebuild Indexes & Update Statistics on WorkflowLogBase Table 
    ALTER INDEX ALL ON WorkflowLogBase REBUILD WITH (FILLFACTOR = 80, ONLINE = OFF,SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = OFF)
    
    GO
  • OPTIONAL: ????? ?????????? ?? "?????? ??????" ??? ???? ??????? ??????? ???????? ????????? ????? ??????? (????? ?? ???? ?? ????? ????? ????? ??????):
    UPDATE STATISTICS [dbo].[AsyncOperationBase] WITH FULLSCAN
    UPDATE STATISTICS [dbo].[DuplicateRecordBase] WITH FULLSCAN
    UPDATE STATISTICS [dbo].[BulkDeleteOperationBase] WITH FULLSCAN
    UPDATE STATISTICS [dbo].[WorkflowCompletedScopeBase] WITH FULLSCAN
    UPDATE STATISTICS [dbo].[WorkflowLogBase] WITH FULLSCAN
    UPDATE STATISTICS [dbo].[WorkflowWaitSubscriptionBase] WITH FULLSCAN
  • OPTIONAL : ????? ???? ??????? ????? ???????? MSCRM ????? ????? ????? ??????? ?? ????? ???? SQL. ?????? ??? ???? SQL 2005 ????? ?????? ??? ????? ???? SQL Microsoft Studio ?????? ? ???? ??? ?????? ?????? ??? ????? ???????? _MSCRM <org_name> ? ???? ???????? ? ???? ??? ?????? ?? ???? ??? ???? ?????????. ??? ????? ????? ?? ???? ??? ?????. ??? ????? ??? ???????? ????? ?? ????? ?????? ???? ??????? ????? ???????? _MSCRM <org_name> ??? ??????? ??? FULL ?????? ??????? ???????? ????.




?????? ??? ??????? ?????? ???? ?? ???? ???????? ????? ?? ??? ??????? ????? ???????? ????? ?????? ??? ????? ?????? OrganizationName_MSCRM:
Select Count(AsyncOperationId)
from AsyncOperationBase WITH (NOLOCK)
where OperationType in (1, 9, 12, 25, 27, 10) 
AND StateCode = 3 AND StatusCode IN (30,32) 

??????? ????

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
954929?????? AsyncOperation ?????? ??? ??? ?? ????? ???????? _MSCRM [???????] ? ???? ??? ????? ???? Microsoft Dynamics CRM
????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
957871???? ??????? "??? ?????? ?????" ?????? AsyncOperationBase ?? ????? ?????? MSCRM ????? ????? ???? ?? Microsoft Dynamics CRM 4.0
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft
?????? ??? ???? ?? ????????? ??? Microsoft CRM ???? ????? ??????? ??????? ?????? ???????? ???? ????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
887283???? ??????? ?????? ????? Microsoft CRM ???? ????? ?????? ?????? ???????

???????

???? ???????: 968520 - ????? ??? ??????: 11/?????/1430 - ??????: 7.0
????? ???
  • Microsoft Dynamics CRM 4.0
????? ??????: 
kbmt kbfix kbautohotfix kbexpertiseinter kbsurveynew kbmbsmigrate kbqfe kbhotfixserver KB968520 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????968520

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com