InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 08:05:02 GMT20http://www.sqlservercentral.com/Forums/Topic1379426-146-1.aspx[quote][b]sqldba_newbie (10/31/2012)[/b][hr]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?[/quote]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.Fri, 02 Nov 2012 10:58:02 GMTSQLQuest29http://www.sqlservercentral.com/Forums/Topic1379426-146-1.aspxFind out which SPID it is using and do a SP_WHO2 xxx where xxx is the SPID of the running query. Run this a few times to see if the CPU and I/O are increasing.Also, do an explain plan on it to see if it is using indexes or table scans. Then see if you can add tuning indexes to make it run more efficiently.Also, change the SELECT statement to SELECT COUNT(1) to see if it will, somewhat quickly tell you how many rows it should return. Does it return 1 row, 500 rows, 20 million....Other questions....Has this query run before... on a regular basis... did it run quickly before and all of a sudden gone crazy.How big is the table(s), are stats up-to-date... could reindexing the tables be an option?Fri, 02 Nov 2012 06:20:07 GMTMarkushttp://www.sqlservercentral.com/Forums/Topic1379426-146-1.aspxcan you please post the Query.is it linked server related query ?Thu, 01 Nov 2012 01:44:55 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1379426-146-1.aspxHas this query been regularly as OK? or is it a new query?Are the statistics up to date?Have you checked sys.dm_exec_requests for more detailed information?Wed, 31 Oct 2012 11:02:22 GMTJack Vamvashttp://www.sqlservercentral.com/Forums/Topic1379426-146-1.aspxI 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?Wed, 31 Oct 2012 10:31:15 GMTcurious_sqldba