SQL Server Web 与标准版
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/48967318/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Server Web vs Standard edition
提问by User987
I have found out that there's two versions of SQL Server types that are very different in terms of pricing...
我发现有两种版本的 SQL Server 类型在定价方面非常不同......
The Web version from my host provider costs about 13$ per 2 core packs, whereas the Standard edition is right around 200$.
我的主机提供商提供的 Web 版本每 2 个核心包的成本约为 13 美元，而标准版的成本约为 200 美元。
From my standpoint, we expect our database to be around 150-200GB in size, only few tables would take up most of that space.
从我的角度来看，我们希望我们的数据库大小在 150-200GB 左右，只有少数表会占用大部分空间。
So my only concern is would the web version of SQL Server support this large database and not cause any performance issues to the end users?
所以我唯一关心的是 SQL Server 的 Web 版本是否支持这个大型数据库，而不会对最终用户造成任何性能问题？
How different is index rebuilding on Web and Standard version?
Web 版和标准版的索引重建有何不同？
Can someone help me out with this?
有人可以帮我解决这个问题吗？
采纳答案by Tom V
The differences between web and standard version of SQL Server 2016 are listed here : https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016
此处列出了 SQL Server 2016 的 Web 版本和标准版本之间的差异：https: //docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016
Main differences between web and standard are the max memory and max number of cores. Both web and standard version don't have the possibility of online indexing, this is only possible in the enterprise edition.
Web 和标准之间的主要区别是最大内存和最大内核数。网页版和标准版都没有在线索引的可能性，这只能在企业版中实现。
For a database size having a size of around 200GB, the web edition looks to be ok. But this depends also on the workload of the database, are just some users querying this database or is this database used by thousand of users.
对于大小约为 200GB 的数据库大小，网络版看起来还可以。但这也取决于数据库的工作量，只是一些用户在查询这个数据库，还是这个数据库被数千名用户使用。
回答by Liakat
Have a look at comparison list here- https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645993(v=sql.105)You will get all SQL versions comparison side by side details here. Look for Webin comparison table
在这里查看比较列表- https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645993(v=sql.105)您将获得所有 SQL 版本并排比较细节在这里。Web在比较表中寻找
