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
Author
Message
Posted Tuesday, July 30, 2013 4:06 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 4:35 AM
Points: 193, Visits: 504
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