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 rev. 171002 (Initial Release) – Sitecore XP 9.1 rev. 002459 (Update-1)
      Download and add the following configuration file to the \App_Config\Include\zzz folder:
      Sitecore.AnalyticsOptimization.config
      Download and execute the following script against your reporting and reporting.secondary databases:
      Sitecore.AnalyticsOptimization.sql

    Step 2

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

    Step 3

    Step 4

    • If you have an XP Single topology, you must apply the solution to the server that performs a Standalone role.
    • If you have an XP Scaled topology, you must apply the solution to every server that performs a Processing role.
    • Check all installation instructions from the hotfix and/or the package readme.txt files found inside the corresponding zip archives.
    • Contact Sitecore Support to get a solution for other Sitecore XP releases or if you have other hotfixes already installed.

Applies to:

CMS 9+

April 12, 2019
June 06, 2019

Reference number:

230550, 304087, 310372, 313758, 313757