Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    72

    Unanswered: Cpu utilization 100%

    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.

  2. #2
    Join Date
    May 2006
    Posts
    17
    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

  3. #3
    Join Date
    May 2006
    Posts
    17
    Hello,

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

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •