I have a doubt about SMP. Currently we are using
Adaptive Server Enterprise/188.8.131.52/1287/P/SWR 10031
ROLLUP/Sun_svr4/OS 5.5.1/FBO/Tue Mar 12 04:38:12 2002
Sun Microsystems sun4u Sun Enterprise 420R (4 X UltraSPARC-II 450MHz)
Sybase is not yet configured for SMP.
In last few days I am seeing pretty high usage of CPU(90%).
Most of the time , I see a process which is in SLEEPING state and
shows COND in cmd column of sp_who o/p....
What is the meaning of COND sysprocesses.cmd column ?
If this process is not present , Sybase CPU utilisation is ard 30%
Here is o/p from sysprocesses for that spid ...
spid kpid enginenum status suid hostname program_name hostprocess cmd
cpu physical_io memusage blocked dbid uid gid tran_name time_blocked
network_pktsz fid execlass priority affinity id stmtnum linenum
10 13107275 0 sleeping 3 13745 COND 0 9972 12 0 5 1 0
$user_transaction NULL 512 0 EC2 MEDIUM ANYENGINE 465436732 3 82 NULL
Given the circumstances , shd I configure Sybase with 1 more CPU &
bind the process to that CPU ? But problem here is all the processes
use same login . In this case can I bind that process ?
Also can I disable SMP afterwards? Is it possible ?
Any help is kindly appreciated ....