Microsoft SQL Server 2016 Licensing Explanation
Versions
| |
StandardSQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources. |
EnterpriseSQL Server Enterprise delivers comprehensive datacenter capabilities for mission-critical database, business intelligence, and advanced analytics workloads. |
License type:
|
|
StandardThe most affordable way to get sql, this option is great for small (1 – 30) users or devices.Requirements:
Open License
Open License with Software Assurance
Software Assurance only |
Standard 2 CoreMicrosoft SQL 2 Core license comes with unlimited users and can be enhanced by speeding up storage and memory. Cost effective when you have more than 31 users on a system.Requirements:
Open License
Open License with Software Assurance
Software Assurance only |
Enterprise 2 CoreMicrosoft SQL Enterprise 2 Core license comes with unlimited users and can be enhanced by speeding up storage and memory.Requirements:
Open License
Open License with Software Assurance
Software Assurance only |
Device Client Access License
(1 Device CAL)
Your price: $249.99 Purchase
User Client Access License
(1 User CAL)
Your price: $249.99 Purchase
- Always Encrypted – a new capability developed by Microsoft Research that is designed to protect data “at rest and in motion”
- Stretch Database – new technology that lets allows users to dynamically stretch warm and cold transactional data to Microsoft Azure
- Enhancements to Microsoft’s “Hekaton” in-memory technologies for real-time analytics
- New in-database analytics with R integration
- Polybase — an engine that, to date, has been part of the SQL Server
- Parallel Data Warehouse Appliance, for more easily managing relational and non-relational data
- Row-level security, allowing users to control access to data based on characteristics of the user, without modifications to applications
- Dynamic Data Masking — supports real-time obfuscation of data to prevent access to unauthorized dataTemporal database support for tracking historical data changes
- Query Data Store — a “flight data recorder” for database administrators
- Enhanced server management for Master Data Services
- Enhanced hybrid backup to Azure and faster restores to SQL Server in Azure virtual machines
| Standard | Enterprise | |
Mission critical performance |
||
|
Mission critical performance |
|
|
Security |
||
|
Security |
|
|
Data warehousing |
||
|
Data ware-housing |
|
|
Business intelligence |
||
|
Business intelligence |
|
|
Advanced analytics |
||
|
Advanced analytics |
|
|
Hybrid cloud |
||
|
Hybrid |
|
|
Compare Versions
| Features | Standard | Enterprise | |
|---|---|---|---|
| Mission critical performance | Maximum number of cores |
24 cores | Unlimited |
Maximum memory utilized per instance |
128 GB | OS Max | |
Maximum size |
524 PB | 524 PB | |
Basic OLTP |
![]() |
![]() |
|
Manageability (Management Studio, Policy-Based Management) |
![]() |
![]() |
|
Basic high availability (2-node single database failover, non-readable secondary) |
![]() |
![]() |
|
Enterprise data management (Master Data Services, Data Quality Services) |
![]() |
||
Advanced OLTP (In-memory OLTP, Operational analytics) |
![]() |
||
Advanced HA (Always On - multi-node, multi-db failover, readable secondaries) |
![]() |
||
| Security | Basic security (Row-level security, data masking, basic auditing, separation of duties) |
![]() |
![]() |
Advanced security (Transparent Data Encryption, Always Encrypted) |
![]() |
||
| Data warehousing | Advanced data integration (Fuzzy grouping and look ups, change data capture) |
![]() |
|
Data warehousing (In-Memory ColumnStore, Partitioning) |
![]() |
||
| Business intelligence | Programmability & developer tools (T-SQL, CLR, Data Types, FileTable, JSON) |
![]() |
![]() |
Basic reporting & analytics |
![]() |
![]() |
|
Basic data integration (SSIS, built-in connectors) |
![]() |
![]() |
|
Basic Corporate Business Intelligence (Multi-dimensional models, Basic tabular model) |
![]() |
![]() |
|
Mobile BI (Datazen) |
![]() |
||
Advanced Corporate Business Intelligence (Advanced tabular model, Direct query,
in-memory analytics, advanced data mining)
|
![]() |
||
| Advanced analytics | Basic “R” integration (Connectivity to R Open, Limited parallelism for RRE)
|
![]() |
![]() |
Advanced “R” integration (Full parallelism for RRE)
|
![]() |
||
| Hybrid cloud | Stretch Database |
![]() |
![]() |
Compare Years
| Features | 2016 | 2014 | 2012 | 2008 R2 | |
|---|---|---|---|---|---|
| Performance | In-memory OLTP* |
|
|
||
| In-memory ColumnStore* |
|
|
|
||
| Real-time operational analytics* |
|
||||
| Resource Governor* |
|
|
|
|
|
| Query Store |
|
||||
| Availability | AlwaysOn* |
|
|
|
|
| Enhanced virtualization support and live migration |
|
|
|
|
|
| Security | Always Encrypted* |
|
|||
| Transparent data encryption* |
|
|
|
|
|
| Row-level security |
|
||||
| Dynamic data masking |
|
||||
| Backup encryption support |
|
|
|||
| Fine-grained auditing |
|
|
|
|
|
| Separation of duties |
|
|
|
||
| Programmability | JSON support |
|
|||
| PolyBase queries over Hadoop data** |
|
||||
| Temporal |
|
||||
| Cloud-ready | SQL Server Stretch Database |
|
|||
| Backup to Azure |
|
|
|
||
| Disaster recovery to Azure* |
|
|
|||
| Optimized virtual machine images in Azure gallery |
|
|
|
||
| Management | Distributed replay |
|
|
|
|
| Policy-based management |
|
|
|
|
|
| Business intelligence | Modernized reports |
|
|||
| Mobile BI* |
|
||||
| Integration services managed as a server |
|
|
|
||
| Pin reports to Power BI |
|
||||
| Multi-dimensional semantic models |
|
|
|
|
|
| Enhanced tabular BI semantic models* |
|
||||
| Master data services* |
|
|
|
|
|
| Data quality services* |
|
|
|
||
| Advanced analytics | In-database advanced analytics with R Services |
|
|||
| Multi-threaded processing of R queries and streaming memory* |
|
Benefits of Software Assurance
Per Core Explanation
| SQL Server Core Factor Table* | |
|---|---|
| Processor Type | Core Factor |
| All processors not mentioned below | 1 |
| AMD Processors 31XX, 32XX, 33XX, 41XX, 42XX, 43XX, 61XX, 62XX, 63XX Series Processors with 6 or more cores | 0.75 |
| Single-Core Processors | 4 |
| Dual-Core Processors | 2 |
SQL Server 2016 Mission Critical technical white paper (PDF)
SQL Server 2016 In-memory OLTP technical white paper (PDF)
SQL Server 2016 In-memory OLTP and Columnstore Feature Comparison (PDF)
SQL Server 2016 Deeper Insights Across Data technical white paper (PDF)
SQL Server 2016 Hyper-scale Cloud technical white paper (PDF)

