Replication Server configuration parameter: sqt_max_cache_size
Monitor SQT cache usage by reviewing counter 24005 – CacheMemUsed. Although this counter may indicate that the SQT cache is constantly full, sqt_max_cache_size may not need to be increased. Rather, monitor counter 24009 – TransRemoved. If TransRemoved remains zero, indicating that transactions are not being flushed from the cache to make room for others, sqt_max_cache_size need not be adjusted.
sqt_max_cache_size applies to all SQT caches supporting DIST clients, and provides a default value for SQT caches that support DSI clients. The DISTs can push through transactions rapidly; their SQT caches do not need to be as large as SQT caches for DSIs. Thus, it is advisable to set SQT cache sizes for DSIs individually using the connection configuration parameter dsi_sqt_max_cache_size, and using sqt_max_cache_size for DIST SQT caches only.
Note that counter 24010 – CacheExceeded does not provide useful information about the usage and size of the SQT cache.
