From my top command output
-----------------------------------------------------------
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

19967 sybase 15 -1 123m 89m 88m R 82 1.1 171:00.33 dataserver

sometimes CPU% going upto 99 to 100% also.

Can somebody please suggest me immediately how to overcome the issue.

Thank you.

Hello,

Install montables and run the query down to identify the command runing and using 100% of the cpu.

select sp.ipaddr,
s.SPID,
s.CpuTime,
s.PhysicalReads,
s.PacketsSent,
s.PacketsReceived,
t.LineNumber,
t.SQLText
from master..monProcessStatement s,
master..monProcessSQLText t,
master..sysprocesses sp
where s.SPID=t.SPID
and sp.spid=s.SPID
order by s.CpuTime desc

Hello,

The file QCSYB_SQL_Tuning_270_ReadMe.pdf will help to you install montables.

.._..{@mBros!o}.._..