b52ca190   
   From: genew@ocis.net   
      
   On Thu, 7 Apr 2011 12:23:49 -0700 (PDT), Dom    
   wrote:   
      
   >At 8:00 am Wed, we started a Shrink Database command (though the SSMS   
   >GUI) on a very large and very active database.  The activity monitor   
   >usually show the process is "suspended" (what does that mean?)   
   >although sometimes when I click "Refresh" it says "runnable".   
      
        The standard meanings are   
      
   suspended: The process is not running but has not been terminated.   
   runnable: The process is eligible to run.  (If a process were waiting   
   on I/O, it would not be runnable until the I/O completed.)   
      
   >It is now 3:30 pm Thurs, and the Shrink Database is still going on.   
   >Should I be worried about this?  As I said, it is a large database,   
   >with a fair amount of activity, and we recently added a good amount of   
   >data, and deleted some unnecessary tables.   
      
        Based on your first paragraph, it is not doing anything.   
      
        I hope someone else who knows details can advise you on what to   
   do at this point.   
      
        My best guess is that the process has been suspended by   
   someone/something and that you should unsuspend it.   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)