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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


raw data size versus bufferpool/cache size

Kimball Forum :: Topics :: Technical Architecture and Related Technologies

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 !!!!.

Harby.

hariza

Posts : 1
Join date : 2010-10-10

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Technical Architecture and Related Technologies

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