We would like to know what limitations there may be (if any) on Sybase ability to use this additional memory. What is the maximum memory which can be allocated to the database instance ?
The answer is in the document linked in the previous post...
You can clearly see that ASE 12 32bits on solaris 8 (sparc processor) cannot handle more than 3.78 GB. if you have ASE 12 64bits you can handle 16 Exabytes (theorical maximum)
Originally Posted by amitabh_kaushal
Also, Sun fire have Hyper-thread CPUs – will the O/S and database (Sybase) view the proposed system as a true 4 CPU platform?
I'm not aware about Hyper-thread technology but if you can see 4 CPU on unix side (using top for instance) you can setup 4 engines with sybase. (1 engine per cpu)