SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


estimation of databse growth


estimation of databse growth

Author
Message
ramyours2003
ramyours2003
SSCarpal Tunnel
SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)SSCarpal Tunnel (5K reputation)

Group: General Forum Members
Points: 4987 Visits: 2973
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
GSquared
GSquared
SSC Guru
SSC Guru (126K reputation)SSC Guru (126K reputation)SSC Guru (126K reputation)SSC Guru (126K reputation)SSC Guru (126K reputation)SSC Guru (126K reputation)SSC Guru (126K reputation)SSC Guru (126K reputation)

Group: General Forum Members
Points: 126797 Visits: 9730
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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (301K reputation)SSC Guru (301K reputation)SSC Guru (301K reputation)SSC Guru (301K reputation)SSC Guru (301K reputation)SSC Guru (301K reputation)SSC Guru (301K reputation)SSC Guru (301K reputation)

Group: Administrators
Points: 301148 Visits: 20005
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
My Blog: www.voiceofthedba.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search