I have a SQL 2005 x64 server, and when I attempt to issue some queries against it (for example, when I try to create an index), my SPID goes to "sleeping" immediately, and seems to wait there indefinitely. It's not being blocked (the BLKBY column in SP_WHO2 is empty), and the CPU and DiskIO values are very small (under 300 each), and not growing.
What could my query possibly be waiting for? If I do a SELECT * off the table I'm indexing, I get all million rows back within a minute or so, so it's not blocked table access, or even (it seems) table contention.
Any thoughts on other things I could check? Do I just need to give in and restart my SQL instance? :)
DETAILS: I'm running the CREATE INDEX from another tab in SSMS, and it's never returning - it just shows Executing and never returns, so I don't think the process has been abandoned.