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

问题描述

我正在听 Podcast #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屋！