High resource consumption by Reference Data database might degrade site performance

  • Under high load, the Reference Data database might consume a lot of CPU resources. This might lead to slower responses from the Reference Data xConnect service, which as a result might affect the CD response time.

    The issue is caused by non-optimal code of the GetDefinitions and SaveDefinitions stored procedures.

  • To fix the issue, follow the steps below:

    1. Back up the Reference Data database.
    2. Download and run the SQL script Sitecore.Support.312397.sql against Reference Data database to alter the relevant stored procedures.

Applies to:

CMS 9.0 Initial Release - 9.2 Initial Release

CMS 9.3 Initial Release

September 03, 2019
November 28, 2019

Reference number: