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?
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
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
tblContentLanguage ON tblContentLanguage.fkContentID=tblContent.pkID
tblContent AS tp ON tblContent.ArchiveContentGUID=tp.ContentGUID
tblContentLanguage AS tpl ON tpl.fkContentID=tp.pkID
(tblContent.ArchiveContentGUID IN (SELECT PageGUID FROM @pages)) AND