Try our conversational search powered by Generative AI!

When and where this query gets executed

Vote:
 

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

#257003
Jun 23, 2021 21:21
Vote:
 

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

#257045
Jun 24, 2021 7:59
Vote:
 
#267605
Nov 30, 2021 17:08
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.