Post reply

what this mean: high CPU and Zero I/O and Zero Memory in sysprocesses

  • December 2, 2009 at 12:14 pm

    #228287

    Hi,

    Recently, I faced one performance issue. SQL server became non responsive with 100% cpu utilization. I ran this query (select * from master..sysproceses order by CPU Desc) to find the high CPU utilized query. Below were top 2 rows of this query, you can see CPU value is high but I/O and memory is 0. After canceling the query (related to SPID 142). server CPU returned to normal. just wanted to know, in what situaltion I/O and memory usage can be 0 with high value of CPU

    SPID KPID Blocked LastwaitType dbid uid CPU phy_IO Memory status

    142 23740 0 SOS_SCHEDULER_YIELD 8 12 932188 0 0 runnable

    142 23808 0 SOS_SCHEDULER_YIELD 8 12 925671 0 0 runnable

    -thanks in advance

  • December 2, 2009 at 1:37 pm

    #1086744

    double post

    answered the primary post at http://www.sqlservercentral.com/Forums/Topic827726-360-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply