SQL server 2022 standard 24 core

SQL Server 2022 Standard 24 Core is a professional per-core relational database server licence providing the SQL Server 2022 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 2022 Standard 24 Core – UK Digital Database Server Licence

SQL Server 2022 Standard 24 Core is a comprehensive per-core database server licence designed for organisations that need to licence SQL Server 2022 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.

SQL Server 2022 is the most recent long-term support release of Microsoft SQL Server, delivering significant new capabilities over SQL Server 2019 including Azure Synapse Link for real-time analytics without impacting production workloads, improved Intelligent Query Processing with parameter sensitive plan optimisation, contained availability groups for simplified Always On deployments, ledger tables for tamper-evident data verification and enhanced Azure integration features. Per-core licensing eliminates the need for Client Access Licences, making it the appropriate model for environments with large, variable or anonymous user bases or internet-facing applications. A 24 core licence covers a server with up to 24 physical processor cores within the Standard edition feature 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 2022 Standard 24 Core

SQL Server 2022 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 2022 Standard is subject to feature limitations compared to SQL Server 2022 Enterprise, including a maximum of 128 GB of buffer pool memory and basic Always On Availability Groups. 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 2022 runs on Windows Server 2019 and later as well as supported Linux distributions including Red Hat Enterprise Linux, SUSE Linux Enterprise Server and Ubuntu.

Why Choose SQL Server 2022 Standard 24 Core?

• The latest long-term support release of SQL Server with per-core licensing for up to 24 cores
• No Client Access Licences required for users or devices accessing the server
• Azure Synapse Link for real-time analytics without impacting production database performance
• Parameter sensitive plan optimisation for improved query performance on skewed data distributions
• Ledger tables for tamper-evident and cryptographically verified data records
• Contained availability groups for simplified Always On deployment and management
• Enhanced Azure integration including Azure Purview, Azure Active Directory authentication and Azure Synapse
• Improved Linux and Kubernetes container support for flexible deployment options
• Perpetual licence with lifetime access to SQL Server 2022 Standard
• Digital delivery by email after order confirmation

Key Features of SQL Server 2022 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.
• Azure Synapse Link: Use Azure Synapse Link for SQL Server 2022 to replicate data changes from SQL Server to Azure Synapse Analytics in near real time for advanced analytics, reporting and machine learning workloads without impacting the performance of the production SQL Server database.
• Parameter Sensitive Plan Optimisation: Benefit from the parameter sensitive plan optimisation feature that automatically creates multiple cached query plans for a single parameterised query to handle skewed data distributions, significantly reducing the performance problems caused by parameter sniffing in high-traffic database workloads.
• Ledger Tables: Use ledger tables to create tamper-evident database records that are cryptographically verified using blockchain-based digest storage, providing an immutable audit trail for sensitive financial, compliance and regulatory data management scenarios.
• Contained Availability Groups: Simplify Always On Availability Group deployment and management using contained availability groups that include system objects such as SQL Server Agent jobs, logins and linked servers within the availability group for easier failover and simplified administration.
• 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.
• Intelligent Query Processing: Take advantage of the latest Intelligent Query Processing improvements in SQL Server 2022 including degree of parallelism feedback, cardinality estimation feedback and memory grant feedback persistence for progressively improving query performance over time.
• 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.
• Azure Active Directory Authentication: Authenticate SQL Server connections using Azure Active Directory identities for centralised identity management, conditional access policies and multi-factor authentication support without requiring Windows domain accounts.
• Linux and Kubernetes Support: Deploy SQL Server 2022 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.
• 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.
• Security: Protect sensitive data using row-level security, dynamic data masking, transparent data encryption, Always Encrypted with secure enclaves, ledger tables and comprehensive auditing capabilities for regulatory compliance and data protection.

SQL Server 2022 Standard 24 Core vs Standard 16 Core, Standard 10 Core, Enterprise 24 Core and SQL Server 2019 Standard

SQL Server 2022 Standard 24 Core is a per-core licence for the latest SQL Server release on servers with up to 24 cores. Standard 16 Core covers mid-range servers, Standard 10 Core covers smaller servers, Enterprise 24 Core removes Standard edition feature limits, while SQL Server 2019 Standard is the previous long-term support release with fewer features.

Which Licence Should You Choose?

• Choose SQL Server 2022 Standard 24 Core if you need the latest perpetual SQL Server release with Azure Synapse Link, parameter sensitive plan optimisation and ledger tables on a server with up to 24 physical processor cores under the per-core licensing model.
• Choose SQL Server 2022 Standard 16 Core if your server has between 11 and 16 physical processor cores and the latest SQL Server 2022 features are required.
• Choose SQL Server 2022 Standard 10 Core if your server has 10 or fewer physical processor cores and the latest SQL Server 2022 features are required.
• Choose SQL Server 2022 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 2019 Standard 24 Core if you need an older perpetual SQL Server release and the SQL Server 2022 features are not required for your environment.

Recommended Products

• Microsoft Software – explore the full range of Microsoft software products.
• SQL Server 2019 Standard 24 Core – suitable if the previous SQL Server 2019 release meets your requirements.
• SQL Server 2019 Standard 24 CAL – suitable if the Server plus CAL licensing model is more appropriate for your environment.
• 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 2022 Standard 24 Core

Delivery and Activation

• Product: SQL Server 2022 Standard 24 Core
• Platform: Windows Server or Linux
• Licence Type: Perpetual per-core server licence (24 cores)
• Licence Duration: Lifetime access to SQL Server 2022 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 2022 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 2022 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 2022 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 2022 Standard 24 Core For?

• Organisations needing the latest SQL Server release on larger multi-core servers with up to 24 cores
• Businesses running internet-facing applications with large or anonymous user bases
• IT departments managing SQL Server on servers with up to 24 physical processor cores
• Database administrators needing Azure Synapse Link for real-time analytics integration
• Organisations needing ledger tables for tamper-evident regulatory compliance data management
• Application developers building database-driven web applications on servers with up to 24 cores
• Users upgrading from SQL Server 2019 Standard or earlier to the 2022 Standard 24 Core release

Important Licence Information

SQL Server 2022 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 2022 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.