SQL Server应该与IIS安装在同一台机器上吗？ [英] Should SQL Server be on the same machine as your IIS installation?

问题描述

我正在收听播客＃19，而Joel和Jeff正在争论在与IIS安装相同的机器上运行SQL Server。我不得不说，这听起来像杰夫折在了乔尔身上，但是我再次猜测哪一个是哪个。 ;）

I'm listening to podcast #19 and Joel and Jeff are arguing about running SQL Server on the same machine as your IIS installation. I have to say that it sounds like Jeff folded to Joel, but then again I am only guessing which one is which. ;)

每种的优点和缺点是什么？哪个更好？

What are the pros and cons of each? Which is better?

我通常会单独运行它们（Joel的偏好）但我可以看到Jeff的观点，即两者彼此更接近。

I typically run them separately (Joel's preference) but I can see Jeff's point where the two are closer to each other.

推荐答案

对于安全目的，最好将Web和数据库机器分开，最好在两者之间安装防火墙。 Web服务器向全世界公开。不幸的是，有些人乐于窃取或破坏这些服务器上包含的信息。

For security purposes it is good to separate web and database machines, preferably having a firewall between the two. A web server is exposed to the world at large. Unfortunately there are people who take pleasure in stealing or damaging the information contained on those servers.

然后是性能方面。众所周知，SQL Server喜欢内存。 IIS也是如此，特别是如果网站广泛使用缓存和会话信息。所以你也有潜在的冲突。拥有专用的SQL Server机器显然比让一台机器完成所有负载更好。

Then there is the performance aspect. It's common knowledge that SQL Server loves memory. So does IIS, particularly if the web-site makes extensive use of caching and session information. So you have a potential conflict here as well. Having a dedicated machine for SQL Server is clearly better than having a single machine doing all the load.

然后，分离允许更容易识别需要调整以及调整单个硬件组件的能力。

Then, separation allows easier identification of the need to tune and the ability to tune individual hardware components.

总而言之，这台机器功能强大，能够满足现场环境中IIS和SQL Server的需求对于每台服务器的特定要求，不一定比两台机器便宜。 （Jeff Atwood在其中一个播客中提到，升级一台机器的成本与获得第二台机器相同）。

To sum up, a machine powerful enough to cope with the demands of both IIS and SQL Server in a live environment won't necessarily be cheaper than two machines specced for the specific requirements of each server. (Jeff Atwood mentioned in one of the podcasts, that upgrading the one machine would have cost the same as getting a second machine).

这篇关于SQL Server应该与IIS安装在同一台机器上吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！