This content has been marked as final. Show 5 replies
Does the cache have to be that big? I'll bet that it doesn't make that big of a difference in calc speed. Fast drives -- now those make a big difference in BSO calcs. Massive amounts of cache not so much.
Should this even be a BSO database? That is getting pretty big for an agg it up database in BSO. You would be pleasantly shocked to see the size, memory requirements, and speed in ASO.
You can always buy more memory but I'd think about the two above points before going down that path.
Just some food for thought.
The problem when you follow those OLD settings is , When an application starts, the amount of memory set for the index cache is reserved and not lot go of until the application is stopped. So if you said give the index cache 2 gig, even if the actual index is 8 meg it will reserve the entire two gig. Especially on 64 it systems we find that many times smaller caches work better than large ones as it give the operating system more chance to manage memory better
By setting cache sizes large you prevent the op system from keeping things in ram that are most frequent needed
This is done using memory mapped io automatically.
So set the caches low except during calculations then since you want to have the index files in ram
Much more than the data files you would raise the index cache just b4 the calc and lower it afterwards. Do it for loads also (large ones not simple lock and sends)
I agree with Cameron this might do better as ASO but I also note that the ratio of index file size to data file size is quite large consider increasing your block size.
The dbag is not the bible/gospel or silver bullet. It is what it says it is, a guide. There is nothing like some real world experience to highlight that. In other words, your cache settings are way to high. Although it may say you index needs to be this, and your data cache that, you have to take into account other factors. For example, how many apps you have running, what is your system specs, does increasing the cache actually make any difference in loads, calcs or retrieves. Especially with BSO there is such an art to how to develop and administer a cube.