April 2, 2014 at 5:09 pm
Hey guys. I am trying to shrink a file with emptyfile command in it, and for some reason it got stuck. When I check the processes, I see that my SPID is SUSPENDED on DbccFilesCompact command. Over the last two hours, DiskIO only changed to 175, which tells me that it hasn't moved at all. Any chance someone knows how to troubleshoot this? Doesn't seem like it's getting blocked, at least that's what sp_who2 tells me.
April 2, 2014 at 5:46 pm
What is the WAIT_TYPE for that process?
use sys.dm_exec_requests DMV for that session and look at the wait_type column
Regards,
Nawaz.
April 2, 2014 at 5:52 pm
PAGEIOLATCH_EX
April 2, 2014 at 6:03 pm
Then it is for sure to do with your IO sub system.
For larger DBs and Slow DISKs this might be expected. Because I personally had an experince of shrinking a production DB for more than 3 hours (During which I had panicked :-P).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply