Controlling resource consumption

Because each ATQ operator creates a new process, and consumes some memory (for buffering), inserting numerous ATQs into an execution plan might use too many system resources on the federated server. In addition, if several SHIP or RPD operators in a query execute on a particular remote data source, making several of the operators asynchronous opens multiple concurrent cursors on that data source and can produce an unacceptable load.

To control resource consumption on the federated system, or on the data sources, you can set configuration parameters. The parameters define limits on the total number of ATQs allowed within a query and on the number of ATQs allowed for each server within a query.