This content has been marked as final. Show 3 replies
What you're JE cache size, compared to what DbCacheSize says it should be to hold all the internal nodes?
Thanks for the quick reply. The cache size was huge for all these tests: 25GB, so it should be able to contain all the data, although we are using EVICT_LN.
We are using a shared cache with other tables, that's why it is so big, but all these tests were run with this table only, to try to figure out what the issue is.
Thanks a lot for rapidly looking into this Mark, much appreciated.
The problem was related to the checkpointer interval, it was set to the default 20MB and it was creating too much information and the target utilization factor was never met.
I increased it to 128MB and it solved the issue. With 512MB the database size was even smaller (from 710 to 620 MB).