Hi,

Since not all memory requests will reflect in the counter you could have > 90% and still have memory issues (and with issues I don't mean low on memory; over consumption is more often the case :P).

But as Steve pointed out, if you encounter a low BCHR and add some memory, there will usually be a performance boost whereas a high number doesn't necessearily mean all is well.

There could be memory issues elsewhere in the bufferpool - anything that goes through the Memory Broker for instance (large memory requests, queries with sort/hash operators, memory for parallel plans etc.) or in the memory area formerly known as mem_to_leave.

I tend to ignore it completely when it's high.

/Elisabeth