title: SQL Server query stuck, but running with no wait
body: <p>I have an SSIS package that is running an execute SQL task, that calls a proc. The query I am dealing with is nasty, developed by vendor, which is actually nested a couple proc's deep. To add to that it uses temp tables from the parent proc as well as two nested <code>NOT IN</code> subqueries. </p>
  
  <p>Currently not able to rewrite, but the question is more on identifying what could be causing the issue. The query, like mentioned, is poor but typically runs quickly, however it is stuck now. Looking at the query from <code>dm_exec_requests</code> I can see that it is in the <code>RUNNING</code> state and no waits. I see no activity from I/O, not any real CPU activity. </p>
  
  <p>Is there a way to identify what is actually going on with the query? </p>