.NET APPLICATION WITH SQL DATABASE - on a single server?

Question

5.00/5 (1 vote)

See more:

.NET3.0

We have a customised ERP solution under development for our College.

The software is developed under .net
Database is SQL Server
Windows Server 2008

The program is essentially an accounts and student management program purely for use within a single campus.

Maximum users are 6 at any one time (very unlikely), all of these are within a single closed fibreoptic network on campus. There may be periodic web based access for management review.

The developers have insisted on twin servers, one for the appplication and the second for the database. They claim that there will be substantial system slow down if the application and database reside on a single server.

Any server specification would also be a great help.

I would much appreciate any guidance.
Thank you.

Posted 29-Apr-11 1:04am

Manjit Gill

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ryan Zahra · Answer 1 · 2011-04-29T01:33:00

Solution 1

In my opinion, for just 6 users, its not worth the money to have a server for the application and a server for the software. However, if you're planning to add more users, yes you would need to have two servers.

Posted 29-Apr-11 1:33am

Ryan Zahra

Comments

Sergey Alexandrovich Kryukov 29-Apr-11 11:48am

Totally agree -- more then enough. My 5.
--SA

Manjit Gill 29-Apr-11 17:19pm

THank you for your comment. May I ask you what, in your view, would be the rough number of users which would require two servers?

Sergey Alexandrovich Kryukov 29-Apr-11 21:52pm

There is not direct correspondence. It depends. You could cover whole organization.
--SA

RaviRanjanKr 29-Apr-11 16:44pm

Perfect! My 5 too :)