estimation of databse growth

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » estimation of databse growth

estimation of databse growth

Rate Topic

Display Mode

Topic Options

Author

Message

ramyours2003

Posted Thursday, August 20, 2009 8:13 AM

Old Hand

Group: General Forum Members
Last Login: Today @ 3:03 AM
Points: 364, Visits: 1,510

HI ,

as a DBA how can we estimate the size of the database at the time of creating database in production servers and what factors need to be considered while we are selecting the autogrowth option .

replies are valuable .

thanks

Post #774236

GSquared

Posted Thursday, August 20, 2009 8:41 AM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

First, you look at the data-size expected in the tables, and you look at the expected volume of inserts and deletes. That'll tell you what to expect for each table. Add those together, remembering to include indexes, and perform the necessary math, and you'll have a good idea of the expected size of the database.

Or, for a "rule-of-thumb" solution (less math, more looking), set up a copy of the database and load it up with test/fake data. For example, if you have an orders table, and you expect 100 orders per day, insert 18,000 rows of data into it (enough for about 6 months). Do the same sort of thing for each of the other tables. See how big the database ends up, and how fast it grows, and use that as a starting point.

If you don't want to do all that work yourself, RedGate has a data generator that'll do it for you.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #774271

Steve Jones - SSC Editor

Posted Thursday, August 20, 2009 8:42 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526, Visits: 13,864

Read this: http://msdn.microsoft.com/en-us/library/ms187445.aspx

However the big factor is how much growth you are going to have from new data. If you have no idea what load you'll have, however people will enter data (or systems will), then there's nothing you can do.

What you can, and should, do is track this and regularly adjust the size of the database. Autogrowth is an emergency option, not the way to manage space.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #774274

« Prev Topic | Next Topic »

Permissions