[CR #428851] While stress testing Unwired Accelerator for Linux on POWER at 1000 users, testers noted Adaptive Server Enterprise consuming 100% CPU. Making changes to several configuration settings alleviated the problem.
Workaround: If you note high CPU usage, try the following to improve Adaptive Server Enterprise performance:
Modify configuration parameters:
sp_cacheconfig – increase the default data cache to 200MB:
sp_cacheconfig "default data cache",
"200M"
sp_configure – lower the runnable process search count from 2000 to 3:
sp_configure "runnable process
search count", 3
The following sp_configure changes may yield additional, minor performance improvements:
Increase the procedure cache by about 1/2 MB per user, maybe a little less:
sp_configure "procedure cache",
150000
Increase the number of CPUs with which Adaptive
Server Enterprise starts up, to 2 or more: sp_configure
"number of engines at startup", 2
The following sp_configure changes were not tested in this situation, but may also improve Adaptive Server Enterprise performance when used with Unwired Accelerator for Linux on POWER:
sp_configure "max parallel degree,
2"
sp_configure "max scan parallel degree", 2
sp_configure "sort buffers", 5000
sp_configure "stack size", 393216
sp_configure "number of open objects", 2000
sp_configure "user logs cache size", 8192
See the Adaptive Server Enterprise documentation on the Getting Started CD for more information about Adaptive Server Enterprise commands and performance tuning.
