Posted by Erland Sommarskog on 05/28/05 00:35

Greg D. Moore (Strider) (mooregr_deleteth1s@greenms.com) writes:
> "jlgreg36" <jlgreg@hotmail.com> wrote in message
> news:1117190814.354304.267170@z14g2000cwz.googlegroups.com...
>> We use SQL 2000 and our database is configured to grow automatically by
>> 10%. Currently 96% of our database is used. At what point will the
>> database expand - what is the trigger point?
>
> When it's full.

More precisely, where there are no more free extents, and SQL Server
needs a new extent. At this point, there is still some free space
available in the database, although this is only of academic interest.

> Generally you're better off monitoring it yourself and allocating space as
> required. Or at the very least allocate fixed amounts of diskspace so you
> don't get into a geometrically increasing amount of time for each
> allocation.

Completely agree!


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]