SharePoint SQL Server at 100% CPU Utilization

If this has been addressed, I apologize.  I have a situation where my SharePoint SQL server will periodically spike to 100% CPU utilization and render SharePoint unusable.  I have a four-server SharePoint 2013 on-premise farm.  When this condition happens, I am able to restart SQL Server and the problem goes away.  Today, we were able to determine the source of the issue was a long-running query that was running in over 200 simultaneous processes.  I do not recognize the query and I am wondering if someone can help me identify it or help me determine where it if coming from.  The source SQL is as follows:

SELECT

        NV.Eid,

        NV.EidParent,

        NV.ElementType,

        CASE

            WHEN

                NV.ElementType = 1 OR

                NV.NavSequence = 1

            THEN

                NV.Url

            ELSE

                CASE WHEN (DATALENGTH(D.DirName) = 0) THEN D.LeafName WHEN (DATALENGTH(D.LeafName) = 0) THEN D.DirName ELSE D.DirName + N'/' + D.LeafName END

            END + ISNULL(NV.QueryString, ''),

        NV.Name,

        NV.NodeMetainfo,

        NV.NonNavPage,

        NV.NavSequence,

        NV.ChildOfSequence,

        NV.IsDocLib,

        NV.DateLastModified,

        CASE

            WHEN

                NV.Eid = 0 OR

                NV.ElementType = 1 OR

                NV.NavSequence = 1

            THEN

                0x0

            ELSE

                D.ScopeId

            END,

        CASE

            WHEN

                NV.Eid = 0 OR

                NV.ElementType = 1 OR

                NV.NavSequence = 1

            THEN

                0

            WHEN

                D.ListId IS NULL

            THEN

                1

            WHEN

                D.DoclibRowId IS NULL

            THEN

                2

            ELSE

                3

            END,

        NV.NameResource,

        D.Type

    FROM

        TVF_NavNodes_SiteWeb(@SiteId, @WebId) AS NV

    OUTER APPLY

        TVF_Docs_NoLock_Id_Level(NV.SiteId, NV.DocId, 1) AS D

    ORDER BY

        NV.EidParent,

        NV.RankChild

    OPTION (FORCE ORDER)

Any help would be appreciated.  Thank you.