Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

specing out how much resources are need for a project.

Status
Not open for further replies.

opkpapp11

Programmer
Jan 31, 2008
9
US
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)?
 
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
 
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 -
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top