Microsoft SQL Server 2019 Enterprise | 2 Core License + Software Assurance
FEATURES:
- SQL Server 2019 now comes with Apache Spark and Hadoop Distributed File System (HDFS) for intelligence over all your data.
- With SQL Server 2019 Enterprise and Standard edition, customers can deploy Big Data Clusters. SQL Server 2019 Big Data Clusters makes it easier to manage a big data environment. It provides key elements of a data lake—Hadoop Distributed File System (HDFS), Spark, and analytics tools—deeply integrated with SQL Server and fully supported by Microsoft.
- SQL Server 2019 Big Data Clusters can be easily deployed using Linux containers on a Kubernetes-managed cluster.
Looking for authentic Microsoft installation media? We will be happy to mail a holographic DVD upon purchase of this license - please specify in the notes upon checkout.
SQL Server 2019 Standard vs Enterprise Comparison
Feature | SQL Server 2019 Standard | SQL Server 2019 Enterprise - This Edition |
---|---|---|
Maximum Compute Capacity (per instance) | Lesser of 4 Sockets or 24 Cores | OS Maximum |
Maximum Memory Utilization (per instance) | 128 GB | OS Maximum |
High Availability | Basic Availability Groups | AlwaysOn Availability Groups, multi-database failover, multiple synchronous replicas |
Online Operations | Basic online operations | Advanced online operations including online index rebuilds |
Performance | Standard performance features | Advanced performance features (In-Memory OLTP, Adaptive Query Processing, Intelligent Query Processing) |
Security | Basic security features | Advanced security features (Always Encrypted, Row-level security, Dynamic data masking, Advanced Threat Protection) |
Data Warehousing | Basic DW capabilities | Advanced DW capabilities (Columnstore indexes, Data Compression, Partitioning) |
Business Intelligence | Basic BI capabilities | Advanced BI capabilities (Power BI Report Server, Advanced analytics) |
Data Mining | Basic data mining | Advanced data mining |
Database Snapshot | Not supported | Supported |
Enterprise Manageability | Standard management tools | Advanced manageability (Policy-Based Management, Data-tier Applications, Multi-Server Management) |
Partitioning | Not supported | Supported |
Data Compression | Not supported | Supported |
Table and Index Partitioning | Not supported | Supported |
Backup Compression | Supported | Supported |
Audit | Basic auditing | Advanced auditing (Server Audit Specification) |
Resource Governor | Not supported | Supported |
Replication | Standard Replication | Advanced Replication (Peer-to-Peer, Merge) |
SQL Server Integration Services (SSIS) | Standard SSIS features | Advanced SSIS features (SSIS Scale Out, Advanced Transformations) |
Master Data Services | Not supported | Supported |
Data Quality Services | Not supported | Supported |
Power BI Report Server | Not supported | Supported |
PowerPivot for SharePoint | Not supported | Supported |
Power View | Not supported | Supported |
How to license SQL Server?
Licensing Models
- Core-based Licensing: Applies to the Enterprise Edition and offers unlimited Virtualization Rights when all physical cores are licensed.
- Server + CAL (Client Access License): Applies to the Standard Edition and requires a license for each server and a CAL for each user or device accessing the server.
Core-Based Licensing (Standard and Enterprise Editions)
+--------------------+ | SERVER | |--------------------| | Core 1 | Core 2 | | Core 3 | Core 4 | +--------------------+ | Minimum 4 Core Licenses per Processor |
- Core Licenses: Sold in packs of two. Each physical core must have a license.
- Minimum Requirement: A minimum of four core licenses per physical processor.
- Virtualization: With Software Assurance, allows for unlimited virtualization. This license is a retail pack with 2 cores without SA, so the virtualization will depend upon the number of vCPU's licensed.
- Looking for the SLU with Software Assurance? It can be purchased here
Server + CAL Licensing (Standard Edition)
- Server License: One license per server. - This edition
- CALs: One CAL per user or device accessing the server.
Virtualization and Containers
+----------------------------+ | HOST | +----------------------------+ | VM 1 | VM 2 | VM 3 | VM 4 | +----------------------------+ | Each VM must be licensed | +----------------------------+
- Enterprise Edition: Offers flexibility with virtualization, allowing for multiple VMs and containers.
- Standard Edition: Limited to a lower number of VMs and containers unless each VM is licensed individually.
Licensing for Specific Environments
- Non-production (Dev/Test): Developer Edition is free and provides the full feature set for development and testing purposes.
- High Availability: Passive secondary servers for failover are included in the licensing of the primary server.
Delivery, Returns & Tech Support:
- All orders placed before 2PM PST M-F (excluding holidays) will be fulfilled the same day.
- 7-day return policy on most licenses if unused/non-activated.
- Questions about licensing or what to purchase? Call/text/email or chat with us!
- Need a bulk order fast? Please call or email us or fill out our bulk form
Thank you for choosing ESS - Your #1 Software Dudes!!
What do I get with my purchase?
You receive a product key, download link and install instructions.
How do I get the download?
Most products are delivered digitally via email within 30 minutes of purchase.
What if I need help?
We provide installation support free with all purchases. Just reach out if you need help, we're here!
Other questions?
Give us a call or chat instantly.
Read over 1,000+ reviews that rated ESS 4.9/5 stars
Our customer feedback reflects unparalleled customer satisfaction. With a focus on delivering tailored IT and software solutions, ESS stands as a beacon of reliability and excellence in the industry. Experience their commitment to quality and efficiency firsthand for your business needs.
Our products