2

I am having trouble debugging why my CPU utilization occasionally reaches 100%!

The query I see which is taking time is

...
RETURN (
        SELECT TOP 1
            [xdb_refdata].[DefinitionMonikers].[ID]
        FROM
            [xdb_refdata].[DefinitionMonikers]
        INNER JOIN
            [xdb_refdata].[Definitions]
        ON
            [xdb_refdata].[Definitions].[ID] = [xdb_refdata].[DefinitionMonikers].[ID]
        WHERE
            [xdb_refdata].[DefinitionMonikers].[MonikerHash] = @hash AND
            [xdb_refdata].[DefinitionMonikers].[Moniker] = @Moniker AND
            [xdb_refdata].[Definitions].[TypeID] = @TypeID
    )
...

Can someone tell me if the above query is the one causing the issue or if it only the victim?

Also, how can I identify where the issue lies?

If I recycle the CM and XDB services the performance is back to normal.

4
  • 2
    Have you applied this patch? kb.sitecore.net/articles/595419
    – Chris Auer
    Commented Sep 21, 2020 at 12:59
  • Thanks Chris !! That seems to have fixed it ! Not having DB issues anymore Commented Sep 23, 2020 at 21:01
  • 1
    @ChrisAuer I don't want to take your points, but your answer is the correct answer and should be converted to an answer, not a comment so you can get all of those juicy points. Commented May 10, 2022 at 14:29
  • Thanks @PeteNavarra!
    – Chris Auer
    Commented May 10, 2022 at 18:47

1 Answer 1

0

You will need to apply this patch. Sitecore optimized SQL to prevent this issue.

https://support.sitecore.com/kb?id=kb_article_view&sysparm_article=KB0595419

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.