Optimize performance configuration in Replicate task

[Rueda]

Hello!

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.
When delete operations are performed on the mainframe, I experience a significant delay in the deletion of records in Azure SQL.

Is this configuration correct?

Can we optimize this? can you suggest a configuration?

Regards!

[DesmondWOO]

Hi @Rueda ,

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.

Regards,
Desmond