Viewing 2 posts - 1 through 3 (of 3 total)
I check it on activity monitor and there are no lock on the table, but
task state is "suspended"
wait type: PAGEIOLATCH_SH
wait Resource: 6:1:5539691
Not sure keep it running for few more...
May 24, 2013 at 1:53 pm
#1618438
Thanks Shaw for the tip. I will try that out.
May 21, 2013 at 3:11 pm
#1617199