The customer is getting the following error while running an AD Import Rule like Role and Account AD Import:
"Task error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
While the Role and Account Rule runs, you may see in the SQL Server Activity Monitor that it has this query as the most intensive one:
DELETE ra OUTPUT deleted.ResourceAssociationTypeGuid, deleted.ParentResourceGuid, deleted.ChildResourceGuid, deleted.CreatedDate INTO #tmpRADeleted FROM #ResourceAssociationDelete raTmp JOIN ResourceAssociation ra with(rowlock,updlock) ON raTmp.ResourceAssociationTypeGuid = ra.ResourceAssociationTypeGuid AND raTmp.ParentResourceGuid = ra.ParentResourceGuid AND (raTmp.ChildResourceGuid = ra.ChildResourceGuid OR raTmp.ChildResourceGuid = 0x0 )
As you may see both, the SMP and SQL servers, are Virtual machines. Both servers are much lower on memory and cpu resources than recommended. Please refer to official documents like DOC9470 "ITMS 8.1 Planning for Implementation Guide" for recommendations of supported tech specifications.
Subscribing will provide email updates when this Article is updated. Login is required.