Solved

Web portal and database on same server

Posted on 2014-02-18
11
323 Views
Last Modified: 2014-03-10
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
Comment
Question by:skyjumperdude
  • 3
  • 3
  • 3
  • +1
11 Comments
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39868182
Would the web portal serve 100, 1,000 or 10,000 people at any given day?
0
 
LVL 1

Author Comment

by:skyjumperdude
ID: 39868192
May be 1000
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 250 total points
ID: 39868219
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
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39868267
I would agree with Dave.  Is there some function he thinks he needs by the move?
0
 
LVL 1

Author Comment

by:skyjumperdude
ID: 39868379
We need to provide our management team with a  proper document which proves our point.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39868587
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
 
LVL 1

Author Comment

by:skyjumperdude
ID: 39868619
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
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39868658
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
 
LVL 52

Expert Comment

by:Scott Fell, EE MVE
ID: 39868928
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
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 39869212
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39919404
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now