G
George Potemkin
Guest
> 1) AI Empty waits have gone down from 0.5-1 to practically 0. What is the impact of this on the user? Positive impact. ;-) But I would check the latch statistics. > 3) BI Busy waits have increased from 0.02. Is this a concern? If transaction performance is increased after you eliminate the bottleneck on AI writes then the competition for BI buffers is increased as well. > 4) BI Write % has dropped from ~85% to ~45%. What is the reason for this, and the impact, if any? It's normal. AIW writes to BI file before AI file when it's needed.
Continue reading...
Continue reading...