SQL Server 2017 is considered a major release in the history of the SQL Server life cycle for various reasons. From our personal point of view, SQL Server 2017 is indeed an interesting release to mention. Thanks to all the testing we did with the various features of SQL Server 2017. Without further delay, GeoPITS brings you the comprehensive list of SQL Server 2017 features that are supported in different editions (Enterprise Standard, Web, Express Adv, Express.)
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Maximum compute capacity used by a single instance - SQL Server Database Engine | Operating system maximum | Limited to lesser of 4 sockets or 24 cores | Limited to lesser of 4 sockets or 16 cores | Limited to lesser of 1 socket or 4 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 24 cores | Limited to lesser of 4 sockets or 16 cores | Limited to lesser of 1 socket or 4 cores | Limited to lesser of 1 socket or 4 cores |
| Maximum memory for buffer pool per instance of SQL Server Database Engine | Operating System Maximum | 128 GB | 64 GB | 1410 MB | 1410 MB |
| Maximum capacity for buffer pool extension per instance of SQL Server Database Engine | 32 * (max server memory configuration) | 4 * (max server memory configuration) | |||
| Maximum memory for Columnstore segment cache per instance of SQL Server Database Engine | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Maximum memory-optimized data size per database in SQL Server Database Engine | Unlimited memory | 32 GB | 16 GB | 352 MB | 352 MB |
| Maximum memory utilized per instance of Analysis Services | Operating System Maximum | Tabular: 16 GB MOLAP: 64 GB | |||
| Maximum memory utilized per instance of Reporting Services | Operating System Maximum | 64 GB | 64 GB | 4 GB | |
| Maximum relational database size | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Server core support | Yes | Yes | Yes | Yes | Yes |
| Log shipping | Yes | Yes | Yes | ||
| Database mirroring | Yes | Yes Full safety only | Witness only | Witness only | Witness only |
| Backup compression | Yes | Yes | |||
| Database snapshot | Yes | Yes | Yes | Yes | Yes |
| Always On failover cluster instances | Yes | Yes | |||
| Always On availability groups | Yes | ||||
| Basic availability groups | Yes | ||||
| Automatic read write connection re-routing | |||||
| Online page and file restore | Yes | ||||
| Online indexing | Yes | ||||
| Resumable online index rebuilds | Yes | ||||
| Online schema change | Yes | ||||
| Fast recovery | Yes | ||||
| Accelerated database recovery | |||||
| Mirrored backups | Yes | ||||
| Hot add memory and CPU | Yes | ||||
| Database recovery advisor | Yes | Yes | Yes | Yes | Yes |
| Encrypted backup | Yes | Yes | |||
| Hybrid backup to Azure (backup to URL) | Yes | Yes | |||
| Read-scale availability group | Yes | ||||
| Cluster-less availability group | |||||
| Failover servers for disaster recovery | |||||
| Failover servers for high availability | |||||
| Failover servers for disaster recovery in Azure |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Row-level security | Yes | Yes | Yes | Yes | Yes |
| Always Encrypted | Yes | Yes | Yes | Yes | Yes |
| Always Encrypted with Secure Enclaves | |||||
| Dynamic data masking | Yes | Yes | Yes | Yes | Yes |
| Server audit | Yes | Yes | Yes | Yes | Yes |
| Database audit | Yes | Yes | Yes | Yes | Yes |
| Transparent database encryption | Yes | ||||
| Extensible key management | Yes | ||||
| User-defined roles | Yes | Yes | Yes | Yes | Yes |
| Contained databases | Yes | Yes | Yes | Yes | Yes |
| Encryption for backups | Yes | Yes | |||
| Data classification and auditing |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Heterogeneous subscribers | Yes | Yes | |||
| Merge replication | Yes | Yes | Yes (Subscriber only) | 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) | Yes (Subscriber only) |
| SQL Server change tracking | Yes | Yes | Yes | Yes | Yes |
| Transactional replication | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Transactional replication to Azure | Yes | Yes | |||
| Transactional replication updateable subscription | Yes | Yes |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| SQL Management Objects (SMO) | Yes | Yes | Yes | Yes | Yes |
| SQL Assessment API | |||||
| SQL Vulnerability Assessment | |||||
| SQL Configuration Manager | Yes | Yes | Yes | Yes | Yes |
| SQL CMD (Command Prompt tool) | Yes | Yes | Yes | Yes | Yes |
| Distributed Replay - Admin Tool | Yes | Yes | Yes | Yes | |
| Distribute Replay - Client | Yes | Yes | Yes | ||
| Distributed Replay - Controller | Yes (Up to 16 clients) | Yes (1 client) | Yes (1 client) | ||
| SQL Profiler | Yes | Yes | No | No | No |
| SQL Server Agent | Yes | Yes | Yes | ||
| Microsoft System Center Operations Manager Management Pack | Yes | Yes | Yes | ||
| Database Tuning Advisor (DTA) | Yes | Yes 2 | Yes 2 |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Microsoft Visual Studio integration | Yes | Yes | Yes | Yes | Yes |
| Intellisense (Transact-SQL and MDX) | Yes | Yes | Yes | Yes | Yes |
| SQL Server Data Tools (SSDT) | Yes | Yes | Yes | Yes | |
| MDX edit, debug, and design tools | Yes | Yes |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Create cubes without a database | Yes | Yes | |||
| Autogenerate staging and data warehouse schema | Yes | Yes | |||
| Change data capture | Yes | Yes | |||
| Star join query optimizations | Yes | ||||
| Scalable read-only Analysis Services configuration | Yes | ||||
| Parallel query processing on partitioned tables and indexes | Yes | ||||
| Global batch aggregation | Yes |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Spatial indexes | Yes | Yes | Yes | Yes | Yes |
| Planar and geodetic datatypes | Yes | Yes | Yes | Yes | Yes |
| Advanced spatial libraries | Yes | Yes | Yes | Yes | Yes |
| Import/export of industry-standard spatial data formats | Yes | Yes | Yes | Yes | Yes |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| SQL Server Migration Assistant | Yes | Yes | Yes | Yes | Yes |
| Database mail | Yes | Yes | Yes |
| Features | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| StreamInsight | StreamInsight Premium Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | ||
| StreamInsight HA | StreamInsight Premium Edition |
