SQL Server 2019 Standard 16 Core is a professional per-core relational database server licence providing the SQL Server 2019 Standard database engine, reporting services, high availability and business intelligence tools for servers with up to 16 licensed cores on Windows and Linux.
SQL Server 2019 Standard 16 Core – UK Digital Database Server Licence
SQL Server 2019 Standard 16 Core is a comprehensive per-core database server licence designed for organisations that need to licence SQL Server 2019 Standard on a server with up to 16 physical processor cores under the per-core licensing model. It is ideal for small to medium-sized businesses, IT departments, database administrators and application developers who need a reliable and scalable relational database platform for line-of-business applications, web applications, data warehousing and business intelligence workloads on mid-range multi-core servers where per-core licensing is more appropriate than Server and Client Access Licence based licensing.
Per-core licensing is particularly well suited to environments where the number of users or devices accessing the SQL Server instance is large, variable or difficult to count, or where internet-facing applications serve an unrestricted or anonymous user base. A 16 core licence covers a server with up to 16 physical processor cores, with all physical cores on the server required to be licensed and a minimum of four core licences applying per physical processor. SQL Server 2019 Standard 16 Core delivers significant improvements over SQL Server 2017 Standard including Accelerated Database Recovery, enhanced Intelligent Query Processing, Always Encrypted with secure enclaves and improved Linux and Kubernetes container support within the Standard edition limits.
For a complete data management setup, you can also explore our Microsoft software range, or consider Microsoft Office Access for desktop database front-end solutions alongside SQL Server for enterprise data management.
Important Notice About SQL Server 2019 Standard 16 Core
SQL Server 2019 Standard 16 Core is a per-core server licence covering up to 16 physical processor cores. All physical cores on the licensed server must be covered, with a minimum of four core licences required per physical processor. No Client Access Licences are required for users or devices accessing a per-core licensed SQL Server instance. SQL Server 2019 Standard is subject to feature limitations compared to SQL Server 2019 Enterprise, including a maximum of 128 GB of buffer pool memory and basic Always On Availability Groups limited to two nodes. If your server has more than 16 physical cores or requires Enterprise edition features, please consider the appropriate alternative licence.
Internet connectivity may be required during the initial activation process. SQL Server 2019 runs on Windows Server 2016 and later as well as supported Linux distributions including Red Hat Enterprise Linux, SUSE Linux Enterprise Server and Ubuntu.
Why Choose SQL Server 2019 Standard 16 Core?
- Per-core licensing covering up to 16 physical processor cores on a single server
- No Client Access Licences required for users or devices accessing the server
- Accelerated Database Recovery for faster database recovery and improved availability
- Enhanced Intelligent Query Processing for improved query performance without manual tuning
- Always Encrypted with secure enclaves for richer queries on encrypted data
- Improved Linux and Kubernetes container support for flexible deployment options
- Python and R integration for in-database machine learning and advanced analytics
- SQL Server Reporting Services for professional report creation and delivery
- Perpetual licence with lifetime access to SQL Server 2019 Standard
- Digital delivery by email after order confirmation
Key Features of SQL Server 2019 Standard 16 Core
- Per-Core Licensing: This 16 core licence covers all physical processor cores on the target server under the per-core licensing model, eliminating the need for Client Access Licences for users and devices and providing an appropriate licensing model for mid-range multi-core servers in environments with large, variable or anonymous user bases.
- Accelerated Database Recovery: Benefit from the Accelerated Database Recovery feature that significantly reduces database recovery time after a restart or failover, improves transaction log management and enables near-instantaneous transaction rollback for improved database availability and resilience.
- Intelligent Query Processing: Take advantage of enhanced Intelligent Query Processing improvements in SQL Server 2019 including table variable deferred compilation, batch mode on rowstore, scalar user-defined function inlining and approximate query processing for faster and more efficient query execution without manual tuning.
- Relational Database Engine: Store, manage and query structured data using the SQL Server relational database engine with full T-SQL language support, stored procedures, triggers, views, functions and comprehensive transaction management for enterprise data workloads.
- Always Encrypted with Secure Enclaves: Protect sensitive data with the enhanced Always Encrypted feature in SQL Server 2019 that adds secure enclave support for richer query operations on encrypted columns including pattern matching, comparison operations and in-place encryption.
- Linux and Kubernetes Support: Deploy SQL Server 2019 on Linux distributions including Red Hat Enterprise Linux, SUSE Linux Enterprise Server and Ubuntu, or in Docker containers and Kubernetes clusters for flexible and modern infrastructure deployment options alongside traditional Windows Server deployments.
- Graph Database: Model and query complex many-to-many relationships and network data using graph database extensions with node and edge tables and graph-specific query syntax for social networks, recommendation engines and fraud detection scenarios.
- High Availability: Implement high availability and disaster recovery solutions using Always On Failover Cluster Instances and basic Always On Availability Groups limited to two nodes within the Standard edition feature set.
- SQL Server Reporting Services: Create, manage and deliver professional paginated reports, interactive reports and dashboards using SQL Server Reporting Services with a web-based report portal for self-service and enterprise reporting.
- Python and R Integration: Run Python and R scripts directly within the SQL Server engine using Machine Learning Services for in-database machine learning, predictive analytics and advanced data processing without moving data outside the database.
- Security: Protect sensitive data using row-level security, dynamic data masking, transparent data encryption, Always Encrypted with secure enclaves and comprehensive auditing capabilities for regulatory compliance and data protection.
- Backup and Recovery: Protect database data with comprehensive backup and recovery capabilities including full, differential and transaction log backups, point-in-time recovery and backup to Microsoft Azure Blob Storage for off-site data protection.
SQL Server 2019 Standard 16 Core vs Standard 20 Core, Standard 10 Core, Enterprise 16 Core and SQL Server 2017 Standard
SQL Server 2019 Standard 16 Core is a per-core licence for servers with up to 16 cores and no CAL requirement. Standard 20 Core covers larger servers with up to 20 cores, Standard 10 Core covers smaller servers, Enterprise 16 Core removes Standard edition feature limits, while SQL Server 2017 Standard 16 Core is the previous perpetual release with fewer features.
| Software | Best For | Main Use |
|---|---|---|
| SQL Server 2019 Standard 16 Core | Organisations with mid-range servers of up to 16 physical cores and large or anonymous user bases | Per-core licensed SQL Server 2019 Standard database management without CAL requirements for up to 16 cores |
| SQL Server 2019 Standard 20 Core | Organisations with larger servers of up to 20 physical cores | Per-core licensed SQL Server 2019 Standard database management without CAL requirements for up to 20 cores |
| SQL Server 2019 Standard 10 Core | Organisations with smaller servers of up to 10 physical cores | Per-core licensed SQL Server 2019 Standard database management for servers with up to 10 cores |
| SQL Server 2019 Enterprise 16 Core | Large organisations needing the full SQL Server feature set on a 16 core server | Enterprise-scale database management with unlimited memory, advanced compression and full Always On features |
| SQL Server 2017 Standard 16 Core | Organisations needing an older perpetual SQL Server release at a lower cost | Per-core SQL Server 2017 Standard database management for servers with up to 16 cores |
Which Licence Should You Choose?
- Choose SQL Server 2019 Standard 16 Core if you need to licence SQL Server 2019 Standard on a server with up to 16 physical processor cores under the per-core model, particularly for mid-range multi-core servers running internet-facing applications or environments with large or variable numbers of users and devices.
- Choose SQL Server 2019 Standard 20 Core if your server has between 17 and 20 physical processor cores and per-core licensing is appropriate for your environment.
- Choose SQL Server 2019 Standard 10 Core if your server has 10 or fewer physical processor cores and per-core licensing is appropriate for your environment.
- Choose SQL Server 2019 Enterprise 16 Core if you need the full SQL Server Enterprise feature set without Standard edition memory limits or availability group limitations on a 16 core server.
- Choose SQL Server 2017 Standard 16 Core if you need an older perpetual SQL Server release and the SQL Server 2019 features are not required for your environment.
Recommended Products
- Microsoft Software – explore the full range of Microsoft software products.
- SQL Server 2019 Standard 20 Core – suitable for servers with up to 20 physical processor cores.
- SQL Server 2019 Standard 24 Core – suitable for servers with up to 24 physical processor cores.
- Microsoft Office Access 2024 – suitable for desktop database front-end applications connecting to SQL Server.
- Windows Server Licences – suitable if you need a compatible Windows Server operating system for SQL Server deployment.
- Microsoft Office – explore all available Microsoft software versions and licence options.
System Requirements for SQL Server 2019 Standard 16 Core
| Component | Requirement |
|---|---|
| Platform | Windows Server or Linux server |
| Operating System (Windows) | Windows Server 2022, Windows Server 2019, Windows Server 2016; Windows 10, Windows 11 (development and testing only) |
| Operating System (Linux) | Red Hat Enterprise Linux 7.3–8.x, SUSE Linux Enterprise Server v12 SP4 and v15, Ubuntu 16.04 and 18.04 LTS |
| Processor | x64 processor 1.4 GHz minimum; 2.0 GHz or faster recommended; up to 16 physical cores covered by this licence |
| Memory | 1 GB minimum; 4 GB or more recommended; Standard edition maximum buffer pool: 128 GB |
| Storage | 6 GB available disk space minimum for database engine and tools installation |
| Display | 1024 x 768 screen resolution minimum for management tools |
| Network | Gigabit Ethernet or faster network adapter recommended for server deployments |
| Framework | .NET Framework 4.6 or later required for certain features on Windows deployments |
Delivery and Activation
- Product: SQL Server 2019 Standard 16 Core
- Platform: Windows Server or Linux
- Licence Type: Perpetual per-core server licence (16 cores)
- Licence Duration: Lifetime access to SQL Server 2019 Standard
- Delivery Method: Digital delivery by email
- Activation: Activation instructions provided after purchase
- Support: Installation and activation assistance available
How to Get Started
- Complete your order for SQL Server 2019 Standard 16 Core.
- Receive your product key and activation instructions by email after order confirmation.
- Check that your server meets the SQL Server 2019 Standard system requirements.
- Confirm that the total number of physical processor cores on your server does not exceed 16.
- Download the SQL Server 2019 Standard installer from the Microsoft website.
- Run the SQL Server installation wizard and select the features and components you require.
- Enter your product key when prompted to activate your perpetual per-core licence.
- Contact our support team if you need help with installation or activation.
Who Is SQL Server 2019 Standard 16 Core For?
- Organisations running internet-facing applications with large or anonymous user bases on mid-range servers
- Businesses with a large or variable number of users accessing SQL Server databases
- IT departments managing SQL Server on servers with up to 16 physical processor cores
- Database administrators managing SQL Server 2019 instances for business applications
- Application developers building database-driven web applications on servers with up to 16 cores
- Organisations deploying SQL Server 2019 on Linux or in Kubernetes containers on mid-range servers
- Users upgrading from SQL Server 2017 Standard or earlier to the 2019 Standard 16 Core release
Important Licence Information
SQL Server 2019 Standard 16 Core is a perpetual per-core server licence covering up to 16 physical processor cores. All physical cores on the licensed server must be covered, with a minimum of four core licences required per physical processor. No Client Access Licences are required for users or devices accessing a per-core licensed SQL Server instance. This licence covers a single server installation only.
SQL Server 2019 Standard has Standard edition feature limits including a maximum of 128 GB of buffer pool memory and basic Always On Availability Groups limited to two nodes. If your server has more than 16 physical processor cores, additional core licences will be required to cover all cores. Before purchasing, please count the total number of physical processor cores on your server and confirm that the Standard edition feature set meets your database workload requirements.
What is SQL Server 2019 Standard 16 Core?
SQL Server 2019 Standard 16 Core is a perpetual per-core server licence covering up to 16 physical processor cores, providing the SQL Server 2019 Standard database engine, reporting services, high availability and business intelligence tools without requiring Client Access Licences for users or devices accessing the server.
What does the 16 Core licence cover?
The 16 Core licence covers all physical processor cores on a single server up to a total of 16 physical cores across all processors in the server. All physical cores must be licensed and a minimum of four core licences is required per physical processor regardless of the actual core count of that processor.
Does the 16 Core licence cover a server with two 8-core processors?
Yes. A server with two 8-core processors has 16 physical cores in total, which is exactly covered by this 16 Core licence. All 16 physical cores on the server are licensed under this product. If your server has more than 16 physical cores in total, additional core licences will be required.
Do I need Client Access Licences with SQL Server 2019 Standard 16 Core?
No. Under the per-core licensing model, no Client Access Licences are required for users or devices accessing the SQL Server instance. All users and devices can access the server without additional CAL purchases, making per-core licensing cost-effective for environments with large numbers of users or internet-facing applications.
What is the difference between the 16 Core and 20 Core licences?
The SQL Server 2019 Standard 16 Core licence covers servers with up to 16 physical processor cores, while the 20 Core licence covers servers with up to 20 physical processor cores. Both provide the same SQL Server 2019 Standard feature set and per-core licensing benefits. The appropriate licence depends on the total number of physical cores in your server.
What is Accelerated Database Recovery in SQL Server 2019?
Accelerated Database Recovery is a feature in SQL Server 2019 that significantly reduces database recovery time after a server restart or failover, enables near-instantaneous transaction rollback for long-running transactions and improves transaction log management, making databases more available and resilient during high-transaction workloads.
What are the memory limits for SQL Server 2019 Standard?
SQL Server 2019 Standard edition limits the buffer pool memory to a maximum of 128 GB regardless of the number of cores licensed. Users who need more than 128 GB of buffer pool memory for large-scale database workloads should consider SQL Server 2019 Enterprise, which has no buffer pool memory limit.
Does SQL Server 2019 Standard 16 Core run on Linux?
Yes. SQL Server 2019 supports deployment on Linux distributions including Red Hat Enterprise Linux, SUSE Linux Enterprise Server and Ubuntu, as well as in Docker containers and Kubernetes clusters. The 16 Core licence covers the SQL Server 2019 Standard installation regardless of whether it is deployed on Windows Server or a supported Linux distribution.
Does SQL Server 2019 Standard 16 Core include Reporting Services?
Yes. SQL Server 2019 Standard 16 Core includes SQL Server Reporting Services for creating, managing and delivering professional reports and dashboards through a web-based report portal for self-service and enterprise reporting.
Is SQL Server 2019 Standard 16 Core a subscription or a perpetual licence?
SQL Server 2019 Standard 16 Core is a perpetual licence product, meaning you pay once for lifetime access to SQL Server 2019 Standard under the 16 core per-core licensing model without ongoing subscription fees. It does not include upgrades to future versions of SQL Server.
What if my server has more than 16 physical cores?
If your server has more than 16 physical processor cores in total, you will need additional core licences to cover all physical cores on the server. All physical cores must be licensed under the per-core model. Please contact us to discuss the appropriate number of core licences for your specific server configuration.
How will I receive my SQL Server 2019 Standard 16 Core licence?
Your product key and activation instructions will be delivered digitally by email after order confirmation.
Do you provide installation support?
Yes. Installation and activation support is available if you need help setting up SQL Server 2019 Standard on your Windows Server or Linux server.
Reviews
There are no reviews yet.