Adjusting throughput by caching received messages

When messages arrive, the SQL Remote Message Agent (dbremote) reads the messages and then stores them in cache memory until they are applied. This caching of messages prevents:

  • Rereading of out-of-order messages from the message system, which may lower performance on large systems. Caching of messages is useful when messages are being read over a WAN (such as Remote Access Services or POP3 through a modem).

  • Contention between database worker threads reading messages (a single threaded task) because the message contents are cached.

 How messages are cached
 Specifying the message cache size
 Example
 See also