[CR # 397229] Adaptive Server running on Solaris 10 operating system encounters performance degradation when using asynchronous I/O on file system devices.This creates severe performance degradation on single CPU machines and significant performance degradation on multi CPU machines under load. This is due to a bug in Solaris kernel, Sun BugID 6302167.
Workaround: When a patch is available from Sun for Sun BugID 6302167, installing the patch should resolve the problem. One of the following workarounds can be used to help miminize the performance degradation until this issue is resolved.
Use only raw devices.
On a multi CPU box, configure the number of Adaptive Server engines to be less than the number of CPUs.
On a single CPU box, set runnable process search count to 3 and start Adaptive Server with trace flag 1636. With this configuration, when a disk I/O is pending and no runnable processes are found after 3 scans by the Adaptive Server scheduler, Adaptive Server yields CPU so that other processes can be scheduled by the operating system.
| Copyright © 2006. Sybase Inc. All rights reserved. |
|
|
