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.

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.

We recommend increasing the size of the non-interactive desktop heap on the computer on which the agents are running. For more information, see Knowledge Base article 824422: "Unexpected behavior occurs when you run many processes on a computer that is running SQL Server".

Community Additions