Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #144

Re: Shrink Database problem!!!

Show all headers | View raw

On Thu, 7 Apr 2011 12:23:49 -0700 (PDT), Dom <dolivastro@gmail.com>
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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Shrink Database problem!!! Dom <dolivastro@gmail.com> - 2011-04-07 12:23 -0700
  Re: Shrink Database problem!!! Gene Wirchenko <genew@ocis.net> - 2011-04-07 14:07 -0700
  Re: Shrink Database problem!!! Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 23:32 +0200
  Re: Shrink Database problem!!! ravi p <zygonr@airtel.blackberry.com> - 2011-04-08 06:44 +0000
    Re: Shrink Database problem!!! Dom <dolivastro@gmail.com> - 2011-04-08 07:26 -0700

csiph-web