I am using the Autogrowth option for my database.

If I had to choose between growing more often and small amounts or growing
less often but bigger amounts, which is the better option?

Is there a maximum % threshhold of how much I should set my database to grow
by?

Is there a recommended % to grow?

you should try to understand your current growth volumes.
If you do this, you can implement a better growth policy - but to answer
your question, I would go with the 'grow less but bigger amounts'.
This will mean you won't in to fragmentation problems too quickly.

Immy
"Diane" <Diane@discussions.microsoft.com> wrote in message
news:AB7F907B-F83D-4F21-930B-8ADA017B49BD@microsoft.com...
>I am using the Autogrowth option for my database.
>
> If I had to choose between growing more often and small amounts or growing
> less often but bigger amounts, which is the better option?
>
> Is there a maximum % threshhold of how much I should set my database to
> grow
> by?
>
> Is there a recommended % to grow?
>
>

forgot to paste this in too...
http://support.microsoft.com/kb/315512/


"Diane" <Diane@discussions.microsoft.com> wrote in message
news:AB7F907B-F83D-4F21-930B-8ADA017B49BD@microsoft.com...
>I am using the Autogrowth option for my database.
>
> If I had to choose between growing more often and small amounts or growing
> less often but bigger amounts, which is the better option?
>
> Is there a maximum % threshhold of how much I should set my database to
> grow
> by?
>
> Is there a recommended % to grow?
>
>

Generally, the option you didn't list would be considered
better for a production system. You typically do not want to
use autogrow on production systems. It's resource intensive
and will negatively impact current activity in the database
as well as overall system performance. It's something you
would want to manage yourself and if the file size needs to
be increased, you would do this during off hours.
If you really had to use autogrow, you don't want it to kick
in often. So growing often in small increments wouldn't be
recommended. What growth factor to use really depends a lot
on your environment. I don't know think I would use a
percent but would rather determine an appropriate fixed
amount to use for growth.
You can find more information and recommendations from
Microsoft in the following article:
INF: Considerations for Autogrow and Autoshrink
configuration in SQL Server
http://support.microsoft.com/?id=315512

-Sue

On Wed, 27 Sep 2006 05:54:02 -0700, Diane
<Diane@discussions.microsoft.com> wrote:

>I am using the Autogrowth option for my database.
>
>If I had to choose between growing more often and small amounts or growing
>less often but bigger amounts, which is the better option?
>
>Is there a maximum % threshhold of how much I should set my database to grow
>by?
>
>Is there a recommended % to grow?
>

Thanks - that is just what I needed!!!!!

"Immy" wrote:

> forgot to paste this in too...
> http://support.microsoft.com/kb/315512/
>
>
> "Diane" <Diane@discussions.microsoft.com> wrote in message
> news:AB7F907B-F83D-4F21-930B-8ADA017B49BD@microsoft.com...
> >I am using the Autogrowth option for my database.
> >
> > If I had to choose between growing more often and small amounts or growing
> > less often but bigger amounts, which is the better option?
> >
> > Is there a maximum % threshhold of how much I should set my database to
> > grow
> > by?
> >
> > Is there a recommended % to grow?
> >
> >
>
>
>