cancel
Showing results for 
Search instead for 
Did you mean: 

How does BIA reflect on DB buffer quality?

former_member255800
Discoverer
0 Kudos

Hi,

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?

Regards

Yüksel Tiryaki

Accepted Solutions (1)

Accepted Solutions (1)

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.

Answers (0)