I am running a huge update statement and I am a little confused. (please see the attached). The process is showing as suspended but the the wait time and IO keep changing. But the last_batch shows as 2 days ago. Even with the CXPACKET and PAGEIOLATCH_ex (waitresource keeps changing too). Shouldn't i be seeing last_batch changing?
Also the CPU is at 1-3 %. There is nothing else apart from this query running on this server.
I am confused please can someone enlighten me.
Why is this?