I am busy tuning performance of a large database. (5Gb)
What will be the best cache size? I have 1Gb Ram.
Is it a good idea to take the maximum cache size of 90%?
There are no other processes on this machine, so it only run that dbsrv6.exe. Yes, still version 6 :-((
Or is it better to have a smaller cache, and leave more memory for queries to be prcessed?
I've read somewhere that it is a good idea to take 25% of memory, so 256Mb. Is that true?