What does it mean? What do I do about it?
Example alert from the ProTop Portal:
What does it mean?
This alert tells you this database has a rather small buffer pool. 100k is pretty small: 400MB with 4k blocks, 800MB with 8k blocks. The database buffer pool is sized with the -B parameter. The buffer pool is the main tool used to prevent disk IO by caching data in memory.
What to do?
Increase -B. Small increases will have no impact.
Note: You must increase -B by roughly 4x to cut IO ops in half. Data accessed in the buffer pool is at least 75x faster to access than data accessed from the operating systems file cache and at least 1500x faster than disk IO.
See this article on Tuning your database buffer pool.
If all else fails...
Contact us at support@wss.com or use the online chat. We'll be happy to help.