dsi_max_xacts_in_group specifies the maximum number of transactions in a group. Larger numbers may reduce commit processing at the replicate database, and thereby improve throughput.
Monitor the average number of transactions placed in a group per DSI-E thread by reviewing counter 57001 – UnGroupedTransSched.
Monitor the average number of transactions per group for the total DSI connection by reviewing these counters:
5000 – DSIReadTranGroups
5002 – DSIReadTransUngrouped
Use dsi_max_xacts_in_group to control group size. Set dsi_xact_group_size to the maximum value of 2,147,483,647 and do not change it. Contention among parallel transactions may be reduced by reducing the value of dsi_max_cacts_in_group to 1, which indicates no grouping.
Monitor why groups are being closed by reviewing these counters:
5042 – GroupsClosedBytes
5043 – GroupsClosedNoneOrig
5044 – GroupsClosedMixedUser
5045 – GroupsClosedMixedMode
5049 – GroupsClosedTranPartRule
5051 – UserRuleMatchGroup
5053 – TimeRuleMatchGroup
5055 – NameRuleMatchGroup
5063 – GroupsClosedTrans
5068 – GroupsClosedLarge
5069 – GroupsClosedWSBSpec
5070 – GroupsClosedResume
5071 – GroupsClosedSpecial
5072 – OriginRuleMatchGroup
5074 – OSessIDRuleMatchGroup
5076 – IgOrigRuleMarchGroup
