Qlik Replicate Memory Grants

[Al_gar]

For a Qlik Replicate trigger-based CDC v2 task, we're seeing that there are some updates/deletes on the target database that are requesting a large amount of memory. E.g. Memory allocation for session with a delete transaction:

Although this session was granted 58GB only 5GB was used. Is this an expected behavior for a Qlik Replicate task transaction? Is there an option to limit the max memory grant for a Qlik Replicate task?

Qlik Replicate November 2024 (2024.11.0.177)
SAP HANA as Source
SQL Server 2019 as Target

[john_wang]

Hello @Al_gar ,

Thanks for reaching out to Qlik Community!

I'm not entirely sure whether the graphic is sourced from the "sys.dm_exec_query_memory_grants" view in SQL Server or from somewhere else. However, it's important to note that Qlik Replicate does not influence memory allocation in the SQL Server target database. Replicate is responsible only for delivering the applying SQL statements (DDL, DML etc) to the backend database; memory management is handled internally by SQL Server itself.

Regards,

John.