We were able to notice there was a CPU hike in our site and below is the corresponing query we found to be the reason.Any help on what this could be related with? We would like to know when and where this query gets executed. INSERT INTO @Result SELECT tblContentLanguage.fkLanguageBranchID AS OwnerLanguageID, NULL AS ReferencedLanguageID, tblContent.pkID AS OwnerID, tblContentLanguage.Name As OwnerName, tp.pkID AS ReferencedID, tpl.Name AS ReferencedName, 2 AS ReferenceType FROM tblContent INNER JOIN tblContentLanguage ON tblContentLanguage.fkContentID=tblContent.pkID INNER JOIN tblContent AS tp ON tblContent.ArchiveContentGUID=tp.ContentGUID INNER JOIN tblContentLanguage AS tpl ON tpl.fkContentID=tp.pkID WHERE (tblContent.ArchiveContentGUID IN (SELECT PageGUID FROM @pages)) AND tpl.fkLanguageBranchID=tp.fkMasterLanguageBranchID AND tblContentLanguage.fkLanguageBranchID=tblContent.fkMasterLanguageBranchID
As it's mentioning ArchiveContent I would at a guess say this is the archiving scheduled job. Maybe try running it and seeing if the query runs when profiling the DB
We see the same issue. Have a look at this post:
Did you find a solution?