• While the query is running, use the sys.dm_os_waiting_tasks view to determine the wait type for the query. Do that several times, just in case it's waiting on lots of different resources one after another. You might want to check out Adam Machanic's sp_whoisactive stored procedure, which takes the hard work out of doing stuff like this.

    John