specing out how much resources are need for a project.

[opkpapp11]

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)?

 

[mrdenny]

This isn't a whole lot of information to go on.

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

 

[JackVam]

What's your backup strategy?
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