Summary

This article contains important information to read before you install Microsoft SQL Server 2016 Service Pack 3 (SP3). It describes how to get the service pack, the list of fixes that are included in the service pack, known issues, and a list of copyright attributions for the product.

Note This article serves as a single source of information to locate all documentation that's related to this service pack. It includes all the information that you previously found in the release notes and Readme.txt files.

Known issues with this update

  • Issue 1

    Under certain circumstances, there is a known uninstallation issue that affects SQL Server 2017 CU 20. After you uninstall CU 20, SQL Server doesn't come online, and the following error entry is logged in the SQL Server log:

    The script level for 'system_xevents_modification.sql' in database 'master' cannot be downgraded from XXXXXXXXX to XXXXXXXXX, which is supported by this server. This usually implies that a future database was attached and the downgrade path is not supported by the current installation. Install a newer version of SQL Server and re-try opening the database.

    The mitigation is to enable Trace Flag T902. After that, SQL Server will come online and you are done. You don't have to uninstall the program again. To upgrade to the new CU, you have to first remove this flag.

    SQL Server 2017 CU21 or any later CU release contains the fix.

  • Issue 2

    If you use the Change Tracking feature, you might encounter errors. For more information, see KB 5007039 before you apply this update package.

How to get SQL Server 2016 SP3

SQL Server 2016 SP3, Microsoft SQL Server 2016 SP3 Express, and Microsoft SQL Server 2016 SP3 Feature Pack are available for manual download and installation at the following Microsoft Download Center websites.

SQL Server 2016 SP3

Download Download the package now.

SQL Server 2016 SP3 Express

Download Download the package now.

Microsoft SQL Server 2016 SP3 Feature Pack

Download Download the package now.


Note After you install this service pack, the SQL Server service version should be 13.0.6300.2. Microsoft SQL Server 2016 service packs are cumulative updates. SQL Server 2016 SP3 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP3.

List of fixes included in SQL Server 2016 SP3

Microsoft SQL Server 2016 service packs are cumulative updates. SQL Server 2016 SP3 upgrades all editions and service levels of SQL Server 2016 to SQL Server 2016 SP3. In addition to the fixes that are listed in this article, SQL Server 2016 SP3 includes hotfixes that were included in SQL Server 2016 Cumulative Update 1 (CU1) to SQL Server 2016 SP2 CU17.

For more information about the cumulative updates that are available in SQL Server 2016, see SQL Server 2016 build versions.

Notes

  • Additional fixes that aren't documented here may also be included in the service pack.

  • This list will be updated when more articles are released.

For more information about the bugs that are fixed in SQL Server 2016 SP3, go to the following Microsoft Knowledge Base articles.

VSTS bug number

KB article number

Area Path

Description

14048342

4578579

High Availability

Improvement: Availability Group listener without the load balancer in SQL Server 2019, 2017, and 2016

12344341

4515772

High Availability

FIX: Transaction log isn't truncated on a single node Availability Group in SQL Server

13323519

4541303

High Availability

FIX: Non-yielding Scheduler error may occur with Always On availability group in Microsoft SQL Server

14059362

5003596

High Availability

FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016

13829857

High Availability

Fixes an access violation exception that may occur when sp_server_diagnostics is executed

14031841

High Availability

Fixes an issue that causes the database log_reuse_wait_desc to change to AVAILABILITY_REPLICA when a database is removed from Availability Group

13435419

Integration Services

Fixes security vulnerabilities CVE-2015-6420 and CVE-2017-15708

13163658

5005686

Setup & Install

FIX: Setup fails when you install SQL Server on FCI with mount points

14056703

4537868

SQL Connectivity

Improvement: Enable DNN feature in SQL Server 2019 and 2016 FCI

13526297

SQL Engine

INSERT EXEC failed because the stored procedure altered the schema of the target table error in SQL Server 2016

12670403

4500511

SQL Engine

Improvement: Improve CDC supportability and usability with In-Memory Databases

13330609

4541132

SQL Engine

Improvement: Size and retention policy are increased in default XEvent trace system_health in SQL Server 2019, 2017, and 2016

13032229

5003937

SQL Engine

Improvement: New XEvents temp_table_cache_trace and temp_table_destroy_list_trace are created in SQL Server 2019 and 2016

11324212

4046056

SQL Engine

FIX: Assertion occurs when you access memory-optimized table through MARS in SQL Server 2017 or 2016

12920913

4493329

SQL Engine

FIX: Error occurs when sp_addarticle is used to add article for transactional replication to memory-optimized table on subscriber in SQL Server 2017 and 2016

13048725

4506023

SQL Engine

FIX: Geocentric Datum of Australia 2020 is added to SQL Server 2017, 2016, and 2014

13186160

4526524

SQL Engine

FIX: SQL update package does not update Local DB files correctly when installed using SqlLocalDb.msi

12107073

4531386

SQL Engine

FIX: Assertion occurs when sys.sp_cdc_enable_table is used to enable CDC on column set table in SQL Server 2017 and 2016

13128336

4536005

SQL Engine

FIX: Fix incorrect memory page accounting that causes out-of-memory errors in SQL Server

13127842

4551720

SQL Engine

FIX: Access violation exception occurs when promoting latches of frequently used database pages in SQL Server 2017 and 2016

13345987

5004059

SQL Engine

FIX: Managed backup fails to take full backup when backup preference is set to secondary on Read-Only secondary in SQL Server 2016

14048422

5004466

SQL Engine

FIX: Update SQL Server 2017 and 2016 CEIP service to send usage and diagnostic data to a new endpoint

