up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
67% accept rate
Sorry I misunderstood. Let me see if I can figure it out. – citadelgrad Jul 14 '10 at 21:06
feedback

2 Answers

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.

link|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
feedback
up vote 0 down vote

Autogrow from Micorsoft support site.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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