What is the maximum number of targets per source?
What is the maximum number of routes in a config?
What is the maximum number of queues per cop?
Maximum of targets per source is unlimited.
- However as each target adds an export process on source, it is limited by the system resources on the source server.
- Additional sp_cops provide the means to have more targets as well.
maximum number of unique routes per config is 32000
maximum number of queues per cop is 1024, it is controlled by SP_QUE_MAX_QUEUES parameter and default is 25.
Refer to the Admin guide for additional information on setting multiple sp_cops and named export queues.
