• thank you Manu, that's exactly where i got it from. My question is , in the article it says to check for values in the thousands for the CPU, i just wanted to find out how it is counted KB? Another thing, when i run this

    select * from master..sysprocesses

    where status = 'runnable'

    order by CPU

    desc

    I get a lot of lastwaittypes SOS_SCHEDULER_YIELD

    with cpus from 8k-10k, when i run the

    DBCC INPUTBUFFER (spid)

    then i get that is an rpc events, so these indicated that these stored procedures are taking high CPU Processor%?

    Another question,

    yesterday we were having slowness issues in the server and i run this

    select * from master..sysprocesses

    order by CPU

    desc

    *without the status filter

    this is what i got:

    CPU :127743

    Status: sleeping

    lastwaittype: MISCELLANEOUS

    programn name: Replication-LogReader

    cmd:AWAITING COMMAND

    Could this be the problem? or should i ignore it since the status is sleeping?