Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

sql last batch not updating Expand / Collapse
Posted Tuesday, July 30, 2013 4:06 AM


Group: General Forum Members
Last Login: Monday, July 27, 2015 8:26 AM
Points: 197, Visits: 515
Hi ,

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?

Many thanks

  Post Attachments 
Capture.JPG (8 views, 45.33 KB)
Post #1478897
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse