SQL Server Licensing Explained
Microsoft SQL Servers manages to handle critical workloads for different types of workforces. It is made for different sizes and seems complicated and expensive for setting up software infrastructure for your organization. It can be confusing to think about how it works, let alone how to license them. Some SQL Servers exist for the Cloud with thousands of concurrent users and others in small to medium-sized businesses. But don't worry, as we have compiled all the SQL server version licenses for you to make a better decision before you purchase. But, if you need more information on which license to go for, feel free to contact our support executive because we know what is best for your business.
Microsoft SQL Server 2019
Software Assurance Benefit |
Standard |
Enterprise |
Next version rights |
|
|
License Mobility to shared third party servers |
|
|
Fail-Over servers for high availability |
|
|
Unlimited virtualization |
|
|
Machine Learning Server for Hadoop |
|
|
Power BI Report Server |
|
|
|
Shop Now |
Shop Now |
Microsoft SQL Server 2017
Software Assurance Benefit |
Standard |
Enterprise |
Next version rights |
|
|
License Mobility to shared third party servers |
|
|
Fail-Over servers for high availability |
|
|
Unlimited virtualization |
|
|
Machine Learning Server for Hadoop |
|
|
Power BI Report Server |
|
|
|
Shop Now |
Shop Now |
Microsoft SQL Server 2016
Feature |
Standard |
Enterprise |
Maximum Number of Cores |
24 Cores |
Unlimited |
MMemory: Maximum Buffer Pool Size per Instance |
128 GB |
Operating System Max |
Memory: Maximum Columnstore Segment Cache per Instance |
32 GB |
Operating System Max |
Memory: Maximum Memory-Optimized Data per Database |
32 GB |
Operating System Max |
Maximum Database Size |
524 PB |
524 PB |
Advanced High Availability |
|
|
Unlimited Virtualization, a Software Assurance Benefit |
|
|
Transparent Data Encryption |
|
|
Advanced Data Integration: Fuzzy Grouping and Look Ups |
|
|
Adaptive Query Processing |
|
|
Enterprise data management: Master Data Services, Data Quality Services |
|
|
Mobile Reports and KPIs |
|
|
Stretch Database |
|
|
|
Shop Now |
Shop Now |
Microsoft SQL Server 2014
Features |
Standard |
Business Intelligence |
Enterprise |
Licensing Options |
Core-Based or Server+CAL |
Server+CAL |
Core-Based |
AlwaysOn High Availability |
Basic |
Basic |
Advanced |
Windows Server Core Edition Support |
|
|
|
Basic OLTP |
|
|
|
Basic Reporting & Analytics |
|
|
|
Programmability & Developer Tools(T-SQL, CLR, Data Types, FileTable) |
|
|
|
Manageability(Management Studio, Policy-Based Management) |
|
|
|
Enterprise Data Management(Data Quality Services, Master Data Services) |
|
|
|
Self-service Business Intelligence(Power View, PowerPivot) |
|
|
|
Corporate Business Intelligence(Semantic Model, Advanced Analytics) |
|
|
|
Advanced Security(Advanced Auditing, Transparent Data Encryption) |
|
|
|
In-memory ColumnStore |
|
|
|
In-memory OLTP |
|
|
|
|
Shop Now |
Shop Now |
Shop Now |
Microsoft SQL Server 2012
SQL Server 2012 Capabilities |
Standard |
Business Intelligence |
Enterprise |
Licensing Options |
Core-Based or Server+CAL |
Server+CAL |
Core-Based |
Windows Server Core Edition Support |
|
|
|
Basic High Availability |
|
|
|
Basic OLTP |
|
|
|
Basic Reporting & Analytics |
|
|
|
Programmability & Developer Tools(T-SQL, CLR, Data Types, FileTable) |
|
|
|
Manageability(Management Studio, Policy-Based Management) |
|
|
|
Enterprise Data Management(Data Quality Services, Master Data Services) |
|
|
|
Self-service Business Intelligence(Power View, PowerPivot) |
|
|
|
Corporate Business Intelligence(Semantic Model, Advanced Analytics) |
|
|
|
Advanced Security(Advanced Auditing, Transparent Data Encryption) |
|
|
|
Data Warehousing (ColumnStore Index, compression, partitioning) |
|
|
|
AlwaysOn High Availability |
|
|
|
StreamInsight |
Basic |
Basic |
Advanced |
|
Shop Now |
Shop Now |
Shop Now |
Microsoft SQL Server 2008 R2
Edition |
Limits |
SQL Server 2008 |
SQL Server 2008 R2 |
Datacenter |
Processors/OSEs/Memory |
N/A |
Up to 256 logical processors / Unlimited / OS maximum |
Enterprise |
Processors / OSEs / Memory |
Unlimited / OS maximum |
Up to 8 processors / Up to 4 per Server License /2TB |
Standard |
Memory |
OS maximum |
64GB |
|
Shop Now |
Shop Now |
Shop Now |
Microsoft SQL Server 2008
Edition |
Limits |
SQL Server 2008 |
SQL Server 2008 R2 |
Datacenter |
Processors/OSEs/Memory |
N/A |
Up to 256 logical processors / Unlimited / OS maximum |
Enterprise |
Processors / OSEs / Memory |
Unlimited / OS maximum |
Up to 8 processors / Up to 4 per Server License /2TB |
Standard |
Memory |
OS maximum |
64GB |