Automatic FileGrowth

At what point does SQL actually begin the file growth?
Is it when the database reaches a secific percentage of
the file size or when the database reaches a specific
size. For example, if I have a 100GB database (90 GB
used, 10GB free) and it is set to grow 10%, does the
database grow 10% when the database reaches 91GB or when
it reaches 100GB?It doesn't grow until it is 100% full and more space is needed due to some
SQL statement is executed (an INSERT, for instance).
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Philip Wilhelm" <philip.wilhelm@.astongroup-us.com> wrote in message
news:05ca01c3a92e$c81d2990$a501280a@.phx.gbl...
> At what point does SQL actually begin the file growth?
> Is it when the database reaches a secific percentage of
> the file size or when the database reaches a specific
> size. For example, if I have a 100GB database (90 GB
> used, 10GB free) and it is set to grow 10%, does the
> database grow 10% when the database reaches 91GB or when
> it reaches 100GB?|||Philip
http://www.sql-server-performance.com/database_settings.asp
"Philip Wilhelm" <philip.wilhelm@.astongroup-us.com> wrote in message
news:05ca01c3a92e$c81d2990$a501280a@.phx.gbl...
> At what point does SQL actually begin the file growth?
> Is it when the database reaches a secific percentage of
> the file size or when the database reaches a specific
> size. For example, if I have a 100GB database (90 GB
> used, 10GB free) and it is set to grow 10%, does the
> database grow 10% when the database reaches 91GB or when
> it reaches 100GB?