Analytics performance optimization in Sitecore XP 9.0 and later

  • Description

    In the Experience Database (xDB), under high analytics traffic, you might experience the following issues:

    • The rebuilding of the reporting database is slow.
    • xDB data processing is delayed.
    • The Experience Analytics dashboard does not display recent data.
    • High CPU utilization on the Processing role server.
  • To resolve these issues:

    Step 1

    • For Sitecore XP 9.0 Initial Release – 9.1 Update-1
      Download and add the following configuration file to the \App_Config\Include\zzz folder:
      Sitecore.AnalyticsOptimization.config
    • For Sitecore XP 9.0 Initial Release – 9.0 Update-2, download and execute the following script against your reporting and reporting.secondary databases:
      Sitecore.AnalyticsOptimization.sql
    • For Sitecore XP 9.1 Initial Release – 9.1 Update-1, download and execute the following script against your reporting and reporting.secondary databases:
      Sitecore.AnalyticsOptimization.sql

    Step 2

    • For Sitecore XP 9.0 Initial Release
      You must upgrade to 9.0 rev. 171219 (Update-1) or Sitecore XP 9.1 (Initial Release).
    • For Sitecore XP 9.0 Update-1
      Install the following hotfix: SC Hotfix 307942-1.zip
    • For Sitecore XP 9.0 Update-2
      Install the following hotfix: SC Hotfix 307949-1.zip
    • For Sitecore XP 9.1 Initial Release – 9.1 Update-1
      You do not need a hotfix for this Sitecore XP version.

    Step 3

    Step 4

    • You must install the hotfix according to the readme.txt file located inside the archive.
    • The Sitecore package from the hotfix archive file must be installed on the Content Management (CM) instance and then synchronized with other Sitecore instances using the regular deployment practices specific to the solution.
    • Contact Sitecore Support to get a solution for other Sitecore XP releases or if you have other hotfixes already installed.

Applies to:

CMS 9.1 Initial Release - 9.1 Update-1

CMS 9.2 Initial Release

April 12, 2019
August 02, 2019

Reference number:

230550, 304087, 310372, 313758, 313757