You can set the XDB Server to support anywhere from 10 to 9,999 open queries. Each additional query specified here requires an additional, but negligible amount of memory. However, specifying too large a number can impact performance because the array of queries is scanned each time a transaction completes. The more queries that are allowed, the longer the scan will be each time.
To set the parameter (Windows 2000):