specing out how much resources are need for a project.
specing out how much resources are need for a project.
(OP)
I need help specing out the resources i need for this project.
here is what i have:
I am looking at a project that will have around 1000 people using a vb.net application to send insert row commands to a SQL Server 2005. The row they insert has around 2500 charaters in it. on average everyone will submit 1 row a day. Everyone is on the same network but they are spread throughout the US.
Does anyone know what kind of server resources will i need for this(memory, processing power, bandwidth)?
here is what i have:
I am looking at a project that will have around 1000 people using a vb.net application to send insert row commands to a SQL Server 2005. The row they insert has around 2500 charaters in it. on average everyone will submit 1 row a day. Everyone is on the same network but they are spread throughout the US.
Does anyone know what kind of server resources will i need for this(memory, processing power, bandwidth)?
RE: specing out how much resources are need for a project.
All they are going to do is insert a single record per day. No one will be looking at the records? Nothing will be searching the records.
What's the table structor look like? Will there be only a single table? What's the purpose of the application? How long do you have to keep the data for? What's the assumed growth rate?
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)
My Blog
RE: specing out how much resources are need for a project.
Are you doing auditing?
How will trap/handle errors?
1000 people adding 1 record a day , is not a big system. Worth looking at how the vb apps handle the connections , i.e close them etc
Jack Vamvas
All the IT jobs in one place - http://www.ITjobfeed.com