Muokkaa

Jaa


SQL Server 2019 Big Data Clusters platform release notes

Applies to: SQL Server 2019 (15.x)

Important

The Microsoft SQL Server 2019 Big Data Clusters add-on will be retired. Support for SQL Server 2019 Big Data Clusters will end on February 28, 2025. All existing users of SQL Server 2019 with Software Assurance will be fully supported on the platform and the software will continue to be maintained through SQL Server cumulative updates until that time. For more information, see the announcement blog post and Big data options on the Microsoft SQL Server platform.

The following release notes apply to SQL Server 2019 Big Data Clusters. This article is broken into sections for each release describing the CU changes. The article also lists known issues for the most recent releases of SQL Server 2019 Big Data Clusters.

Tested configurations

SQL Server 2019 Big Data Clusters is a fully containerized solution orchestrated by Kubernetes. Starting with SQL Server 2019 (15.x) CU12, each release of SQL Server Big Data Clusters is tested against a fixed configuration of components. The configuration is evaluated with each release and adjustments are made to stay in-line with the ecosystem as Kubernetes continues to evolve.

Important

Kubernetes is a fast paced ecosystem. It is key to keep your platform updated in order to be secure, and to be on a tested configuration for SQL Server Big Data Clusters.

Warning

On SQL Server 2019 (15.x) Cumulative Update 15, the upgrade order is critical. Upgrade your big data cluster to CU15 before upgrading the Kubernetes cluster to version 1.21. If the Kubernetes cluster is upgraded to version 1.21 before BDC is upgraded to CU14 or CU15 then the cluster will end up in error state and the BDC upgrade will not succeed. In this case, reverting back to Kubernetes version 1.20 will fix the problem.

The following table contains the tested configuration matrix for each release of SQL Server 2019 Big Data Clusters:

Release Container OS Kubernetes API Runtime Data Storage Log Storage
CU23 Ubuntu 20.04 LTS 1.25.4 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU22 Ubuntu 20.04 LTS 1.25.4 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU21 Ubuntu 20.04 LTS 1.23.1 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU20 Ubuntu 20.04 LTS 1.23.1 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU19 Ubuntu 20.04 LTS 1.23.1 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU18 GDR Ubuntu 20.04 LTS 1.23.1 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU18 Ubuntu 20.04 LTS 1.23.1 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU17 Ubuntu 20.04 LTS 1.23.1 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU16 GDR Ubuntu 20.04 LTS 1.21 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU16 Ubuntu 20.04 LTS 1.21 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU15 Ubuntu 20.04 LTS 1.21 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU14 Ubuntu 20.04 LTS 1.21 containerd 1.4.6
CRI-O 1.20.4
Block only Block only
CU13 Ubuntu 20.04 LTS 1.20 containerd 1.4.6
CRI-O 1.20.0
Block only Block only
CU12 Ubuntu 20.04 LTS 1.20 containerd 1.4.3
docker 20.10.2
CRI-O 1.20.0
Block only Block only

Restrictions:

  • SQL Server 2019 Big Data Clusters is supported as a workload. Microsoft provides support for the software components on the containers installed and configured by SQL Server 2019 Big Data Clusters only. The support team doesn't support Kubernetes itself, and other containers that might influence SQL Server 2019 Big Data Clusters behavior. For Kubernetes support, contact your certified Kubernetes distribution provider.
  • SQL Server 2019 Big Data Clusters requires block storage for all persisted volumes. Management operation on top of the persisted volumes created and used by a big data cluster is a capability that depends on the storage provider including, for example, operations to expand persistent volumes (PVs). Reference your specific CSI storage provider documentation or the partner reference architecture and white papers.
  • The open-source components included by SQL Server 2019 Big Data Clusters are fixed for that particular release and must not be updated or modified.
  • Container images are provided "as-is". Composability features of Kubernetes aren't supported. Changing the set of container images in a SQL Server 2019 Big Data Cluster release, or to customize the containers, isn't supported.

Reference architecture and white papers for SQL Server Big Data Clusters can be found on the following pages:

Release history

The following table lists the release history for SQL Server 2019 Big Data Clusters. For more information, see SQL Server 2019 Big Data Clusters cumulative updates history.

Release 1 SQL Server 2019 Big Data Clusters version Azure Data CLI (azdata) version 2 Release date Details
CU23 15.0.4335.1 20.3.12 Jun 15 2023 Libraries are same as CU19.
CU22 15.0.4322.2 20.3.12 Jun 15 2023 Libraries are same as CU19.
CU21 15.0.4316.3 20.3.12 Jun 15 2023 Tested configurations, libraries are same as CU19.
CU20 15.0.4312.2 20.3.12 Apr 14 2023 Tested configurations, libraries are same as CU19.
CU19 15.0.4298.1 20.3.12 Feb 16 2023
CU18 GDR KB 5021124 15.0.4280.7 20.3.12 Feb 14 2023
CU18 15.0.4261.1 20.3.12 Sep 28 2022
CU17 15.0.4249.2 20.3.12 Aug 11 2022
CU16 GDR KB 5014356 15.0.4236.7 20.3.12 Jun 14 2022
CU16 15.0.4223.1 20.3.11 May 2 2022
CU15 15.0.4198.2 20.3.10 Jan 27 2022
CU14 15.0.4188.2 20.3.9 Nov 22 2021
CU13 15.0.4178.15 20.3.8 Sep 9 2021
CU12 15.0.4153.13 20.3.7 Aug 4 2021
CU11 15.0.4138.2 20.3.5 Jun 10 2021
CU10 15.0.4123.1 20.3.2 Apr 6 2021
CU9 15.0.4102.2 20.3.0 Feb 11 2021
CU8-GDR 15.0.4083.2 20.2.6 Jan 12 2021
CU8 15.0.4073.23 20.2.2 Oct 19 2020
CU6 15.0.4053.23 20.0.1 Aug 4 2020
CU5 15.0.4043.16 20.0.0 June 22 2020
CU4 15.0.4033.1 15.0.4033 March 31 2020
CU3 15.0.4023.6 15.0.4023 March 12 2020
CU2 15.0.4013.40 15.0.4013 Feb 13 2020
CU1 15.0.4003.23 15.0.4003 Jan 7 2020
GDR1 15.0.2070.34 15.0.2070 Nov 4 2019

1 CU7 isn't available for SQL Server 2019 Big Data Clusters.

2 Azure Data CLI (azdata) version reflects the version of the tool at the time of the CU release. azdata can also release independently of the server release, therefore you might get newer versions when you install the latest packages. Newer versions are compatible with previously released CUs.

How to install updates

To install updates, see How to upgrade SQL Server Big Data Clusters.

Known issues

For known issues and resolves issues, see SQL Server 2019 Big Data Clusters platform known issues.

For more information about SQL Server 2019 Big Data Clusters, see Introducing SQL Server Big Data Clusters.