Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When a SQL2005 Server's Autogrow is enabled. At which size does this operation take place? Is it triggered on Percentage / Based on statistic's / ...

Is this a thing i can configure? I mean not the Autogrow (Percentage/fixed size) itself but just when the grow takes place.

share|improve this question
Sorry I misunderstood. Let me see if I can figure it out. – citadelgrad Jul 14 '10 at 21:06
up vote 1 down vote accepted

I could not figure it out myself and since I spend so much time digging around on Paul Randal's (SQL MVP) blog I decided to ask him. Here is his response.

[Autogrow] triggers at 100%, non-configurable. You can roll your own trigger based on an alert and manual growing.

share|improve this answer
I know that i can configure the grow. But when does it happen? Initial DB Size = 1GB / 20% Grow >> When will it start to grow to 1200 GB? Is it when the DB is filled 80% /800MB or does SQlserver wait untill the 1GB is really full? – icnivad Jul 14 '10 at 8:32
@Paul has always the final say regarding SQL Serer=) – DaniSQL Jul 15 '10 at 14:46
Thanks for finding that out ;-) – icnivad Jul 21 '10 at 8:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.