同一台机器上的 SQL Server Express，还是外部共享的 SQL Server Standard？ （对于 ASP.NET 站点）
我要从一家著名的以 MS 为中心的网络托管公司注册专用虚拟机。虚拟机有 1CPU 和 1GB RAM。我将在其上运行一个 ASP.NET 网站 - 该网站非常简单（后端数据库上有一些表），但必须尽可能快。
对于数据库我有两个选择： 1）在我自己的虚拟机上安装SQL Server Express。这个版本的空间/内存限制不是问题，因为数据库不存储文件和二进制数据，因此仍然很小。 2) 使用托管公司的共享 SQL Server Standard 实例，理论上该实例安装在功能强大的计算机上。
哪个是最好的最佳选择？我会选择 (1)，但我担心在同一台计算机上运行 Web 服务器 (iis/asp.net) 和 SQL Server 会降低性能。想法？
I'm going to sign-up for a dedicated virtual machine from a renowned MS-centric web hosting company. The virtual machine has 1CPU and 1GB of RAM. I'll be running an ASP.NET website on it - the website is pretty simple (a few tables on the back-end DB) but must be as fast as possible.
For the DB I have two options:
1) Install SQL Server Express on my own virtual machine. The space/ram limitations of this editions are not a problem, because the DB does not stores files and binary data, and thus will remain pretty small.
2) Use the hosting company's shared SQL Server Standard instance, which is in theory installed on a powerful machine.
Which is the best best option? I'd go with (1), but I'm afraid running the web server (iis/asp.net) and SQL Server on the same machine will slow down performances. Thoughts?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果您想优化性能并且没有太多数据，那么您应该使用共享数据库并将数据缓存在客户端。这有点复杂，并且存在数据丢失的小危险（例如，在电源故障的情况下），但它绝对是最快的解决方案。
If you want to optimize for performance and you haven't very much data, then you should use the shared database and cache your data on the client-side. This is somewhat more complicated and there is a small danger of data-loss (e.g. in case of a power failure), but it's definitely the fastest possible solution.
它会这样做，但如果 VM 以低于 100% 的容量运行，则不会产生任何净影响。对于此类选择，IT 行业有一个非常简单的准则：保持简单。哪个对您来说更容易管理（包括更新和备份）？
It will do this, but if the VM is running at less than 100% capacity it will have no net effect. In IT with choices like this there is a very simple guideline: Keep It Simple. Which is going to be simpler for you to manage (including updates and backups)?