Home | Previous Page | Next Page   Setting Up and Managing Enterprise Replication > Monitoring and Troubleshooting Enterprise Replication >

Preventing Memory Queues from Overflowing

In a well-tuned Enterprise Replication system, the send queue and receive queue should not regularly overflow from memory to disk. However, if the queues in memory fill, the transaction buffers are written (spooled) to disk. Spooled transactions consist of transaction records, replicate information, and row data. Spooled transaction records and replicate information are stored in the transaction tables and the replicate information tables in a single dbspace. Spooled row data is stored in one or more sbspaces.

For more information, see Setting Up Send and Receive Queue Spool Areas.

The following situations can cause Enterprise Replication to spool to disk:

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]