Promon R&D

[SSuhaib]

Hi all,

In Promon, R&D Activity, BI Log, apart from all metrics there is an "busy buffer waits" and "empty buffer waits". Can any one be kind enough to explain the difference between these two, since at the outset they appear to be the same.

Thanks in advance.

 

[Rob Fitzpatrick]

My understanding (courtesy of RichB):

• busy buffer waits:
  • instances of an APW waiting for exclusive access to a BI buffer, because another user is writing to it
• empty buffer waits:
  • instances of a user waiting for an available BI buffer to write to because all the existing BI buffers are full

Lots of good info: What are you waiting for? A reason for waiting around (Rich's presentation from Pug Challenge Americas 2011)

 

[cj_brandt]

You can't do much to eliminate the busy buffer waits.

You can reduce the empty buffer waits by adjusting BI Blocksize, BI Clustersize and allocating bibufs.