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 )

 

Example SMP log entries:
 

Entry 1:

Processed 46,378 previously known memberships, changes: joins=627, leaves=46249, known=46378, unchanged=29, rule=5e88bf3d-c701-456a-9bd9-7c660715de4f
-----------------------------------------------------------------------------------------------------
Date: 1/9/2019 1:31:11.8759608 PM, Tick Count: 364868055 (4.05:21:08.0550000),  Size: 370 B
Process: AeXSvc (1540), Thread ID: 92, Module: AeXSVC.exe
Priority: 4, Source: RoleAccountMembership

Entry 2:

Operation started: Active Directory Import (Full, 'MyDomain' (MyDomain.domain.com), resource='Trustee', rule={5E88BF3D-C701-456A-9BD9-7C660715DE4F}) ...
-----------------------------------------------------------------------------------------------------
Date: 1/9/2019 1:29:27.1674184 PM, Tick Count: 364763347 (4.05:19:23.3470000),  Size: 374 B
Process: AeXSvc (1540), Thread ID: 92, Module: AeXSVC.exe
Priority: 4, Source: DirectoryImporter

Entry 3:

Accounts removed from roles: detected 46,249, processing.
-----------------------------------------------------------------------------------------------------
Date: 1/9/2019 1:31:12.0943636 PM, Tick Count: 364868273 (4.05:21:08.2730000),  Size: 278 B
Process: AeXSvc (1540), Thread ID: 92, Module: AeXSVC.exe
Priority: 8, Source: RoleAccountMembership

 

ITMS 8.x

There is a performance issue with the resources allocated to the SQL server.

First advice would be to check out SQL performance:

• Fragmentation
• Indexes are in place
• Enough CPU and memory

If you check out some of the quick ‘info’ messages added to 8.x in the SMP log – you may see that the SQL server is quite loaded:

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 Getting Started.