Performance degradation when actively using clones

  • Active usage of the Sitecore Cloning functionality may lead to performance degradation when multiple content authors use the Content Editor at the same time. 

    The issue may be caused by high volume of latches in the Notifications table of the SQL Server, and can be identified using the SQL Server Performance Monitor application and reviewing the value of the Latches object. For more information about Latching in SQL server, review the following article:
    https://technet.microsoft.com/en-us/library/aa224727(v=SQL.80).aspx

  • Create a non-clustered index in the Notifications table of the master database:

    CREATE NONCLUSTERED INDEX [Notifications_Multi_idx] ON [dbo].[Notifications] 
    ([ItemId], [Processed], [Language], [Version], [InstanceType]) INCLUDE ([Id], [InstanceData], [Created])

    Note: In some cases introducing the aforementioned index may impact the performance of item editing operations. If such an impact is noticed, the suggested changes have to be reverted.

Applies to:

CMS 6.4+

March 30, 2015
March 30, 2015

Reference number:

430259

Keywords: 

  • CMS,
  • Performance