Good point. A query on the past few years of data should indicate how much data is already stored annually, and how much it has grown year to year.
*ASB *(Find me online via About.Me <http://about.me/Andrew.S.Baker/bio>) *Exploiting Technology for Business Advantage... * On Sun, Feb 6, 2011 at 8:22 PM, Terry Dickson <[email protected]>wrote: > OK I have to ask, if you have historical data back to 1982 you should be > able to get a pretty good idea on growth. Just start adding the historical > and then check on size. > ------------------------------ > *From:* Ryan Finnesey [[email protected]] > *Sent:* Sunday, February 06, 2011 6:48 PM > > *To:* NT System Admin Issues > *Subject:* RE: forecast database growth? > > Thank you this is helpful. I need to design the storage and VMs that > will run BizTalk and SQL. I am just a bit uneasy because we will never > delete any data that comes in from the feed and we will also be adding > historical data going back to 1982 . > > > > *From:* Ken Schaefer [mailto:] > *Sent:* Sunday, February 06, 2011 6:17 PM > *To:* NT System Admin Issues > *Subject:* RE: forecast database growth? > > > > “grows quickly” is relative. I’ve got a DB that sometimes grows by around > 300m records/day. So more than 200,000 records/minute J > > > > In any case, if you are wanting to look at file size growth, it doesn’t > matter how many inserts you do per second/minute/whatever. Look at your row > size, and multiply by the number of inserts (you’ll reclaim free space > through deletes). > > > > Side note: when talking DBs, I would avoid saying “each update is an > insert” as that will start to confuse your DBAs. An update is a type of > query that alters an existing row of data. An insert appends a new row of > data. Inserts and updates are mutually exclusive. > > > > Cheers > > Ken > > > > *From:* Ryan Finnesey [mailto:[email protected]] > *Sent:* Monday, 7 February 2011 6:25 AM > *To:* NT System Admin Issues > *Subject:* RE: forecast database growth? > > > > So each update will be an insert and I will have thousands of new rows per > minute > so this database is going to grow quickly. > > > > *From:* Ken Schaefer [mailto:] > *Sent:* Sunday, February 06, 2011 5:34 AM > *To:* NT System Admin Issues > *Subject:* RE: forecast database growth? > > > > An update (that changes an existing row) isn’t going to cause any growth. > > > > Inserts will cause growth. Simply look at the size of each row (add up the > size of each column, then add a few % for overhead). If you know you are > adding 1 row/minute, and each row is 1KB, then you’ll be adding 60KB/hour. > > > > Cheers > Ken > > > > *From:* Ryan Finnesey [mailto:[email protected]] > *Sent:* Sunday, 6 February 2011 3:46 PM > *To:* NT System Admin Issues > *Subject:* RE: forecast database growth? > > > > Hey Andrew > > > > The database is going to update about once per minute, we will be receiving > the speed of the aircraft, altitude, latitude and latitude. In most cases > between updates the altitude and speed will remain the same but the latitude > and latitude will always be updated. We need to be able to query the > database and at any time within the flight have it return speed of the > aircraft, altitude, latitude and latitude > > > > Cheers > > Ryan > > > > > > *From:* Andrew S. Baker [mailto:] > *Sent:* Saturday, February 05, 2011 7:09 PM > *To:* NT System Admin Issues > *Subject:* Re: forecast database growth? > > > > Hey, Ryan > > > > That's largely going to be determined by the size and frequency of > updates... > > > > I'm not sure it's a tool that you need to resolve this issue, as much as > some indication as to what is going into the DB and how often. > > > > *ASB *(Find me online via About.Me <http://about.me/Andrew.S.Baker/bio>) > *Exploiting Technology for Business Advantage...** > * > * * > > > > On Sat, Feb 5, 2011 at 7:02 AM, Ryan Finnesey < > [email protected]> wrote: > > Hi All > > > > I am hoping the group can help me out. We will soon be designing an > application that will be holding location information on aircraft in flight; > we will be receiving a large number of XML messages with this location data > that we will process with BizTalk and them feed into SQL. Are there any > tools we can use to forecast database growth? > > > > Cheers > > Ryan > > > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > > This message is for the designated recipient only and may contain > privileged, proprietary, or otherwise private information. If you have > received it in error, please notify the sender immediately and delete the > original. Any other use of the email by you is prohibited > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > ------------------------------ > CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential. > If you are not the intended recipient, you do not have permission to > disclose, copy, distribute, or open any attachments. If you have received > this e-mail in error, please notify us immediately by returning it to the > sender and delete this copy from your system. > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
