Question:
Answer:
If page discards are high, increase the memory allocated to the particular setting (small object heap or disk cache). The number for memory allocation is kilobytes, so if you enter 1024 you are allocating one megabyte of memory.
After each change, monitor page discards every 24 hours for a few days and change again as necessary until a reasonable compromise is reached between performance and availability of RAM for other processes that may be running on the same server.
It is important to note that setting a disk cache too high is ineffective and may cause worse performance than setting it too low (if you end up using virtual memory/page file). A good starting point for disk cache memory allocation is RAM equal to approximately one-third of the size of the database for verions 3.1 or earlier, and about 50% for version 4.0 and higher (depending on services used, and complexity and efficiency of custom macros).
Other memory topics here