SQL_Server_2016_Editions_datasheet.pdf

(532 KB) Pobierz
SQL Server 2016 SP1 Editions
SQL Server 2016 is the biggest leap forward in the Microsoft data platform history with real-time operational analytics, rich visualizations on
mobile devices, built-in advanced analytics, new advanced security technology, and new hybrid cloud scenarios. Now with SQL Server 2016 SP1,
a common programming surface enables developers to build applications for SQL Server once and deploy them across editions.
Express
SMALL-SCALE APPLICATIONS
Development and
management tools
Easy backup and restore
to Microsoft Azure
Standard
FULLY FEATURED DATABASE FOR MID-TIER
APPLICATIONS AND DATA MARTS
Most secure database with
Always Encrypted
Enhanced in-memory
performance
for all workloads
Basic reporting
Basic analytics
Hybrid scenarios:
Stretch Database, backup
Enterprise
MISSION CRITICAL IN-MEMORY PERFORMANCE
AND SCALE, SECURITY AND HIGH AVAILABILITY
Mission critical high availability
Enhanced in-memory
performance for all
workloads
Unparalleled data security
PB scale data warehousing
End-to-end mobile BI
with rich visualizations
on all major platforms
In-database advanced analytics
built-in at scale
with R plus in-memory; 1M predictions/second
Enhanced hybrid scenarios including
Stretch Database,
HA, DR and backup
Develop once and scale across editions with the common programming surface in SQL Server 2016 SP1
© 2016 Microsoft Corporation. All rights reserved. This document is provided "as-is." Information and views expressed in this document, including URL and other Internet Web site references, may change without notice. You bear the risk of using it. This
document does not provide you with any legal rights to any intellectual property in any Microsoft product. You may copy and use this document for your internal, reference purposes. You may modify this document for your internal, reference purposes.
SQL Server 2016 SP1 features by edition
Maximum number of cores
Maximum memory utilized per instance
Maximum size
New
Standard
24 cores
128 GB
524 PB
New
Enterprise
Unlimited
OS Max
524 PB
OLTP Performance
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 (Always
Encrypted,
row-level security, data masking, basic auditing, separation of duties)
Transparent Data Encryption
New
Security
New
Fuzzy grouping and look ups
Data Warehousing
Data warehousing (In-Memory
ColumnStore*, partitioning, data compression, change data capture**,
database snapshot)
Basic data integration (SSIS, built-in connectors)
Basic Corporate Business Intelligence (Multi-dimensional models, Basic tabular model)
New
New
New
New
New
New
New
New
Business Intelligence
Mobile BI (Datazen)
Advanced Corporate Business Intelligence (Advanced tabular model, Direct query,
in-memory analytics, advanced data mining)
Basic “R” integration (Connectivity to R Open, Limited parallelism for RRE)
Advanced
“R” integration
(Full parallelism for RRE)
Advanced Analytics
Hybrid Cloud
Programmability
Stretch Database
Programmability (T-SQL, CLR, Service Broker, JSON, XML)
Features in
blue
are newly available in Standard and Express since SQL Server 2016 SP1
*Subject
to memory core and limitations for Standard and Express
**Change
data capture not available in Express

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin