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 :) 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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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
