Environment
Novell ZENworks 10 Configuration Management
Novell ZENworks 11 Configuration Management
Situation
On Windows multiprocessor servers, sometimes dbsrv10 process may show very high utilization on one processor.
Resolution
If CPU utilization for dbsrv10 does not consistently stay at 100% or cause general slowdown, the CPU utilization is not a problem. It is not helpful to try to force MT/MP support through command line switches.
In the latest releases of Sybase server, the dbsrv10 process requests run on one CPU as much as possible. See Sybase documentation at http://dcx.sybase.com/html/dbwnen10/wn-new1001-s-3634293.html
If the utilization stays high and does not allow other processes to run, the -cl switch to increase the initial cache size may be helpful. For more information about -cl switch search for cl in the Sybase documentation at http://www.ianywhere.com/developer/product_manuals/sqlanywhere/
Switches can be added to zenworks_database.conf after stopping the service. Make a backup of that file prior to any changes, and save it outside of the zenworks path for safekeeping. Restore it if the switches cause problems on service start or performance.
Additional Information
ZCM 11.1 and later ship with Sybase SQLAnywhere version 12.0.
By Default, this version will balance the load between across all CPU cores due to the use of an enhanced thread scheduler.