Pool Advisor rules

EDM pool

EDM pool efficiency drops below 70%.

EDM pool efficiency drops below 90%.

EDM pool has a positive load failure count.

EDM pool activity is high, but utilization is low.

EDM pool size is smaller than the minimum.

EDM pool size is larger than the maximum.

RID pool

RID pool efficiency drops below 70%.

RID pool efficiency drops below 90%.

RID pool experiences storage related failures.

RID pool activity is high, but utilization is low.

RID pool size is smaller than the minimum.

RID pool size is larger than the maximum.

Sort pool

Sort pool efficiency drops below 70%.

Sort pool efficiency drops below 90%.

Sort pool size is smaller than the minimum.

Sort pool size is larger than the maximum.

Buffer pool

There is positive DM event for this buffer pool.

I/O rate is significant, sequential access is low, the page residency time is less than 30 seconds, and the system hit ratio is less than 90%.

I/O rate is significant, sequential access is medium, the page residency time is less than 30 seconds, and the system hit ratio is less than 70%.

I/O rate is significant, sequential access is high, and the application hit ratio is less than 90%.

Getpage rate is less than 10 pages per second and the virtual pool residency time is greater than 300 seconds.

Virtual pool residency time is very high.

Buffer pool size is smaller than the minimum.

Buffer pool size is larger than the maximum.

I/O intensity exceeds that of all other buffer pools.

Sequential steal threshold

Buffer pool access is predominantly sequential, but the sequential steal threshold (VPSEQT) is currently set too low.

Buffer pool access is predominantly random, but the sequential steal threshold (VPSEQT) is currently set too high.

Deferred write and vertical deferred write thresholds

Buffer pool access is predominantly random, the updated-page write I/O rate is above the minimum threshold of 5 pages per second, and the deferred write threshold (DWQT) is at least 20% lower than the recommended value

Buffer pool access is predominantly sequential or has low update activity, and the deferred write threshold (DWQT) is at least 20% higher than the recommended value.

The maximum number of dirty pages allowed for all buffer pools (DPMAX) = 0 and update activity has increased or the size of the buffer pool has decreased.

The maximum number of dirty pages allowed for all buffer pools (DPMAX) = 0 and update activity has decreased or the size of the buffer pool has increased.

Group buffer pool

Prevent group buffer pool from changing system status.

DBD cache

DBD cache efficiency drops below 70%.

DBD cache efficiency drops below 90%.

DBD cache has a positive load failure count.

DBD cache activity is high, but utilization is low.

DBD cache size is smaller than the minimum.

DBD cache size is larger than the maximum.