[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 337
  • Last Modified:

Web portal and database on same server

Hi All,

One of our developer is thinking of setting web portal which access a database for records on the same server as our database server. We had the web portal on another server from security purposes and that it won't put too much load on our database server but he is insisting to have them both on same server.

Can anyone please share your thoughts on this in regards to advantages and disadvantages? Please give your reasons in full details.

Thanks
0
skyjumperdude
Asked:
skyjumperdude
  • 3
  • 3
  • 3
  • +1
2 Solutions
 
Scott Fell, EE MVEDeveloperCommented:
Would the web portal serve 100, 1,000 or 10,000 people at any given day?
0
 
skyjumperdudeAuthor Commented:
May be 1000
0
 
Dave BaldwinFixer of ProblemsCommented:
If it is already up and running on the other server, I would not want to move it without a very good reason.  It won't necessarily speed up the web portal but it could slow down the database server a bit.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Scott Fell, EE MVEDeveloperCommented:
I would agree with Dave.  Is there some function he thinks he needs by the move?
0
 
skyjumperdudeAuthor Commented:
We need to provide our management team with a  proper document which proves our point.
0
 
Dave BaldwinFixer of ProblemsCommented:
That did not answer our question.  If the 'web portal' is already running, why does the developer think that it is worth the extra effort to move it?  Without any actual reason, it is just a waste of time to me.  What is the supposed benefit of moving it?
0
 
skyjumperdudeAuthor Commented:
Well I don't have a clear answer from him but he thinks that out web portal will be faster since it is on the same server as the database server and when pulling records there won't be any traffic going through the network. He told the management team that it is better because it will be faster, better security and authentication.
0
 
Dave BaldwinFixer of ProblemsCommented:
Then you need to find out how much other traffic is going to the database server, how much memory the SQL Server normally uses (it typically uses a lot which will limit what is available to the web server), and point out that if the web portal is on the database server, that any break-in potentially gives them access to the databases.

A Google search will bring up many articles about doing it both ways.  The most frequent point about separating them is about security.  This can be an actual requirement depending on what is in your databases.
0
 
Scott Fell, EE MVEDeveloperCommented:
I am not a big server geek, I just use them, and my own web/data traffic in some instances is about the same to more.  I would consider 1000 people a day small unless they are all running some heavy queries with millions of rows of data and streaming output or you are using ms sql server with 2 gigs of ram.  

Most small dedicated servers have the db and webserver on the same box although now there seems to be a trend of having several drives where one is for the webserver, one for back up and an ssd for the database.   You don't start seeing separate box's until things start to grow.   But you are already there.

If you have everything local now, going to all in one would be a step back I think.
0
 
Anthony PerkinsCommented:
Simply put your developer has not got a clue.  SQL Server should always be installed standalone.  And suggesting installing it with something as resource intensive as IIS is plain ignorance,

But let's play along with this farce.  These are the questions you should ask your developer: How much memory does the server have?  How much memory does SQL Server require?  How much memory does IIS require?  What memory settings (Max/Min) does he/she recommend for SQL Server?  And above all else is he prepared to take responsibility for his decisions?
0
 
Anthony PerkinsCommented:
skyjumperdude,

I would have thought you has been here long enough to know how the grading works in EE, obviously I was mistaken, so I would strongly suggest  you re-read the EE Guidelines and specifically the section What grade should I award?
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

  • 3
  • 3
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now