We are running a very large finacial system on Sybase ASE 12.5. At peak time, there could be thousands of queries per second.
The database is running on a 48 CPU Sun box with Solaris 8 and 100 GB memory. Now the whole database is cached, and no physical I/O is detected.
However, we found out that with more than certain amount of CPUs, the overall performance degraded. So even if the machine has 48 CPUs, we only gave ASE 34 of them.
Does anybody have similar experience with ASE? Is this a Sybase scalability issue? Any idea how to solve it?