Database Growth Settings

Question

Database Growth Settings

Gary Williams-141117

Newbie

Points: 1
More actions
June 12, 2008 at 5:03 am

#192082

Some of our databases have chnaged there settings to growth by 6400 % ???

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004646 More actions · Answer 1

Not likely the database did it... either a human or some other program did it. Finding out what changed it will take some doing, though.

Should never grow by percent, by the way. Fixed size is better and you should plan it instead of just allowing it to happen.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 2

If I remember correctly there is a bug in SQL 2005 somewhere that changes the growth to an unbelievable growth rate. I found this with one of our databases as well. I cannot remember the details though.

Wilfred van Dijk SSCrazy Eights Points: 9003 More actions · Answer 3

found this link: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127177

Wilfred
The best things in life are the simple things