Control the maximum memory consumed by unpacked commands in the DSI SQT cache during transaction profiling in HVAR.
The SQT thread monitors the memory consumed by commands unpacked by the HVAR transaction profiling processes and referenced by the DSI SQT cache.
When Replication Server is replicating using HVAR, the maximum amount of memory consumed by the DSI thread is the sum of dsi_sqt_max_cache_size, sqt_max_prs_size , and dsi_cdb_max_size. Setting dsi_sqt_max_cache_size, sqt_max_prs_size , and dsi_cdb_max_size smaller would reduce memory consumption but reduce replication performance. Tune your replication environment for optimum memory consumption and performance. See the Replication Server Reference Manual > Replication Server Commands to configure the parameters.