14037575

5005453

SQL Engine

FIX: SQLLocalDB.exe info doesn't display information about the specified LocalDB instance if SQL LocalDB 2016 SP2 is installed

13327250

5005687

SQL Engine

FIX: "SQLLocalDB.exe versions" stops listing the versions of LocalDB installed on the computer if SQL LocalDB 2016 SP1/SP2 is installed

13965515

SQL Engine

Fixes EXCEPTION_INVALID_CRT_PARAMETER exception when you perform INSERT\UPDATE of wide replicated table

13990061

SQL Engine

Fixes a memory leak when you use STDistance spatial method with a spatial index

13992219

SQL Engine

Fixes the sp_hadr_verify_replication_publisher displaying wrong distribution database name in error message

14034656

SQL Engine

Introduces new logging and XEvents to help troubleshoot long-running Buffer Pool scans. For more information, see
Operations that scan SQL Server buffer pool are slow on large memory machines | Microsoft Docs

14042368

SQL Engine

Fixes an issue in which some of the temporary working folders are not cleared when many R queries are run in parallel

14043334

SQL Engine

Fixes the following assertion that may cause SQL Server to generate a dump:

RecXdes::AnalyzeLogRecord file =
FilePath\FileName line = LineNumber expression = m_state == XDES_COMMITTED

14068486

SQL Engine

Fixes an issue where you are unable to set up Managed Backup on SQL Server 2016 by using Azure SAS credential with a long secret due to SAS expiration

14072767

SQL Engine

Enables new logging format for SQL Writer that provides additional troubleshooting data in an easy to read/parse format, along with enhanced control of log verbosity and enabling/disabling. For more information, see SQL Server VSS Writer logging - SQL Server | Microsoft Docs

14117764

SQL Engine

Fixes Snapshot Agent performance issue observed on SQL 2016 SP2 CU13 and later

14130908

SQL Engine

Fixes a missing data problem in Change Data Capture (CDC) side table and adds more error handling to prevent data loss

14187407

SQL Engine

Fixes an issue where you cannot run Machine Learning Services (R scripts) when you slipstream an installation of Microsoft SQL Server 2016 without vc_redist 2015 (msvcp140.dll)

14193631

SQL Engine

Fixes an issue where an access violation (AV) occurs and you see keywords EXCEPTION_ACCESS_VIOLATION and FFtFileObject::ProcessSetInfo in the SQL Server error log when you use FileTable feature in SQL Server on the machine that uses Windows Defender Antivirus.

Note This issue can occur after Windows Defender updates on Windows 10, version 1607 or a later version, Windows Server 2016, and Windows Server 2019

12904837

4480630

SQL Performance

Improvement: Enhancement adds sql_statement_post_compile XEvent in SQL Server 2017 and 2016

11985415

13377244

4530907

SQL Performance

Improvement: Corrupt statistics can be detected by using extended_logical_checks in SQL Server 2019 and 2016

12994428

SQL Performance

Makes CPU time and duration reported by xevent query_plan_profile more accurate. For more information, see Query Profiling Infrastructure | Microsoft Docs

13989322

SQL Performance

Fixes the Access Violation error that occurs when ALTER INDEX is forced to execute using Query Store

14056563

SQL Performance

Fixes a stack overflow issue when yourun a query that has a very large number of UNION clauses

14080827

SQL Performance

Fixes an assertion in CQPOnDemandTask::ExecuteQPJob if auto async update statistics is enabled

10087766

5005689

SQL Security

FIX: SQL Server fails to start with error messages when an incorrect certificate is provisioned for SSL

File name

SHA256 hash

SQLServer2016SP3-KB5003279-x64-ENU.exe

CAE75F65C7C3C263A7BDBAEF0F4AFD0AE49BAF57C08AB27141A7B26008658A91

SQLServer2016-SSEI-Expr.exe

25692917049A856B9CCEA2C1242F42A1A585D3AD94F1F449E93BE183F17C397A

If, for any reason, you choose to uninstall SQL Server 2016 SP3, the uninstallation of SQL Server 2016 SP3 will not be blocked, and you will be able to uninstall SQL Server 2016 SP3 in the same manner as any other service packs. However, if you are running the Standard, Web, or Express edition of SQL Server, and you are using some new features that are unlocked only when you start SQL Server 2016 SP3, you might experience errors or see databases left in a suspect state after the uninstallation of SQL Server 2016 SP3. Even worse, if the system databases are using new features (for example, partitioned tables in master databases), this could prevent SQL Server instances from starting after you uninstall SQL Server 2016 SP3.

We recommend that you verify that all the new features are disabled or dropped before you choose to uninstall SQL Server 2016 SP3 on editions other than the Enterprise edition. You cannot drop the memory_optimized_data filegroup. Therefore, if you have set up the memory_optimized_data filegroup on your database with SP3, you should not uninstall SQL Server 2016 SP3. Otherwise, the database will get into a suspect state, and the following entry will be logged in the error log:

DateTime spid15s Error: 41381, Severity: 21, State: 1.
DateTime  spid15s The database cannot be started in this edition of SQL Server because it contains a MEMORY_OPTIMIZED_DATA filegroup. See Books Online for more details on feature support in different SQL Server editions.

To learn how to install SQL Server 2016 R Services on Windows, see Install SQL Server 2016 R Services

References

For more information about how to determine the current SQL Server version and edition, select the following article number to go to the article in the Microsoft Knowledge Base:

321185 How to identify your SQL Server version and edition

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×