Recently I've installed a new Compaq Proliant server with 2 XEON hyperthread Processor and installed Linux 7.3, Sybase 188.8.131.52
TOP command show 4 CPU but when I tried to print Year End report and it only use the 1st processor 100% the rest just take about 5~10% occasionally
The Sybase configuration file I've changed the "Max online engines = 4"
So is there anyway to contribute all the CPU processing power to the Sybase??
In 184.108.40.206 a single command will only run on a single thread (i.e. a single engine). In later versions (12.x in particular) you can enable parallel queries which can improve the performance significantly.
Everything really depends on the workload, from moment to moment. Unless the workload is truly "CPU bound," as database workload rarely is, you just won't see "100% pegging-the-meter" CPU utilization very often. Not with a database.
What you will see is an "I/O bound" workload, where the ruling constraint is how fast an I/O operation can be serviced.