In case if ItemAppliesTo table contains millions of records, stored procedure spLoadItemAppliesTo will be the reason of high CPU usage.
Problem is caused by leftovers in ItemAppliesTo table
SQL query deletes all records which are no longer have corresponding Item and older than 30 days:
delete iat from ItemAppliesTo iat left join Item i on i.Guid = iat.ItemGuid left join Item i2 on i2.Guid = iat.ResourceTargetGuid where iat.CreatedDate < GETDATE() - 30 and (i.Guid is null or i2.Guid is null)
ITMS 7.1, 7.5
Imported Document ID: TECH226861
Subscribing will provide email updates when this Article is updated. Login is required.