Configuration Manager DRS performance issue after you install hotfix 3125525
This article provides a solution for the Configuration Manager Database Replication Service (DRS) performance issues that occur after you install hotfix 3125525.
Original product version: Configuration Manager (current branch), Microsoft System Center 2012 R2 Configuration Manager, Microsoft System Center 2012 Configuration Manager
Original KB number: 4024301
Symptom
After you install hotfix 3125525, you experience the following performance issues when you use Configuration Manager DRS:
- Messages are processed very slowly, for example, less than 1,000 messages are processed in an hour.
- If it takes more than 30 minutes (by default) to process a message, the replication link may become degraded.
- The average CPU time for SQL Server change tracking is 2.7 to 4 seconds.
Note
Hotfix 3125525 is included in the following SQL Server cumulative updates:
Resolution
To fix the issue, install the latest Cumulative Update for your SQL Server version:
| SQL Server version | The latest Cumulative Update |
|---|---|
| SQL Server 2012 Service Pack 3 | Download the latest cumulative update |
| SQL Server 2014 RTM | Download the latest cumulative update |
| SQL Server 2014 Service Pack 1 | Download the latest cumulative update |
| SQL Server 2014 Service Pack 2 | Download the latest cumulative update |
| SQL Server 2016 RTM | Download the latest cumulative update or Install SQL Server 2016 Service Pack 1 |
More information
For more information about the fixes for this issue, see the following articles: