https://community.qlik.com/t5/Qlik-Replicate/Optimize-performance-configuration-in-Replicate-task/m-p/2545765#M16095 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132009">@Rueda</a>&nbsp;,<BR /><BR />The DELETE operation generally takes longer to process because the system must search for the specific record before deleting it. You can enable VERBOSE logging on TARGET_APPLY to measure how long each DML statement takes to execute, which can help in assessing performance on the Azure database. I also observed that you are using ‘Transactional apply’ mode. In general, the performance of ‘Batch optimized apply’ mode is better than ‘Transactional apply’ mode.<BR /><BR />Regards,<BR />Desmond</P> Mon, 30 Mar 2026 03:09:00 GMT DesmondWOO 2026-03-30T03:09:00Z https://community.qlik.com/t5/Qlik-Replicate/Optimize-performance-configuration-in-Replicate-task/m-p/2545520#M16089 <P>Hello!</P><P><BR />I have a DB2 Z/OS source point and an end point which is an Azure SQL database with 12 cores. The virtual machine on which the Qlik Replicate server runs has 64GB of RAM and premium SSDs.<BR />When delete operations are performed on the mainframe, I experience a significant delay in the deletion of records in Azure SQL.</P><P>Is this configuration correct?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Configuration_Tasks.png" style="width: 738px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/187453i5982B09D6248F3CA/image-size/large?v=v2&amp;px=999" role="button" title="Configuration_Tasks.png" alt="Configuration_Tasks.png" /></span></P><P>Can we optimize this? can you suggest a configuration?</P><P>&nbsp;</P><P>Regards!</P> Thu, 26 Mar 2026 11:06:36 GMT https://community.qlik.com/t5/Qlik-Replicate/Optimize-performance-configuration-in-Replicate-task/m-p/2545520#M16089 Rueda 2026-03-26T11:06:36Z https://community.qlik.com/t5/Qlik-Replicate/Optimize-performance-configuration-in-Replicate-task/m-p/2545765#M16095 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/132009">@Rueda</a>&nbsp;,<BR /><BR />The DELETE operation generally takes longer to process because the system must search for the specific record before deleting it. You can enable VERBOSE logging on TARGET_APPLY to measure how long each DML statement takes to execute, which can help in assessing performance on the Azure database. I also observed that you are using ‘Transactional apply’ mode. In general, the performance of ‘Batch optimized apply’ mode is better than ‘Transactional apply’ mode.<BR /><BR />Regards,<BR />Desmond</P> Mon, 30 Mar 2026 03:09:00 GMT https://community.qlik.com/t5/Qlik-Replicate/Optimize-performance-configuration-in-Replicate-task/m-p/2545765#M16095 DesmondWOO 2026-03-30T03:09:00Z