What is the optimal average bufferpool read time in a multipartitioon datawarehouse?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • kc

    What is the optimal average bufferpool read time in a multipartitioon datawarehouse?

    Hi,

    What would be the optimal/good/average/bad average bufferpool read
    times in a EEE data ware house environment?

    Also, is the operation of sending data over tablequeue will have
    affect because of high overall CPU I/O wait time? I was thinking it
    should not because communication is all dont at the memory level.
    Please correct me if i am wrong.

    Thanks'
    KC
Working...