Running a Large Number of Agents is Causing Memory Problems

Running a large number of replication agents can result in a lack of sufficient memory to complete operations.

Explanation

In some cases, you might need to run a large number of replication agents simultaneously on a single computer. For example, if you are generating snapshots for a large number of publications or you are synchronizing a large number of push subscriptions at the Distributor. In these situations, the non-interactive desktop heap (a memory structure in Microsoft Windows) can run out of memory.

User Action

We recommend increasing the size of the non-interactive desktop heap on the computer on which the agents are running. For more information, see this Microsoft Web site.

See Also

Concepts

Troubleshooting Replication

Help and Information

Getting SQL Server 2005 Assistance