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 🙂