Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

raw data size versus bufferpool/cache size

Go down

raw data size versus bufferpool/cache size Empty raw data size versus bufferpool/cache size

Post  hariza Sun Oct 10, 2010 11:32 pm

Hi All,

I just wondering if there is a rule of thumb or a formula that tells me when it comes to sizing the memory structures like Bufferpools/Buffer cache what would be the best/ideal/recommended size. I have a 2 TB datawarehouse and I believe we are not allocating enough resources (memory) but I need to be able to support my theory with something more concrete. This is running on AIX platform. Now users are noticing a slowdown in the response time and I believe this is as a consecuence of the memory structures not being sized accordingly. Please any comments will be highly appreciated. Thanks !!!!.



Posts : 1
Join date : 2010-10-10

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum