WASH_AREA_BUFFERS_PERCENT option

Function

Specifies the percentage of the buffer caches above the wash marker.

Allowed Values

1 – 100

Default

20

Scope

Can be set only for the PUBLIC group. DBA authority is required to set the option. Shut down and restart the database server to have the change take effect.

Description

Sybase IQ buffer caches are organized as a long MRU/LRU chain. The area above the wash marker is used to sweep out (that is, write) dirty pages to disk.

In the IQ Monitor -cache report, the Gdirty column shows the number of times the LRU buffer was grabbed in a “dirty” (modified) state. If GDirty is greater than 0 for more than a brief time, you might need to increase SWEEPER_THREADS_PERCENT or WASH_AREA_BUFFERS_PERCENT.

The default setting of this option is almost always appropriate. Occasionally, Sybase Technical Support might ask you to increase this value.

See also

Chapter 6, “Monitoring and Tuning Performance” in the Sybase IQ Performance and Tuning Guide

“SWEEPER_THREADS_PERCENT option”.