I have installed sql server 2019 in Jan 2021.
We are planning to patch the sqlserver and from this link there are 2 options:
GDR
CU
I couldn't find clear reference to understand the basis on how to decide whether to choose GDR or CU?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this communityI have installed sql server 2019 in Jan 2021.
We are planning to patch the sqlserver and from this link there are 2 options:
GDR
CU
I couldn't find clear reference to understand the basis on how to decide whether to choose GDR or CU?
GDR stands for General Distribution Release, whilst CU stands for Cumulative Update. The difference is that GDR patches contain only security fixes, and CUs include security fixes and functional fixes.
As for which patch branch to follow, Microsoft's own advice from the forementioned page says:
For any given baseline, either the GDR or CU updates could be options (see below).
- If SQL Server installation is at a baseline version, you can choose either the GDR or CU update.
- If SQL Server installation has intentionally only installed past GDR updates, then choose to install the GDR update package.
- If SQL Server installation has intentionally installed previous CU updates, then chose to install the CU security update package.
As a rule of a thumb, install Cumulative Updates unless you know that GDR is required. Please read CU patch notes before installing, as they do change SQL Server's behaviour.
Unless you're specifically required to use GDR, go with CU. The fixes and feature updates in CUs may be useful "non-critical fixes" and can include performance fixes. In almost all cases, you want the ability to benefit from these non-critical fixes. In my experience, the install base for CU instances is so much larger that it is the presumed default.
The only time I've encountered GDR is when a vendor, customer, or contract specifically required that the instance of SQL Server have it. Those specific applications require that the RDBMS be as maximally code-stable as possible. The software may require validation, verification, or satisfy some other whatever technical, regulatory, legal, or contractual obligations.