Showing results for 
Search instead for 
Did you mean: 

How does BIA reflect on DB buffer quality?

0 Kudos


since we have BIA in use the DB buffer quality decrease below 95%. Before we had about 98%. From the disk reads I can see that the logical reads are quite below the numbers before we had BIA in use. So I assume that the access to BIA doesn't reflect on db buffer at all and the missing numbers for logical access are the reads from the BIA. Could somebody verify my assumption please?


Yüksel Tiryaki

View Entire Topic
Former Member
0 Kudos

Data on the BIA is on it's own server and stored in memory. When a query runs and uses BIA, no access to the data in BW occurs, so seeing a lower buffer utilization rate could be expected when compared to pre-BIA results.