Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Replication
Troubleshooting
 Running a Large Number of Agents is...

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (June 2009)
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 this Microsoft Web site.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker