September 22, 2010 at 11:46 am
Can someone tell me why I should not have an application system, and web system, and a sql server database on the same machine in production
September 22, 2010 at 11:51 am
You "can", but you take a hit on performance and security.
Performance because you will be sharing resources between all three systems on one box.
Security because you open your server up to additional ports and traffic.
Sincerely,
Dan B
September 22, 2010 at 11:58 am
Do you know of any "Official" best practices inforrmation as to why you shouldn't or can't for customer sensitive information, I need some sort of official guidelines.
Thx
September 22, 2010 at 12:35 pm
Official doesn't necessarily mean anything. Do you want something from Microsoft? From a government agency?
Here is an old doc from the NSA:
http://www.nsa.gov/ia/_files/db/mssql_2k.pdf
I think most of the general guidelines are still appropriate even if they don't directly translate to 2008...
Quote:
"Install SQL Server 2000 on a server that is not required to support any other services. If the database is to be accessed by a Web Server, do not install these two services on the same machine. Neither application software nor development tools should be installed on the production database server."
Sincerely,
Dan B
September 22, 2010 at 12:43 pm
One more thing in the mix.
I just started playing with VM and I find it extremely usefull how I can simply add or remove power at will on each server and for each environement (dev, test, QA, PREPROD, Prod external and prod Internal).
My dev is too slow? No prob, here's 4 proc and 12 GB of ram instead of 2 and 3.
Need to test prod perf? Sure here's 8 proc and 60 gb of ram on your dev machine.
Now strickly speaking everything is on the same physical machine but with logical separation which helps with security and "best practices".
Now the real question is what are your needs (users, db size, networks, vpn)... and most importantly, what's the budget? Because all in 1 server is cheaper for licenses and hardware than having 3-4 different servers.
I can help guide your further if you can provide more details about what you need to do and support.
September 22, 2010 at 2:08 pm
I think I have found what I needed! thanks for the input
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply