未加星标

Main Limitations of SQL Server Express Editions

字体大小 | |
[数据库(mssql) 所属分类 数据库(mssql) | 发布者 店小二05 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏

SQL Server Express Editions are a handy solution for small businesses with small databases with no special requirements about performance, high availability, encryption, etc.

However, the Express Editions of SQL Server, even free , as expected, have certain limitations. In the below table I have gathered some of these limitations which I can consider are the limitations someone might want to check as a first look. In the end of each column, there is a URL with more information about all the limitations of the express edition for each SQL Server version.

Main Limitations of SQL Server Express Editions (note: this is not the full limitations list) Feature/SQL Server Version SQL Server 2005 Express SQL Server 2008 R2 Express SQL Server 2012 Express SQL Server 2014 Express SQL Server 2016 Express Maximum number of CPU/Cores 1 socket or 4 cores 1 socket or 4 cores 1 socket or 4 cores 1 socket or 4 cores 1 socket or 4 cores Maximum memory per instance 1 GB 1 GB 1 GB 1 GB 1 GB Maximum database size 4 GB 10 GB 10 GB 10 GB 10 GB In-memory OLTP N/A N/A N/A No No AlwaysOn Failover Cluster Instances No No No No No Always On Availability Groups N/A N/A No No No Transparent database encryption N/A No No No No In-Memory Columnstore N/A N/A No No No URL for more info/full limitations list Click Here Click Here Click Here Click Here Click Here For more articles please check: The SQL Server and .NET Blog Article by Artemakis Artemiou , Microsoft Data Platform MVP *Note: The above table does not contain all limitations of SQL Server express editions. For the full lists of limitations, click on the URL provided in the end of each column for every SQL Server version.

本文数据库(mssql)相关术语:熊片数据库 mssql数据库 oracle数据库 pubmed数据库 access数据库 万方数据库

主题: SQLSQL ServerCPU
分页:12
转载请注明
本文标题:Main Limitations of SQL Server Express Editions
本站链接:http://www.codesec.net/view/480066.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mssql) | 评论(0) | 阅读(43)