Operational Defect Database
BugZero found this defect 1113 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 14068003
KB5003596 - FIX: Log line is verbose when Always On Availability Group has many databases in SQL Server 2019 and 2016 - Microsoft Support
Last update date:
9/16/2021
Affected products:
SQL Server 2019 on Linux
SQL Server 2019 on Windows
SQL Server 2016
SQL Server 2016 Service Pack 3 - duplicate (do not use)
Affected releases:
build lower than 15.0.4138.2
Fixed releases:
15.0.4138.2
Description:
Symptoms
Assume that you have an Always On Availability Group (AG) that has many databases in Microsoft SQL Server 2019 or 2016. During a SQL Server restart, a replica disconnection, or AG failover, you notice that the volume of the log line for DbMgrPartnerCommitPolicy::SetSyncAndRecoveryPoint is extremely high and causes unnecessary CPU usage.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Resolution
This problem is fixed in the following cumulative update for SQL Server: Cumulative Update 11 for SQL Server 2019 About cumulative updates for SQL Server Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server: Latest cumulative update for SQL Server 2019 Service pack information for SQL Server 2016 This problem is fixed in the following service pack for SQL Server: Service Pack 3 for SQL Server 2016 About service packs for SQL Server: Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. We recommend that you apply the latest service pack and the latest cumulative update for that service pack. You do not have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article to find more information about the latest service pack and latest cumulative update. Determine the version, edition, and update level of SQL Server and its components
References
Learn about the terminology that Microsoft uses to describe software updates.
