Excessive SQL Server DTU consumption after deployment to Azure

  • Description

    The Sitecore Experience Platform cache's prefetch functionality attempts to pre-populate item caches on role start up. This causes excessive SQL Server DTU consumption on the core database,  SQL timeout exceptions, and unresponsive websites. In some cases, for example on topologies with 4 Sitecore roles and small SQL Server tiers, the DTU on the core database can reach 100% and remain there for up to 40 minutes.

  • To resolve this issue, you can disable the Sitecore prefetch cache functionality on all Sitecore-based roles with the DisablePrefetchCache.scwdp.zip package. It is available as artifact of GitHub by default, so no additional actions are required for new deployments.

    For existing deployments, add the Sitecore.Disable.Prefetch.config file to the \App_Config\Include folder on all instances using FTP access.

Applies to:

CMS 9.0 Update-1

January 19, 2018
January 19, 2018

Keywords: 

  • Azure,
  • Performance