During a peak period, use sp_monitorconfig to examine the use of DTX participants:
sp_monitorconfig "number of dtx participants"
Usage information at date and time: Jun 18 1999 9:00AM.
Name # Free # Active % Active # Max Ever Used Re-used -------------- -------- ------ -------- --------------- ------- number of dtx 480 20 4.00 210 N/A participants
If the #Free value is zero or very low, new distributed transactions may be unable to start due to a lack of DTX participants. Consider increasing the number of dtx participants value.
If the #Max Ever Used value is too low, unused DTX participants may be consuming memory that could be used by other server functions. Consider reducing the value of number of dtx participants.
