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] with the body: unsubscribe ntsysadmin
