Extending Cache Size Beyond 1.8 GB Using 32 Bit Windows
The best and simplest option for getting optimal performance from a large database is to run it on a 64 bit Windows system with an abundance of RAM. Ideally, you would have enough RAM installed in your system so that the entire database could be cached. In that case, allowing a larger cache is simply a matter of increasing the value in the –ch parameter in the STDALONE.PRM or SERVER.PRM file located in the SOS folder on your standalone SOS computer, or your SOS database server computer, respectively. If you have, for example, 12 GB of RAM in your 64 bit system, you could allocate 10 GB of that RAM for potential use as database cache by including:
-ch 10g
in your PRM file.
Windows 32 bit platforms, however, normally would limit you to 1.8 GB, regardless of the amount of physical RAM in the computer. If your are running your database on a 32 bit version of Vista, Windows 7, or Server 2008, you can make a simple modification to quickly boost the maximum RAM you can allocate for cache from 1.8 GB to 2.7 GB.
See: http://www.sosoft.com/userdocs/?p=76
----------
CACHE LIMIT 32 64 BCDEDIT -CH SERVER ENTERPRISE DATACENTER AWE INCREASEUSERVA SERVER.PRM
-ch 10g
in your PRM file.
Windows 32 bit platforms, however, normally would limit you to 1.8 GB, regardless of the amount of physical RAM in the computer. If your are running your database on a 32 bit version of Vista, Windows 7, or Server 2008, you can make a simple modification to quickly boost the maximum RAM you can allocate for cache from 1.8 GB to 2.7 GB.
See: http://www.sosoft.com/userdocs/?p=76
----------
CACHE LIMIT 32 64 BCDEDIT -CH SERVER ENTERPRISE DATACENTER AWE INCREASEUSERVA SERVER.PRM