AI OnAI Off
When and where this query gets executed
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
Jun 24, 2021 7:59
Hi!
We see the same issue. Have a look at this post:
Did you find a solution?
Nov 30, 2021 17:08
Hi Team,
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