Home Forums SQL Server 2005 Administering very high CPU, 0 I/O, no blocking, NULL in wait type? What could be possibly going wrong? RE: very high CPU, 0 I/O, no blocking, NULL in wait type? What could be possibly going wrong?

  • sqldba_newbie (10/31/2012)


    I have a select query which is in a "hung" state. I checked there is no blocking. From the activity monitor i see that Wait type is NULL. I do see very very high CPU and 0 on I/O. What could be wrong? Any advice?

    you can do .. select * from sys.dm_os_waiting_Tasks and join with sys.dm_exec_requests and sys.dm_exec_sessions to see whats going on ..

    Also, Adam Mechanic's sp_whoIsActive is another good stuff that will tell u whats going on currently.

    without giving more info about your environment and what steps u have taken to troubleshoot, its very difficult to help you.

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