SQL server 2019 standard 24 core

SQL Server 2019 Standard 24 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 24 licensed cores on Windows and Linux.

SQL Server 2019 Standard 24 Core – UK Digital Database Server Licence

SQL Server 2019 Standard 24 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 24 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 larger 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 24 core licence covers a server with up to 24 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 24 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 24 Core

SQL Server 2019 Standard 24 Core is a per-core server licence covering up to 24 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 24 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 24 Core?

• Per-core licensing covering up to 24 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 24 Core

• Per-Core Licensing: This 24 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 larger 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 24 Core vs Standard 24 CAL, Standard 10 Core, Enterprise 24 Core and SQL Server 2017 Standard

SQL Server 2019 Standard 24 Core is a per-core licence for servers with up to 24 cores and no CAL requirement. Standard 24 CAL requires individual user or device CALs, Standard 10 Core covers smaller servers, Enterprise 24 Core removes Standard edition feature limits, while SQL Server 2017 Standard is the previous perpetual release with fewer features.

Which Licence Should You Choose?

• Choose SQL Server 2019 Standard 24 Core if you need to licence SQL Server 2019 Standard on a server with up to 24 physical processor cores under the per-core model, particularly for larger multi-core servers running internet-facing applications or environments with large or variable numbers of users and devices.
• Choose SQL Server 2019 Standard 24 CAL if you have up to 24 known internal users or devices and the Server plus CAL licensing model is more cost-effective 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 still appropriate for your environment.
• Choose SQL Server 2019 Enterprise 24 Core if you need the full SQL Server Enterprise feature set without Standard edition memory limits or availability group limitations on a 24 core server.
• Choose SQL Server 2017 Standard 24 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 24 CAL – suitable if the Server plus CAL licensing model is more appropriate for your environment.
• SQL Server 2017 Standard 24 Core – suitable if an older SQL Server 2017 release meets your requirements.
• 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 24 Core

Delivery and Activation

• Product: SQL Server 2019 Standard 24 Core
• Platform: Windows Server or Linux
• Licence Type: Perpetual per-core server licence (24 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

1. Complete your order for SQL Server 2019 Standard 24 Core.
2. Receive your product key and activation instructions by email after order confirmation.
3. Check that your server meets the SQL Server 2019 Standard system requirements.
4. Confirm that the total number of physical processor cores on your server does not exceed 24.
5. Download the SQL Server 2019 Standard installer from the Microsoft website.
6. Run the SQL Server installation wizard and select the features and components you require.
7. Enter your product key when prompted to activate your perpetual per-core licence.
8. Contact our support team if you need help with installation or activation.

Who Is SQL Server 2019 Standard 24 Core For?

• Organisations running internet-facing applications with large or anonymous user bases on multi-core servers
• Businesses with a large or variable number of users accessing SQL Server databases
• IT departments managing SQL Server on larger servers with up to 24 physical processor cores
• Database administrators managing SQL Server 2019 instances for high-demand business applications
• Application developers building database-driven web applications on servers with up to 24 cores
• Organisations deploying SQL Server 2019 on Linux or in Kubernetes containers on larger servers
• Users upgrading from SQL Server 2017 Standard or earlier to the 2019 Standard 24 Core release

Important Licence Information

SQL Server 2019 Standard 24 Core is a perpetual per-core server licence covering up to 24 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 24 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.