SQL session filling CPU

Roberto Castaneda 16 Reputation points
2022-03-29T20:45:39.04+00:00

I am working with MS with a ticket but wanted to see if anyone else has seen this issue. Getting a bunch of sessions....over 12 or more that make my CPU go up to 100%.

The statement text starts with this:
SELECT [PC].[S] FROM (SELECT [S].[BaseManagedEntityId] AS [S],0 AS CS,[R0].[TargetEntityId] AS [T0],1 AS CRT0,[R1].[TargetEntityId] AS [T1],2 AS CRT1,[R2].[TargetEntityId] AS [T2],3 AS CRT2,[R3].[TargetEntityId] AS [T3],4 AS CRT3,[R4].[TargetEntityId] AS [T4],5 AS CRT4,[R5].[TargetEntityId] AS [T5],6 AS CRT5,[R6].[TargetEntityId] AS [T6],7 AS CRT6,[R7].[TargetEntityId] AS [T7],8 AS CRT7,[R8].[TargetEntityId] AS [T8],9 AS CRT8,[R9].[TargetEntityId] AS [T9],10 AS CRT9,[R10].[TargetEntityId] AS [T10],11 AS

It's a very long string and it's the same info in each session.

I can restart the SDK service and it clears out the sessions but the cycle repeats.

I've tried to disable workflows to try to find the issue but wanted to see if there was something I can do to find the issue instead of restarting a service.

Service Manager
Service Manager
A family of System Center products for managing incidents and problems.
209 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,748 questions

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Roberto Castaneda 16 Reputation points
    2022-03-30T18:30:27.53+00:00
  2. Roberto Castaneda 16 Reputation points
    2022-03-30T18:34:36.207+00:00

    Here is the full statement text

  3. Roberto Castaneda 16 Reputation points
    2022-05-06T20:06:22.587+00:00

    SELECT [PC].[S]
    FROM (
    SELECT [S].[BaseManagedEntityId] AS [S]
    ,0 AS CS
    ,[R0].[TargetEntityId] AS [T0]
    ,1 AS CRT0
    ,[R1].[TargetEntityId] AS [T1]
    ,2 AS CRT1
    ,[R2].[TargetEntityId] AS [T2]
    ,3 AS CRT2
    ,[R3].[TargetEntityId] AS [T3]
    ,4 AS CRT3
    ,[R4].[TargetEntityId] AS [T4]
    ,5 AS CRT4
    ,[R5].[TargetEntityId] AS [T5]
    ,6 AS CRT5
    ,[R6].[TargetEntityId] AS [T6]
    ,7 AS CRT6
    ,[R7].[TargetEntityId] AS [T7]
    ,8 AS CRT7
    ,[R8].[TargetEntityId] AS [T8]
    ,9 AS CRT8
    ,[R9].[TargetEntityId] AS [T9]
    ,10 AS CRT9
    ,[R10].[TargetEntityId] AS [T10]
    ,11 AS CRT10
    ,[R11].[TargetEntityId] AS [T11]
    ,12 AS CRT11
    ,[R12].[SourceEntityId] AS [T12]
    ,13 AS CRT12
    ,[R13].[TargetEntityId] AS [T13]
    ,14 AS CRT13
    ,[R14].[TargetEntityId] AS [T14]
    ,15 AS CRT14
    ,[R15].[TargetEntityId] AS [T15]
    ,16 AS CRT15
    ,[R16].[TargetEntityId] AS [T16]
    ,17 AS CRT16
    ,[R17].[TargetEntityId] AS [T17]
    ,18 AS CRT17
    ,[R18].[SourceEntityId] AS [T18]
    ,19 AS CRT18
    ,[R19].[TargetEntityId] AS [T19]
    ,20 AS CRT19
    ,[R20].[TargetEntityId] AS [T20]
    ,21 AS CRT20
    ,[R21].[TargetEntityId] AS [T21]
    ,22 AS CRT21
    ,[R22].[TargetEntityId] AS [T22]
    ,23 AS CRT22
    ,[R23].[TargetEntityId] AS [T23]
    ,24 AS CRT23
    ,[R24].[TargetEntityId] AS [T24]
    ,25 AS CRT24
    ,[R25].[TargetEntityId] AS [T25]
    ,26 AS CRT25
    ,[R26].[TargetEntityId] AS [T26]
    ,27 AS CRT26
    FROM dbo.TypedManagedEntity AS S
    INNER JOIN dbo.BaseManagedEntity AS BMES ON S.[BaseManagedEntityId] = BMES.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R0
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.IncidentPrimaryOwner
    ON (
    R0.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R0.[RelationshipTypeId] = '42179172-3d24-cfc8-3944-b0a18f550214'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME0 ON R0.[TargetEntityId] = BME0.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R1
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAffectedUser
    ON (
    R1.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R1.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME1 ON R1.[TargetEntityId] = BME1.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R2
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAssignedToUser
    ON (
    R2.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R2.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME2 ON R2.[TargetEntityId] = BME2.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R3
    /SOURCE_HINT_PATTERN/ -- System.WorkItemCreatedByUser
    ON (
    R3.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R3.[RelationshipTypeId] = 'df738111-c7a2-b450-5872-c5f3b927481a'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME3 ON R3.[TargetEntityId] = BME3.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R4
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.TroubleTicketClosedByUser
    ON (
    R4.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R4.[RelationshipTypeId] = '76bc6c3b-a77b-2468-0a63-169d23dfcdf0'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME4 ON R4.[TargetEntityId] = BME4.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R5
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.TroubleTicketResolvedByUser
    ON (
    R5.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R5.[RelationshipTypeId] = 'f7d9b385-a84d-3884-7cde-e2c926d931a5'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME5 ON R5.[TargetEntityId] = BME5.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R6
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.TroubleTicketHasActionLog
    ON (
    R6.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R6.[RelationshipTypeId] = 'a860c62e-e675-b121-f614-e52fcbd9ef2c'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME6 ON R6.[TargetEntityId] = BME6.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R7
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.TroubleTicketHasUserComment
    ON (
    R7.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R7.[RelationshipTypeId] = 'ce423786-16dd-da9c-fb7b-21ab5189e12b'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME7 ON R7.[TargetEntityId] = BME7.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R8
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.TroubleTicketHasAnalystComment
    ON (
    R8.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R8.[RelationshipTypeId] = '835a64cd-7d41-10eb-e5e4-365ea2efc2ea'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME8 ON R8.[TargetEntityId] = BME8.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R9
    /SOURCE_HINT_PATTERN/ -- System.WorkItem.TroubleTicketHasNotificationLog
    ON (
    R9.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R9.[RelationshipTypeId] = '106285b2-0200-8ecb-324e-342976b16151'
    AND EXISTS (
    -- Restricted to System.WorkItem.TroubleTicket.SmtpNotificationLog
    SELECT 1
    FROM dbo.[TypedManagedEntity]
    WHERE R9.[TargetEntityId] = [BaseManagedEntityId]
    AND [ManagedTypeId] = 'b4e0d3c5-b138-5f1a-a5cd-2249c3829646'
    )
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME9 ON R9.[TargetEntityId] = BME9.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R10
    /SOURCE_HINT_PATTERN/ -- System.WorkItemContainsActivity
    ON (
    R10.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R10.[RelationshipTypeId] = '2da498be-0485-b2b2-d520-6ebd1698e61b'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME10 ON R10.[TargetEntityId] = BME10.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R11
    /SOURCE_HINT_PATTERN/ -- System.WorkItemRelatesToWorkItem
    ON (
    R11.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R11.[RelationshipTypeId] = 'cb6ce813-ea8d-094d-ee5a-b755701f4547'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME11 ON R11.[TargetEntityId] = BME11.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R12
    /TARGET_HINT_PATTERN/ -- System.WorkItemRelatesToWorkItem
    ON (
    R12.[TargetEntityId] = S.[BaseManagedEntityId]
    AND R12.[RelationshipTypeId] = 'cb6ce813-ea8d-094d-ee5a-b755701f4547'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME12 ON R12.[SourceEntityId] = BME12.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R13
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAboutConfigItem
    ON (
    R13.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R13.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME13 ON R13.[TargetEntityId] = BME13.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R14
    /SOURCE_HINT_PATTERN/ -- System.WorkItemRelatesToConfigItem
    ON (
    R14.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R14.[RelationshipTypeId] = 'd96c8b59-8554-6e77-0aa7-f51448868b43'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME14 ON R14.[TargetEntityId] = BME14.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R15
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAboutConfigItem
    ON (
    R15.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R15.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME15 ON R15.[TargetEntityId] = BME15.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R16
    /SOURCE_HINT_PATTERN/ -- System.EntityLinksToKnowledgeDocument
    ON (
    R16.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R16.[RelationshipTypeId] = 'ec8a256b-cc89-6f18-af6a-e9cdc38cc573'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME16 ON R16.[TargetEntityId] = BME16.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R17
    /SOURCE_HINT_PATTERN/ -- System.WorkItemHasFileAttachment
    ON (
    R17.[SourceEntityId] = S.[BaseManagedEntityId]
    AND R17.[RelationshipTypeId] = 'aa8c26dc-3a12-5f88-d9c7-753e5a8a55b4'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME17 ON R17.[TargetEntityId] = BME17.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R18
    /TARGET_HINT_PATTERN/ -- System.WorkItemContainsActivity
    ON (
    R18.[TargetEntityId] = R10.[TargetEntityId]
    AND R18.[RelationshipTypeId] = '2da498be-0485-b2b2-d520-6ebd1698e61b'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME18 ON R18.[SourceEntityId] = BME18.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R19
    /SOURCE_HINT_PATTERN/ -- System.WorkItemCreatedByUser
    ON (
    R19.[SourceEntityId] = R10.[TargetEntityId]
    AND R19.[RelationshipTypeId] = 'df738111-c7a2-b450-5872-c5f3b927481a'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME19 ON R19.[TargetEntityId] = BME19.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R20
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAssignedToUser
    ON (
    R20.[SourceEntityId] = R10.[TargetEntityId]
    AND R20.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME20 ON R20.[TargetEntityId] = BME20.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R21
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAboutConfigItem
    ON (
    R21.[SourceEntityId] = R10.[TargetEntityId]
    AND R21.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME21 ON R21.[TargetEntityId] = BME21.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R22
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAffectedUser
    ON (
    R22.[SourceEntityId] = R11.[TargetEntityId]
    AND R22.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME22 ON R22.[TargetEntityId] = BME22.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R23
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAssignedToUser
    ON (
    R23.[SourceEntityId] = R11.[TargetEntityId]
    AND R23.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME23 ON R23.[TargetEntityId] = BME23.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R24
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAffectedUser
    ON (
    R24.[SourceEntityId] = R12.[SourceEntityId]
    AND R24.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME24 ON R24.[TargetEntityId] = BME24.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R25
    /SOURCE_HINT_PATTERN/ -- System.WorkItemAssignedToUser
    ON (
    R25.[SourceEntityId] = R12.[SourceEntityId]
    AND R25.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME25 ON R25.[TargetEntityId] = BME25.BaseManagedEntityId
    LEFT OUTER JOIN dbo.Relationship AS R26
    /SOURCE_HINT_PATTERN/ -- System.FileAttachmentAddedByUser
    ON (
    R26.[SourceEntityId] = R17.[TargetEntityId]
    AND R26.[RelationshipTypeId] = 'ffd71f9e-7346-d12b-85d6-7c39f507b7bb'
    )
    LEFT OUTER JOIN dbo.BaseManagedEntity AS BME26 ON R26.[TargetEntityId] = BME26.BaseManagedEntityId
    WHERE (
    S.[ManagedTypeId] = 'a604b942-4c7b-2fb2-28dc-61dc6f465c68'
    AND S.[IsDeleted] = 0
    AND (
    BMES.LastModified > @Watermark
    OR BME0.LastModified > @Watermark
    OR BME1.LastModified > @Watermark
    OR BME2.LastModified > @Watermark
    OR BME3.LastModified > @Watermark
    OR BME4.LastModified > @Watermark
    OR BME5.LastModified > @Watermark
    OR BME6.LastModified > @Watermark
    OR BME7.LastModified > @Watermark
    OR BME8.LastModified > @Watermark
    OR BME9.LastModified > @Watermark
    OR BME10.LastModified > @Watermark
    OR BME11.LastModified > @Watermark
    OR BME12.LastModified > @Watermark
    OR BME13.LastModified > @Watermark
    OR BME14.LastModified > @Watermark
    OR BME15.LastModified > @Watermark
    OR BME16.LastModified > @Watermark
    OR BME17.LastModified > @Watermark
    OR BME18.LastModified > @Watermark
    OR BME19.LastModified > @Watermark
    OR BME20.LastModified > @Watermark
    OR BME21.LastModified > @Watermark
    OR BME22.LastModified > @Watermark
    OR BME23.LastModified > @Watermark
    OR BME24.LastModified > @Watermark
    OR BME25.LastModified > @Watermark
    OR BME26.LastModified > @Watermark
    )
    )
    ) AS PC
    LEFT OUTER JOIN (
    -- MTV_Select_943d298f-d79a-7a29-a335-8833e582d252
    SELECT [SourceView].[Id] AS [Id]
    ,[MTV_System$User].[BaseManagedEntityId]
    FROM (
    SELECT [BaseManagedEntityId]
    ,[DisplayName]
    ,[AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6]
    ,[BusinessPhone_DF56B912_F9E0_3565_4228_086CEABE35C2]
    ,[BusinessPhone2_0612ADE9_6913_10D9_4B12_82B2110BCBFB]
    ,[City_363F9AB4_DE91_69F0_854F_5F577324A353]
    ,[Company_8CD345AC_E9BC_E5FE_88BA_D281FC29637D]
    ,[Country_CE01FBF1_27FB_DD1E_7EE4_7E9EE3F635C8]
    ,[Department_312201FE_C1B3_E95A_01DF_E132E9BD3EC9]
    ,[Domain_E36D56F2_AD60_E76E_CD5D_9F7AB51AD395]
    ,[EmployeeId_0743124F_168A_95A0_1F99_7B26AF587F50]
    ,[Fax_60125C1D_A052_B038_3428_880837885320]
    ,[FirstName_4424C8D5_9E30_E87D_9124_1816663FAFFC]
    ,[HomePhone_FDDA48C4_C220_725E_3F2E_32658EFD53E9]
    ,[HomePhone2_F9BE9B12_1F88_D35A_2AC6_A6B1049FB80A]
    ,[Initials_5777D276_95A6_4949_1775_A2D548D9B474]
    ,[LastName_651E2AAF_6AA9_9423_9D90_4F150DB24C0D]
    ,[Mobile_3A783612_39EC_94B5_E71D_2D4C71B3C883]
    ,[Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984]
    ,[ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B]
    ,[Office_E56FF064_8BE8_C0DF_B41D_BB567F74AD7F]
    ,[Pager_E79D9580_9319_B275_9825_FD202D9C38E3]
    ,[State_07DB7E81_22E2_F883_E029_CBEF1B921EA6]
    ,[StreetAddress_C1935911_F3AB_8FF6_3DF5_76D73894C682]
    ,[Title_9FC4484D_A0D6_886A_9FB4_5C29E0172EC9]
    ,[UserName_6AF77E23_669B_123F_B392_323C17097BBD]
    ,[Zip_659D90A7_FAB7_6AF4_1B08_1D78B2A32598]
    ,[DistinguishedName_CDBAEFE6_2197_3685_EA23_CAEB31D4DDFC]
    ,[FQDN_3F0E386D_5F63_F206_46AB_DA9DBE372942]
    ,[ObjectGuid_8F760528_A519_ED48_891C_329F5CE7C62B]
    ,[OrganizationalUnit_13D8EA29_A659_92AE_C78F_8047469D8C96]
    ,[SID_2B788C53_3ACE_8BAE_3AFE_0941D0147BA4]
    ,[UPN_7641DFF7_7A20_DC04_FC1C_B6FA8715DA02]
    FROM [dbo].[MTV_System$Domain$User]
    ) AS MTV_System$User
    INNER JOIN dbo.EnterpriseManagementObjectView AS SourceView ON [MTV_System$User].[BaseManagedEntityId] = [SourceView].[Id]
    ) AS SubqueryJoin0_0 ON SubqueryJoin0_0.[BaseManagedEntityId] = [PC].[T2]
    LEFT OUTER JOIN (
    -- MTV_Select_943d298f-d79a-7a29-a335-8833e582d252
    SELECT [SourceView].[Id] AS [Id]
    ,[MTV_System$User].[BaseManagedEntityId]
    FROM (
    SELECT [BaseManagedEntityId]
    ,[DisplayName]
    ,[AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6]
    ,[BusinessPhone_DF56B912_F9E0_3565_4228_086CEABE35C2]
    ,[BusinessPhone2_0612ADE9_6913_10D9_4B12_82B2110BCBFB]
    ,[City_363F9AB4_DE91_69F0_854F_5F577324A353]
    ,[Company_8CD345AC_E9BC_E5FE_88BA_D281FC29637D]
    ,[Country_CE01FBF1_27FB_DD1E_7EE4_7E9EE3F635C8]
    ,[Department_312201FE_C1B3_E95A_01DF_E132E9BD3EC9]
    ,[Domain_E36D56F2_AD60_E76E_CD5D_9F7AB51AD395]
    ,[EmployeeId_0743124F_168A_95A0_1F99_7B26AF587F50]
    ,[Fax_60125C1D_A052_B038_3428_880837885320]
    ,[FirstName_4424C8D5_9E30_E87D_9124_1816663FAFFC]
    ,[HomePhone_FDDA48C4_C220_725E_3F2E_32658EFD53E9]
    ,[HomePhone2_F9BE9B12_1F88_D35A_2AC6_A6B1049FB80A]
    ,[Initials_5777D276_95A6_4949_1775_A2D548D9B474]
    ,[LastName_651E2AAF_6AA9_9423_9D90_4F150DB24C0D]
    ,[Mobile_3A783612_39EC_94B5_E71D_2D4C71B3C883]
    ,[Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984]
    ,[ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B]
    ,[Office_E56FF064_8BE8_C0DF_B41D_BB567F74AD7F]
    ,[Pager_E79D9580_9319_B275_9825_FD202D9C38E3]
    ,[State_07DB7E81_22E2_F883_E029_CBEF1B921EA6]
    ,[StreetAddress_C1935911_F3AB_8FF6_3DF5_76D73894C682]
    ,[Title_9FC4484D_A0D6_886A_9FB4_5C29E0172EC9]
    ,[UserName_6AF77E23_669B_123F_B392_323C17097BBD]
    ,[Zip_659D90A7_FAB7_6AF4_1B08_1D78B2A32598]
    ,[DistinguishedName_CDBAEFE6_2197_3685_EA23_CAEB31D4DDFC]
    ,[FQDN_3F0E386D_5F63_F206_46AB_DA9DBE372942]
    ,[ObjectGuid_8F760528_A519_ED48_891C_329F5CE7C62B]
    ,[OrganizationalUnit_13D8EA29_A659_92AE_C78F_8047469D8C96]
    ,[SID_2B788C53_3ACE_8BAE_3AFE_0941D0147BA4]
    ,[UPN_7641DFF7_7A20_DC04_FC1C_B6FA8715DA02]
    FROM [dbo].[MTV_System$Domain$User]
    ) AS MTV_System$User
    INNER JOIN dbo.EnterpriseManagementObjectView AS SourceView ON [MTV_System$User].[BaseManagedEntityId] = [SourceView].[Id]
    ) AS SubqueryJoin1_0 ON SubqueryJoin1_0.[BaseManagedEntityId] = [PC].[T0]
    LEFT OUTER JOIN (
    -- MTV_Select_a604b942-4c7b-2fb2-28dc-61dc6f465c68
    SELECT DISTINCT [MTV_System$WorkItem$Incident].[CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688]
    ,[MTV_System$WorkItem$Incident].[Status_785407A9_729D_3A74_A383_575DB0CD50ED]
    ,[MTV_System$WorkItem$Incident].[BaseManagedEntityId]
    FROM dbo.MTV_System$WorkItem$Incident AS MTV_System$WorkItem$Incident
    ) AS SubqueryJoin2_0 ON SubqueryJoin2_0.[BaseManagedEntityId] = [PC].[S]
    WHERE (
    (
    SubqueryJoin0_0.[Id] = @Id0
    OR SubqueryJoin1_0.[Id] = @Id1
    )
    AND (
    SubqueryJoin2_0.[Status_785407A9_729D_3A74_A383_575DB0CD50ED] = @Sta _785407A9_729D_3A74_A383_575DB0CD50ED0
    OR SubqueryJoin2_0.[Status_785407A9_729D_3A74_A383_575DB0CD50ED] = @Sta _785407A9_729D_3A74_A383_575DB0CD50ED1
    )
    )
    ORDER BY [SubqueryJoin2_0].[CreatedDate_6258638D_B885_AB3C_E316_D00782B8F688] DESC
    OPTION (KEEP PLAN) 

     SELECT [PC].[S]  
FROM (  
	SELECT [S].[BaseManagedEntityId] AS [S]  
		,0 AS CS  
		,[R0].[TargetEntityId] AS [T0]  
		,1 AS CRT0  
		,[R1].[TargetEntityId] AS [T1]  
		,2 AS CRT1  
		,[R2].[TargetEntityId] AS [T2]  
		,3 AS CRT2  
		,[R3].[TargetEntityId] AS [T3]  
		,4 AS CRT3  
		,[R4].[TargetEntityId] AS [T4]  
		,5 AS CRT4  
		,[R5].[TargetEntityId] AS [T5]  
		,6 AS CRT5  
		,[R6].[TargetEntityId] AS [T6]  
		,7 AS CRT6  
		,[R7].[TargetEntityId] AS [T7]  
		,8 AS CRT7  
		,[R8].[TargetEntityId] AS [T8]  
		,9 AS CRT8  
		,[R9].[TargetEntityId] AS [T9]  
		,10 AS CRT9  
		,[R10].[TargetEntityId] AS [T10]  
		,11 AS CRT10  
		,[R11].[TargetEntityId] AS [T11]  
		,12 AS CRT11  
		,[R12].[SourceEntityId] AS [T12]  
		,13 AS CRT12  
		,[R13].[TargetEntityId] AS [T13]  
		,14 AS CRT13  
		,[R14].[TargetEntityId] AS [T14]  
		,15 AS CRT14  
		,[R15].[TargetEntityId] AS [T15]  
		,16 AS CRT15  
		,[R16].[TargetEntityId] AS [T16]  
		,17 AS CRT16  
		,[R17].[TargetEntityId] AS [T17]  
		,18 AS CRT17  
		,[R18].[SourceEntityId] AS [T18]  
		,19 AS CRT18  
		,[R19].[TargetEntityId] AS [T19]  
		,20 AS CRT19  
		,[R20].[TargetEntityId] AS [T20]  
		,21 AS CRT20  
		,[R21].[TargetEntityId] AS [T21]  
		,22 AS CRT21  
		,[R22].[TargetEntityId] AS [T22]  
		,23 AS CRT22  
		,[R23].[TargetEntityId] AS [T23]  
		,24 AS CRT23  
		,[R24].[TargetEntityId] AS [T24]  
		,25 AS CRT24  
		,[R25].[TargetEntityId] AS [T25]  
		,26 AS CRT25  
		,[R26].[TargetEntityId] AS [T26]  
		,27 AS CRT26  
	FROM dbo.TypedManagedEntity AS S  
	INNER JOIN dbo.BaseManagedEntity AS BMES ON S.[BaseManagedEntityId] = BMES.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R0  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.IncidentPrimaryOwner        
		ON (  
			R0.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R0.[RelationshipTypeId] = '42179172-3d24-cfc8-3944-b0a18f550214'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME0 ON R0.[TargetEntityId] = BME0.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R1  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAffectedUser        
		ON (  
			R1.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R1.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME1 ON R1.[TargetEntityId] = BME1.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R2  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAssignedToUser        
		ON (  
			R2.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R2.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME2 ON R2.[TargetEntityId] = BME2.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R3  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemCreatedByUser        
		ON (  
			R3.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R3.[RelationshipTypeId] = 'df738111-c7a2-b450-5872-c5f3b927481a'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME3 ON R3.[TargetEntityId] = BME3.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R4  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.TroubleTicketClosedByUser        
		ON (  
			R4.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R4.[RelationshipTypeId] = '76bc6c3b-a77b-2468-0a63-169d23dfcdf0'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME4 ON R4.[TargetEntityId] = BME4.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R5  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.TroubleTicketResolvedByUser        
		ON (  
			R5.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R5.[RelationshipTypeId] = 'f7d9b385-a84d-3884-7cde-e2c926d931a5'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME5 ON R5.[TargetEntityId] = BME5.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R6  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.TroubleTicketHasActionLog        
		ON (  
			R6.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R6.[RelationshipTypeId] = 'a860c62e-e675-b121-f614-e52fcbd9ef2c'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME6 ON R6.[TargetEntityId] = BME6.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R7  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.TroubleTicketHasUserComment        
		ON (  
			R7.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R7.[RelationshipTypeId] = 'ce423786-16dd-da9c-fb7b-21ab5189e12b'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME7 ON R7.[TargetEntityId] = BME7.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R8  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.TroubleTicketHasAnalystComment        
		ON (  
			R8.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R8.[RelationshipTypeId] = '835a64cd-7d41-10eb-e5e4-365ea2efc2ea'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME8 ON R8.[TargetEntityId] = BME8.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R9  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItem.TroubleTicketHasNotificationLog        
		ON (  
			R9.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R9.[RelationshipTypeId] = '106285b2-0200-8ecb-324e-342976b16151'  
			AND EXISTS (  
				-- Restricted to System.WorkItem.TroubleTicket.SmtpNotificationLog           
				SELECT 1  
				FROM dbo.[TypedManagedEntity]  
				WHERE R9.[TargetEntityId] = [BaseManagedEntityId]  
					AND [ManagedTypeId] = 'b4e0d3c5-b138-5f1a-a5cd-2249c3829646'  
				)  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME9 ON R9.[TargetEntityId] = BME9.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R10  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemContainsActivity        
		ON (  
			R10.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R10.[RelationshipTypeId] = '2da498be-0485-b2b2-d520-6ebd1698e61b'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME10 ON R10.[TargetEntityId] = BME10.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R11  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemRelatesToWorkItem        
		ON (  
			R11.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R11.[RelationshipTypeId] = 'cb6ce813-ea8d-094d-ee5a-b755701f4547'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME11 ON R11.[TargetEntityId] = BME11.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R12  
		/*TARGET_HINT_PATTERN*/ -- System.WorkItemRelatesToWorkItem        
		ON (  
			R12.[TargetEntityId] = S.[BaseManagedEntityId]  
			AND R12.[RelationshipTypeId] = 'cb6ce813-ea8d-094d-ee5a-b755701f4547'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME12 ON R12.[SourceEntityId] = BME12.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R13  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAboutConfigItem        
		ON (  
			R13.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R13.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME13 ON R13.[TargetEntityId] = BME13.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R14  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemRelatesToConfigItem        
		ON (  
			R14.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R14.[RelationshipTypeId] = 'd96c8b59-8554-6e77-0aa7-f51448868b43'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME14 ON R14.[TargetEntityId] = BME14.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R15  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAboutConfigItem        
		ON (  
			R15.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R15.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME15 ON R15.[TargetEntityId] = BME15.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R16  
		/*SOURCE_HINT_PATTERN*/ -- System.EntityLinksToKnowledgeDocument        
		ON (  
			R16.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R16.[RelationshipTypeId] = 'ec8a256b-cc89-6f18-af6a-e9cdc38cc573'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME16 ON R16.[TargetEntityId] = BME16.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R17  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemHasFileAttachment        
		ON (  
			R17.[SourceEntityId] = S.[BaseManagedEntityId]  
			AND R17.[RelationshipTypeId] = 'aa8c26dc-3a12-5f88-d9c7-753e5a8a55b4'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME17 ON R17.[TargetEntityId] = BME17.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R18  
		/*TARGET_HINT_PATTERN*/ -- System.WorkItemContainsActivity        
		ON (  
			R18.[TargetEntityId] = R10.[TargetEntityId]  
			AND R18.[RelationshipTypeId] = '2da498be-0485-b2b2-d520-6ebd1698e61b'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME18 ON R18.[SourceEntityId] = BME18.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R19  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemCreatedByUser        
		ON (  
			R19.[SourceEntityId] = R10.[TargetEntityId]  
			AND R19.[RelationshipTypeId] = 'df738111-c7a2-b450-5872-c5f3b927481a'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME19 ON R19.[TargetEntityId] = BME19.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R20  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAssignedToUser        
		ON (  
			R20.[SourceEntityId] = R10.[TargetEntityId]  
			AND R20.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME20 ON R20.[TargetEntityId] = BME20.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R21  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAboutConfigItem        
		ON (  
			R21.[SourceEntityId] = R10.[TargetEntityId]  
			AND R21.[RelationshipTypeId] = 'b73a6094-c64c-b0ff-9706-1822df5c2e82'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME21 ON R21.[TargetEntityId] = BME21.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R22  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAffectedUser        
		ON (  
			R22.[SourceEntityId] = R11.[TargetEntityId]  
			AND R22.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME22 ON R22.[TargetEntityId] = BME22.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R23  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAssignedToUser        
		ON (  
			R23.[SourceEntityId] = R11.[TargetEntityId]  
			AND R23.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME23 ON R23.[TargetEntityId] = BME23.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R24  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAffectedUser        
		ON (  
			R24.[SourceEntityId] = R12.[SourceEntityId]  
			AND R24.[RelationshipTypeId] = 'dff9be66-38b0-b6d6-6144-a412a3ebd4ce'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME24 ON R24.[TargetEntityId] = BME24.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R25  
		/*SOURCE_HINT_PATTERN*/ -- System.WorkItemAssignedToUser        
		ON (  
			R25.[SourceEntityId] = R12.[SourceEntityId]  
			AND R25.[RelationshipTypeId] = '15e577a3-6bf9-6713-4eac-ba5a5b7c4722'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME25 ON R25.[TargetEntityId] = BME25.BaseManagedEntityId  
	LEFT OUTER JOIN dbo.Relationship AS R26  
		/*SOURCE_HINT_PATTERN*/ -- System.FileAttachmentAddedByUser        
		ON (  
			R26.[SourceEntityId] = R17.[TargetEntityId]  
			AND R26.[RelationshipTypeId] = 'ffd71f9e-7346-d12b-85d6-7c39f507b7bb'  
			)  
	LEFT OUTER JOIN dbo.BaseManagedEntity AS BME26 ON R26.[TargetEntityId] = BME26.BaseManagedEntityId  
	WHERE (  
			S.[ManagedTypeId] = 'a604b942-4c7b-2fb2-28dc-61dc6f465c68'  
			AND S.[IsDeleted] = 0  
			AND (  
				BMES.LastModified > @Watermark  
				OR BME0.LastModified > @Watermark  
				OR BME1.LastModified > @Watermark  
				OR BME2.LastModified > @Watermark  
				OR BME3.LastModified > @Watermark  
				OR BME4.LastModified > @Watermark  
				OR BME5.LastModified > @Watermark  
				OR BME6.LastModified > @Watermark  
				OR BME7.LastModified > @Watermark  
				OR BME8.LastModified > @Watermark  
				OR BME9.LastModified > @Watermark  
				OR BME10.LastModified > @Watermark  
				OR BME11.LastModified > @Watermark  
				OR BME12.LastModified > @Watermark  
				OR BME13.LastModified > @Watermark  
				OR BME14.LastModified > @Watermark  
				OR BME15.LastModified > @Watermark  
				OR BME16.LastModified > @Watermark  
				OR BME17.LastModified > @Watermark  
				OR BME18.LastModified > @Watermark  
				OR BME19.LastModified > @Watermark  
				OR BME20.LastModified > @Watermark  
				OR BME21.LastModified > @Watermark  
				OR BME22.LastModified > @Watermark  
				OR BME23.LastModified > @Watermark  
				OR BME24.LastModified > @Watermark  
				OR BME25.LastModified > @Watermark  
				OR BME26.LastModified > @Watermark  
				)  
			)  
	) AS PC  
LEFT OUTER JOIN (  
	-- MTV_Select_943d298f-d79a-7a29-a335-8833e582d252      
	SELECT [SourceView].[Id] AS [Id]  
		,[MTV_System$User].[BaseManagedEntityId]  
	FROM (  
		SELECT [BaseManagedEntityId]  
			,[DisplayName]  
			,[AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6]  
			,[BusinessPhone_DF56B912_F9E0_3565_4228_086CEABE35C2]  
			,[BusinessPhone2_0612ADE9_6913_10D9_4B12_82B2110BCBFB]  
			,[City_363F9AB4_DE91_69F0_854F_5F577324A353]  
			,[Company_8CD345AC_E9BC_E5FE_88BA_D281FC29637D]  
			,[Country_CE01FBF1_27FB_DD1E_7EE4_7E9EE3F635C8]
  4. Roberto Castaneda 16 Reputation points
    2022-05-09T15:23:03.673+00:00

    Just need to find what is causing it though. Hope someone can help with that.

    0 comments
  5. Roberto Castaneda 16 Reputation points
    2022-05-09T16:33:24.47+00:00

    Not sure what tool that might have created that query. We don't edit Service Manager much.

    0 comments