I am not going to be storing the XML itself in the database but I am going to use BizTalk to pull into out of the XML file and send it into SQL. Your URL is helpful thank you
- <asdiMessage sourceFacility="CCZY" sourceTimeStamp="2009-09-21T12:34:30Z" trigger="TZ"> - <trackInformation> <nxcm:aircraftId>ACA117</nxcm:aircraftId> <nxcm:speed>280</nxcm:speed> - <nxcm:reportedAltitude> - <nxce:assignedAltitude> <nxce:simpleAltitude>103</nxce:simpleAltitude> </nxce:assignedAltitude> </nxcm:reportedAltitude> - <nxcm:position> - <nxce:latitude> <nxce:latitudeDMS degrees="43" minutes="51" direction="NORTH" /> </nxce:latitude> - <nxce:longitude> <nxce:longitudeDMS degrees="079" minutes="50" direction="WEST" /> </nxce:longitude> </nxcm:position> </trackInformation> </asdiMessage> From: Ziots, Edward [mailto:[email protected]] Sent: Monday, February 07, 2011 8:20 AM To: NT System Admin Issues Subject: RE: forecast database growth? What datatype are you going to be using to store the XML files in SQL? BLOB, NTEXT, NVARCHAR? Big Int Small Int? etc etc. Each of these data types take a certain amount of space, so you could say that an average of X number of XML messages a day X the average storage for a message and then extrapolate from there. Or you can do a pilot and create the database structure the way you want it, and then put it through its paces and measure the growth from there. The following MSDN article below has information on the data-types. http://technet.microsoft.com/en-us/library/ms172424.aspx Z Edward E. Ziots CISSP, Network +, Security + Network Engineer Lifespan Organization Email:[email protected] Cell:401-639-3505 From: Ryan Finnesey [mailto:[email protected]] Sent: Saturday, February 05, 2011 7:03 AM To: NT System Admin Issues Subject: forecast database growth? 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 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
