Tasks are not being processed quickly enough within IDM resulting in tasks becoming stuck in progress.
Inefficiencies with the MS SQL Database
Release : 14.X
Component : CA IDENTITY SUITE (VIRTUAL APPLIANCE)
Enable Lock Pages in memory - Locking pages in memory may boost performance when paging memory to disk is expected.
The tempdb database has only 1 data file - Increase the number of data files in tempdb to maximize disk bandwidth and reduce contention in allocation structures. As a rule, if the number of logical processors is less than or equal to eight (8), use the same number of data files as logical processors. If the number of logical processors is greater than eight (8), use eight data files. If contention continues, increase the number of data files by multiples of four (4) up to the number of logical processors until the contention is reduced to acceptable levels. Alternatively, make changes to the workload or code.
Enable Database Instant File Initialization
Check the Power Plan of the server, it should be configured as High Performance: