> I installed SAP on a xeon dual processor usig linux (debian 3.0r1) > > watching the performance of each processor I notice that sap > doesnt use both processor but 1 at time > if one of the processors reach 100% the it start using the other
Check the kernel parameters _TASKCLUSTER_01 / 02 / 03. If one of these contains the string 'compress' (which is the default for MAXCPU == 1), then the behaviour is understandable. Change this value to 'equalize', this will distribute sessions among UKTs (User Kernel Thread) evenly. If the value is already set to 'equalize', then try the following: dbmcli -d ... -u ... show process Important are the columns UKT and TASK, not all of the User-TASKS should have the same UKT number. Other tasks types are handled differently, so don't worry if some tasks have a private UKT. If the sessions are indeed distributed among the TASKS, then there is always the possibility that the Linux threading library doesn't distribute the threads among the CPUs. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
