ansaurus

Question

Answer 1

+1 A:

If I recall correctly the interface will leave about 20% grown space, running DBCC SHRINKDATABASE without any parameters shrinks it to as small as possible.

I don't have Enterprise Manager handy to check the defaults. But you should notice a smaller database file with the manual run than the GUI run, thus the time difference

Mitchel Sellers 2008-10-14 19:08:22

The gui default is actually to leave 0% free space.

JosephStyons 2008-10-14 19:12:37

odd, mine is set to 20%, but who knows what happened there.

Mitchel Sellers 2008-10-14 19:22:00

hm, maybe someone set it to 0% in the past and it saved the pref. anyway, it is fast in the gui and slow from Query Analyzer.

JosephStyons 2008-10-14 19:48:36

doing some checking, I can't see anything that would support the difference, other than some potential optimization of the interface on the GUI side.

Mitchel Sellers 2008-10-14 20:03:27

Well... upvote for the research, but I guess the Jury's still out on this one...

JosephStyons 2008-10-14 21:13:04

Thanks, it is really odd, I'm googling far and wide, and I get nothing for sure. How much of a time difference are we talking?

Mitchel Sellers 2008-10-14 21:24:00

From the GUI it took about 5 seconds, from Query Analyzer it was "go get a cup of coffee and chat with a co-worker" slow. Probably 15 mins or so.

JosephStyons 2009-01-05 19:28:34

ansaurus

tags:

views:

answers:

Sql Server SHRINKDATABASE command

related questions