Updated: July 15, 2020 (June 2, 2016)

SQL Server Database Feature Comparison

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server’s database engine allows users or systems to query or store data in columns and rows. The key features for SQL Server 2016 being used as a database server are shown here by edition.

Feature	Description	Express	Standard	Enterprise
Database Size	Maximum size of any relational database.	10GB	524PB	524PB
Max Processors or Processor Cores	Maximum processing power available to an instance of SQL Server 2016 when used as a database.	Lesser of four cores or one processor	Lesser of 24 cores or four processors	Maximum supported by OS
Max Memory	Maximum RAM available to an instance of SQL Server when used as a database.	1GB	128GB	Maximum supported by OS
LocalDB and User Instances	On-demand and user-session-based instances of SQL Server for use by applications.	Yes	No	No
PolyBase	Multi-node unstructured data management features that connect to Hadoop

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now