MS-SQL Server 2014 Features

MS SQL 2014 comes with a lot of features that are designed to give developers and administrators better performance, security, and manageability. The primary areas of improvement include in-memory OLTP, improvements to Always On, new Hybrid Cloud features, the new Buffer Pool, and better security through separation of duties between administrators and developers.

From our personal point of view, SQL Server 2014 is indeed an interesting release to mention. Thanks to all the testing we did with the various features of SQL Server 2016.

GeoPITS brings you the comprehensive list of SQL Server 2014 features that are supported in different editions (Enterprise Standard, Web, Express Adv, Express.)

FeaturesEnterpriseStandardWebExpress (Adv.)Express
Maximum compute capacity used by a single instance - SQL Server Database Engine Operating system maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores
Maximum compute capacity used by a single instance - Analysis Services or Reporting Services Operating system maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores
Maximum memory for buffer pool per instance of SQL Server Database Engine
Maximum capacity for buffer pool extension per instance of SQL Server Database Engine Operating System Maximum 128 GB 64 GB 1410 MB
Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine Unlimited memory 32 GB 16 GB 352 MB
Maximum memory-optimized data size per database in SQL Server Database Engine
Maximum memory utilized per instance of Analysis Services Operating System Maximum 64 GB
Maximum memory utilized per instance of Reporting Services Operating System Maximum 64 GB 64 GB
Maximum relational database size 524 PB 524 PB 524 PB 10 GB

FeaturesEnterpriseStandardWebExpress (Adv.)Express
Heterogeneous subscribers Yes
Merge replication Yes Yes Yes (Subscriber only) Yes (Subscriber only)
Oracle publishing Yes
Peer to peer transactional replication Yes
Snapshot replication Yes Yes Yes (Subscriber only) Yes (Subscriber only)
SQL Server change tracking Yes Yes Yes Yes
Transactional replication Yes Yes Yes (Subscriber only) Yes (Subscriber only)
Transactional replication to Azure
Transactional replication updateable subscription Yes

FeaturesEnterpriseStandardWebExpress (Adv.)Express
SQL Server Migration Assistant
Database mail

FeaturesEnterpriseStandardWebExpress (Adv.)Express
StreamInsight
StreamInsight HA

We run all kinds of Database services that vow your success