DBQueue callers
SQL modules with source-derived calls to QBM_PDBQueueInsert*. This is static source evidence, not live queue activity.
640callersSQL modules
6insert routinesQBM_PDBQueueInsert*
494bulk callersBulk
160single callersSingle
Insert routine usage
| Routine | Callers | Task refs | Example callers |
|---|---|---|---|
| QBM_PDBQueueInsert_Bulk | 494 | 978 | dbo.QER_PITShopHelperFill_bulk dbo.QBM_PJobUpdateState_Bulk dbo.ADS_TUAdsGroup dbo.QER_TUPersonWantsOrg |
| QBM_PDBQueueInsert_Single | 160 | 330 | dbo.ADS_TUAdsGroup dbo.QER_TUBaseTree dbo.ATT_PAttestationHelperFill dbo.QER_ZAllForPersonInBaseTree |
| QBM_PDBQueueInsert_bulk | 14 | 19 | dbo.QBM_TUDialogConfigParm dbo.QER_TUPWODecisionRuleRulerDete dbo.QER_TIPWODecisionRuleRulerDete dbo.QBM_ZStateUTCOffset |
| QBM_PDBQueueInsert_WaitForComp | 10 | 21 | dbo.QBM_ZPrePropTable dbo.QBM_ZPrePropColumn dbo.QBM_ZPrePropTree dbo.QBM_ZPrePropObject |
| QBM_PDBQueueInsert_single | 5 | 5 | dbo.QER_ZOrgInherite dbo.QBM_TUDialogMultiLanguage dbo.QBM_TIDialogMultiLanguage dbo.QBM_TDDialogMultiLanguage |
| QBM_PDBQueueInsert_Int | 3 | 0 | dbo.QBM_PDBQueueInsert_Bulk dbo.QBM_P40B0C8AE71E45BA9C883A96_ dbo.QBM_P1B7262FC192C886D0EB9F74_ |
Top task markers among callers
Caller modules
| Module | Type | Insert call | Task markers | Task count | DML targets | Complexity |
|---|---|---|---|---|---|---|
| dbo.QER_TUBaseTree calls QBM_PDBQueueInsert_Bulk, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE node; reads/joins inserted, deleted, BaseTree, PersonWantsOrg, DynamicG | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QER-K-ITSHOPOrder-RESET, QER-K-ITSHOPOrder-ABORT, QER-K-PersonCheckDynUser, QER-K-HelperHeadOrg, QBM-K-CommonReCalculate | 15 | 3 | 252.619 |
| dbo.QER_PAfterMigrationTasks calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE PWODecisionSubMethod; reads/joins OrgRoot, BaseTree, BaseTreeHasPWODecisionMethod, AccProduct, accproduct… | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QER-K-OrgROOT, QER-K-OrgTreeLEVEL, QER-K-BaseTreeCollectionF, QER-K-ShoppingRackMethod, QER-K-ShoppingRackProductNode | 13 | 2 | 155.764 |
| dbo.QBM_ZPrePropTable calls QBM_PDBQueueInsert_WaitForComp, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PJournal, QBM_PJobCreate_SendMail…; writes INSERT into, UPDATE DialogTable, UPDATE DialogColumn; reads/joins QBMDBQueueCurrent, d | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_WaitForComp, QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropTable, QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropTree, QBM-K-CommonPrepropTreeResult | 9 | 3 | 203.719 |
| dbo.QER_ZAllForPersonInBaseTree calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOCallMethod, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QERDynamicGroupBlackList; reads/joins QBMDBQueueCurren | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-Commonrecalculate, QER-K-ShoppingRackPWOHelperPWO, QER-K-PersonCheckDynUser, QER-K-AllForOnePerson, QER-K-PersonHasObject | 8 | 2 | 216.715 |
| dbo.QER_TUPerson calls QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOCallMethod_L, QBM_PDBQueueInsert_Bulk, QBM_PJournal, QER_PITShopHelperFill_Recalc…; writes INSERT into, UPDATE not; reads/joins inserted, deleted, QER_VPersonsAreMe, QERU | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-CommonReCalculate, QER-K-HelperHeadPerson, QER-K-PersonHasObject, QER-K-DynamicGroupSingleBasic, QER-K-AllForOnePerson | 8 | 2 | 198.058 |
| dbo.ADS_TIBaseTreeHasADSGroup calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, ADSGroup, personinBaseTree, helperPersonOrg…; uses config TargetSystem\ADS\H | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-OrgHasADSGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup | 7 | 2 | 123.865 |
| dbo.ADS_TUBaseTreeHasADSGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasADSGroup, BaseTree, PersoninBaseTree…; uses config TargetSystem\ADS\HardwareInGroupFromOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-BaseTreeHasObject, ADS-K-OrgHasADSGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, ADS-K-ADSAccountInADSGroup | 7 | 2 | 113.573 |
| dbo.QBM_TIAssembly_DialogTable calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, dialogtable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonRebuildView, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger, QBM-K-CommonRebuildViewR | 7 | 2 | 79.266 |
| dbo.QBM_TIDialogGroup calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QBM-K-CommonGroupNumber, QBM-K-CommonGroupCollection, QBM-K-CommonPrepropGroup, QBM-K-CommonReCalculate, QBM-K-CommonGroupPattern | 7 | 2 | 76.189 |
| dbo.QBM_PDBQueueInsert_Int calls QBM_PSessionContextSet, QBM_PJournal, QBM_PSessionErrorAdd, QBM_PDBQueueInsert_Single; writes INSERT into, INSERT DialogDBQueue, UPDATE DialogDatabase; reads/joins QBMDBQueueTaskMetric, QBMDBQueueTask, DialogDBQueu | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-BaseMigrationReady, QBM-K-CommonReCalculate, QBM-K-XMarkedForDeletionPush, QBM-K-XDateSubItemUpdate, QBM-K-XDateSubItemUpdateFU | 6 | 3 | 159.795 |
| dbo.QBM_PTableReload calls QBM_PFunctionDrop, QBM_PViewDrop, QBM_PTriggerDrop, QBM_PConstraintFKDrop, sp_rename…; writes INSERT into; reads/joins sys, QBM_VTablesReloadAble, QBM_VHeavyLoadTables, DialogDatabase, QBM_VStartupTables… | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, QBM-K-MakeConstraint, QBM-K-CommonMakeRITrigger, QBM-K-CommonMakeWatchtrigger, QBM-K-SetRowLockOnly | 6 | 1 | 158.903 |
| dbo.TSB_TUDPRNameSpace calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DPRNameSpace, UNSRootB, UNSAccountB… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3, TSB-K-UNSAccountBHasUNSItemB | 6 | 2 | 125.172 |
| dbo.RMS_TIBaseTreeHasESet calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, ESet, personinBaseTree, helperPersonOrg… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-OrgHasESet, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, RMS-K-BaseTreeHasObject, RMS-K-PersonHasESet | 6 | 2 | 118.553 |
| dbo.LDP_TIBaseTreeHasLDAPGroup calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, LDAPGroup, BaseTree, personinBaseTree, helperPersonOrg…; uses config TargetSystem\LDAP | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | LDP-K-OrgHasLDAPGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, LDP-K-BaseTreeHasObject, LDP-K-LDAPAccountInLDAPGroup | 6 | 2 | 114.553 |
| dbo.LDP_TUBaseTreeHasLDAPGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasLDAPGroup, BaseTree, PersoninBaseTree…; uses config TargetSystem\LDAP\HardwareInGroupFromOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | LDP-K-BaseTreeHasObject, LDP-K-OrgHasLDAPGroup, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, LDP-K-LDAPAccountInLDAPGroup | 6 | 2 | 103.954 |
| dbo.QBM_ZBufferTProcessDelete calls QBM_PJournal, QBM_PDBQCS_CurrentRestore, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into; reads/joins DialogDBQueue, QBMDBQueueCurrent | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-BufferTProcessModulePU, QBM-K-BufferTProcessModule, QBM-K-BufferTProcessTablePU, QBM-K-BufferTProcessTable, QBM-K-BufferTProcessDelete | 6 | 1 | 96.721 |
| dbo.QBM_TUAssembly_DialogTable calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogTable, dialogtable, dialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonRebuildView, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonReCalculate, QBM-K-CommonRebuildViewR | 6 | 2 | 82.068 |
| dbo.QER_PITShopHelperFill_bulk calls as, QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QER_P04F128DC257D2B3C236MAIL_, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWODecisionHistory, INSERT PWOHelperPWO, UPDATE PersonWantsOrg, UPDATE PWOHelperP | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-ShoppingRackCheckDecision, CPL-K-ShoppingRackMakeDecisionOC, CPL-K-ShoppingRackMakeDecisionOH, QER-K-ShoppingRackMakeDecisionEX | 5 | 6 | 340.779 |
| dbo.RMS_ZESetCollection calls QBM_PDBQueueCalculateDelta, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT ESetCollection, DELETE ESetCollection; reads/joins QBMDBQueueCurrent, ESetCollection, ES | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | RMS-K-ESetCollection, RMS-K-ESetHasEntitlement, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet | 5 | 3 | 157.123 |
| dbo.QBM_PWorkSchedule calls QBM_PDBQueueAgentInfoSet, QBM_PTransactionLevelCheck, QBM_PSessionContextSet, QBM_PScheduleCheck, QBM_PDBQueueInsert_Single…; writes UPDATE DialogDatabase; reads/joins sys, DialogDatabase, QBMDBQueueCurrent, QBMGui | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-TableReload, QBM-K-TableReplace, QBM-K-GUIDReplaceReady, QBM-K-Commonrecalculate, QBM-K-DeferredOperationExecute | 5 | 1 | 122.734 |
| dbo.QBM_TUDialogColumn calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE dialogcolumn, DELETE QBMSplittedLookup; reads/joins inserted, deleted, dialogColumn, dialogtable, dialo | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropTable, QBM-K-SplittedLookupFill, QBM-K-MissingDisplayRightFill, QBM-K-IndexCreateGenerated | 5 | 4 | 114.725 |
| dbo.QER_TIBaseTree calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT BaseTreeCollectionF, INSERT node, INSERT BaseTreecollection; reads/joins inserted, DialogGroup, BaseTreeCollectionF, BaseTree, O | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgTreeLEVEL, QER-K-OrgInherite, QER-K-BaseTreeCollectionF, QER-K-AllForOneOrg, QER-K-HelperHeadOrg | 5 | 5 | 108.632 |
| dbo.RMS_TUBaseTreeHasESet calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasESet, BaseTreecollection, BaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-BaseTreeHasObject, RMS-K-OrgHasESet, QER-K-OrgAutoChild, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet | 5 | 2 | 107.535 |
| dbo.RPS_TIBaseTreeHasRPSReport calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, RPSReport, BaseTree, personinBaseTree, helperPersonOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RPS-K-OrgHasRPSReport, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, RPS-K-BaseTreeHasObject, RPS-K-PersonHasRPSReport | 5 | 2 | 88.218 |
| dbo.TSB_TIBaseTreeHasUNSGroupB1 calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, UNSGroupB1, personinBaseTree, helperPersonOrg… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-OrgHasUNSGroupB1, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-BaseTreeHasObject | 5 | 2 | 87.901 |
| dbo.TSB_TIBaseTreeHasUNSGroupB2 calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, UNSGroupB2, personinBaseTree, helperPersonOrg… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-OrgHasUNSGroupB2, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-BaseTreeHasObject | 5 | 2 | 87.901 |
| dbo.TSB_TIBaseTreeHasUNSGroupB3 calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, UNSGroupB3, personinBaseTree, helperPersonOrg… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-OrgHasUNSGroupB3, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB3, TSB-K-BaseTreeHasObject | 5 | 2 | 87.901 |
| dbo.TSB_TIBaseTreeHasUNSGroupB calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, UNSGroupB, personinBaseTree, helperPersonOrg… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-OrgHasUNSGroupB, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB, TSB-K-BaseTreeHasObject | 5 | 2 | 87.892 |
| dbo.TSB_TUUNSAccountB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountB, UNSRootB | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-PersonHasObject, TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3 | 5 | 2 | 85.865 |
| dbo.TSB_TIBaseTreeHasTSBAccountDef calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, TSBAccountDef, personinBaseTree, helperPersonOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-OrgHasTSBAccountDef, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-BaseTreeHasObject, TSB-K-PersonHasTSBAccountDef | 5 | 2 | 85.816 |
| dbo.QER_TIBaseTreeHasQERResource calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, QERResource, personinBaseTree, helperPersonOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgHasQERResource, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-BaseTreeHasObject, QER-K-PersonHasQERResource | 5 | 2 | 85.8 |
| dbo.QER_TIBaseTreeHasQERReuseUS calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, QERReuseUS, personinBaseTree, helperPersonOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgHasQERReuseUS, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-BaseTreeHasObject, QER-K-PersonHasQERReuseUS | 5 | 2 | 85.792 |
| dbo.QER_TIBaseTreeHasQERAssign calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, QERAssign, personinBaseTree, helperPersonOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgHasQERAssign, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-BaseTreeHasObject, QER-K-PersonHasQERAssign | 5 | 2 | 85.784 |
| dbo.QER_TIBaseTreeHasQERReuse calls QER_PAssignmentCheckValid, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, QERReuse, personinBaseTree, helperPersonOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgHasQERReuse, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-BaseTreeHasObject, QER-K-PersonHasQERReuse | 5 | 2 | 85.776 |
| dbo.TSB_TUBaseTreeHasUNSGroupB1 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasUNSGroupB1, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-BaseTreeHasObject, TSB-K-OrgHasUNSGroupB1, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB1 | 5 | 2 | 79.661 |
| dbo.TSB_TUBaseTreeHasUNSGroupB2 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasUNSGroupB2, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-BaseTreeHasObject, TSB-K-OrgHasUNSGroupB2, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB2 | 5 | 2 | 79.661 |
| dbo.TSB_TUBaseTreeHasUNSGroupB3 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasUNSGroupB3, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-BaseTreeHasObject, TSB-K-OrgHasUNSGroupB3, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB3 | 5 | 2 | 79.661 |
| dbo.TSB_TUBaseTreeHasUNSGroupB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasUNSGroupB, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-BaseTreeHasObject, TSB-K-OrgHasUNSGroupB, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-UNSAccountBInUNSGroupB | 5 | 2 | 79.653 |
| dbo.QER_TUBaseTreeHasQERReuseUS calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasQERReuseUS, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-BaseTreeHasObject, QER-K-OrgHasQERReuseUS, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-PersonHasQERReuseUS | 5 | 2 | 79.651 |
| dbo.TSB_TUBaseTreeHasTSBAccountDef calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasTSBAccountDef, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-BaseTreeHasObject, TSB-K-OrgHasTSBAccountDef, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, TSB-K-PERSONHASTSBAccountDef | 5 | 2 | 77.484 |
| dbo.RPS_TUBaseTreeHasRPSReport calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasRPSReport, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RPS-K-BaseTreeHasObject, RPS-K-OrgHasRPSReport, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, RPS-K-PersonHasRPSReport | 5 | 2 | 77.459 |
| dbo.QER_TUBaseTreeHasQERResource calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasQERResource, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgHasQERResource, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-BaseTreeHasObject, QER-K-PersonHasQERResource | 5 | 2 | 77.222 |
| dbo.QER_TUBaseTreeHasQERAssign calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins deleted, inserted, BaseTreeHasQERAssign, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-OrgHasQERAssign, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-BaseTreeHasObject, QER-K-PersonHasQERAssign | 5 | 2 | 77.211 |
| dbo.QER_TUBaseTreeHasQERReuse calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, BaseTreeHasQERReuse, BaseTree, PersoninBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-BaseTreeHasObject, QER-K-OrgHasQERReuse, QER-K-AllChildrenOfOrg, QER-K-OrgAutoChild, QER-K-PersonHasQERReuse | 5 | 2 | 77.203 |
| dbo.TSB_TIUNSAccountB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSRootB | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-PersonHasObject, TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3 | 5 | 2 | 67.238 |
| dbo.QBM_TDAssembly_DialogColumn calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, DialogTable, dialogtable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonRebuildView, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger, QBM-K-CommonMakeRITriggerPre | 5 | 2 | 67.15 |
| dbo.QBM_TIAssembly_QBMRelation calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, DialogColumn, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonMakeRITriggerPre, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonPrepropTable, QBM-K-CommonMakeRITrigger | 5 | 2 | 64.337 |
| dbo.QBM_TDAssembly_DialogTable calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonRebuildViewR, QBM-K-CommonRebuildViewU, QBM-K-CommonRebuildView, QBM-K-CommonMakeWatchtrigger | 5 | 2 | 62.699 |
| dbo.ADS_TUAdsGroup calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk…; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE BaseTreeHasADSGrou | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-CommonReCalculate, ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup | 4 | 11 | 257.541 |
| dbo.QER_TUPersonWantsOrg calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_SQLDel_L, QBM_PJobCreate_SQLDel_B, QER_PITShopOrderResetOneLevel, QBM_PJobCreate_HOCallMethod_L…; writes INSERT into, UPDATE not, UPDATE PersonWantsOrg, DELETE PWOHelperPWO; | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-ShoppingRackCheckWaiting, QER-K-ITShopRepairClosed, QER-K-ShoppingRackCheckDecision | 4 | 4 | 252.836 |
| dbo.RMS_TUESet calls QER_PIsForITShopFlagCheck, QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, del | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-ESetCollection, RMS-K-OrgHasESet, RMS-K-PersonHasESet, RMS-K-WorkdeskHasESet | 4 | 2 | 155.504 |
| dbo.ATT_TUAttestationCase calls QBM_PDBQueueInsert_Bulk, ATT_PAttestationResetOneLevel, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE AttestationHelper, DELETE AttestationHelper; reads/joins inserted, deleted, AttestationCase, Atte | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ATT-K-AttestationHelper, ATT-K-AttestationReminder, ATT-K-AttestationHelperNewLevel, ATT-K-AttestationCheckValid | 4 | 4 | 107.815 |
| dbo.QBM_ZPreProptableFK calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogTable, UPDATE DialogColumn; reads/joins QBMDBQueueCurrent, dialogTable, dialogcolumn, DialogTable, dialogtable | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropTableFK, QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropObject | 4 | 3 | 107.421 |
| dbo.QER_TDBaseTree calls QBM_PDBQueueInsert_Bulk, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, QERAssign, PersonWantsOrg, BaseTree, PersonInBaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ITSHOPOrder-ABORT, QER-K-OrgInherite, QER-K-OrgTreeLEVEL, QER-K-HelperHeadOrg | 4 | 2 | 102.803 |
| dbo.QBM_ZConstraintEnable calls QBM_PDBQCS_CurrentMoveSlot, QBM_PJournal, QBM_PSessionErrorClean, QBM_PTriggerEnable, QBM_PConstraintEnable…; writes INSERT into; reads/joins QBMDBQueueCurrent, DialogDBQueue, sys | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-QBMConstraintEnable, QBM-K-QBMConstraintDisable, QBM-K-QBMConstraintEnable2, QBM-K-QBMConstraintDisable2 | 4 | 1 | 101.861 |
| dbo.CPL_TUComplianceRule calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE PersonInBaseTree; reads/joins inserted, deleted, ComplianceSubrule, ComplianceRule, PersonInBaseTree | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | CPL-K-ComplianceSubRuleFillPerson, CPL-K-ComplianceSubRuleFillObject, CPL-K-ComplianceCheckMakeProc, CPL-K-ComplianceCheckForRule | 4 | 3 | 101.7 |
| dbo.TSB_TUTSBSpecificGroupBehavior calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, TSBSpecificGroupBehavior, UNSGroupB, UNSAccountBInUNSGroupB… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3 | 4 | 2 | 100.188 |
| dbo.QBM_ZPrePropColumn calls QBM_PDBQueueInsert_WaitForComp, QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogColumn; reads/joins QBMDBQueueCurrent, dialogcolumn, dialogtable, QBM_VQBMRela | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_WaitForComp, QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropColumn, QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropTableFK, QBM-K-CommonRebuildView | 4 | 2 | 98.089 |
| dbo.TSB_TITSBSpecificGroupBehavior calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSGroupB, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB, UNSGroupB1… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3 | 4 | 2 | 93.274 |
| dbo.TSB_TDTSBSpecificGroupBehavior calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, UNSGroupB, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB, UNSGroupB1… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3 | 4 | 2 | 93.272 |
| dbo.QER_TIPerson calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOFireEvent_L, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT HelperHeadPerson, UPDATE Person; reads/joins inserted, QERUniversalSubstitute, Person, HelperHeadP | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasObject, QER-K-HelperHeadPerson, QER-K-AllForOnePerson, QER-K-HelperPersonOrg | 4 | 4 | 91.832 |
| dbo.ADS_TIADSGroupExclusion calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, ADSGroup, ADSGroupCollection, ADSAccountInADSGroup, ADSContactInADSGroup…; uses conf | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-OrgHasADSGroup | 4 | 2 | 91.411 |
| dbo.RMS_TIESetExcludesESet calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, PersonHasEset, BaseTreeHasEset, WorkDeskHasESet, ESetHasEntitlement…; uses config QE | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-PersonHasESet, RMS-K-OrgHasESet, RMS-K-WorkdeskHasESet, RMS-K-ESetHasEntitlement | 4 | 2 | 88.831 |
| dbo.QBM_TIDialogColumn calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, UPDATE dialogcolumn; reads/joins inserted, dialogcolumn, DialogTable, information_schema, QBM_VQBMRelationALL | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropColumn, QBM-K-SplittedLookupFill, QBM-K-MissingDisplayRightFill, QBM-K-IndexCreateGenerated | 4 | 3 | 83.884 |
| dbo.QBM_ZGroupNumber calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE dialogGroup; reads/joins DialogGroup, dialoggroup, dialogGroup; uses session context GenProcID | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-CommonPrepropGroup, QBM-K-CommonGroupCollection, QBM-K-CommonGroupPattern, QBM-K-CommonReCalculate | 4 | 1 | 72.23 |
| dbo.TSB_TUTSBBehavior calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, TSBBehavior, UNSAccountB, UNSRootB | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBInUNSGroupB3 | 4 | 2 | 68.927 |
| dbo.ADS_TDADSGroupExclusion calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, ADSGroupCollection, ADSAccountInADSGroup, ADSContactInADSGroup, ADSMachineInADSGroup… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup, ADS-K-OrgHasADSGroup | 4 | 2 | 68.473 |
| dbo.RMS_TDESetExcludesESet calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, PersonHasEset, BaseTreeHasEset, WorkDeskHasESet, ESetHasEntitlement… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-PersonHasESet, RMS-K-OrgHasESet, RMS-K-WorkdeskHasESet, RMS-K-ESetHasEntitlement | 4 | 2 | 68.316 |
| dbo.QBM_TIAssembly_DialogColumn calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, dialogtable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonRebuildView, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger | 4 | 2 | 61.972 |
| dbo.QBM_TDAssembly_QBMRelation calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, DialogColumn, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonMakeRITriggerPre, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger | 4 | 2 | 61.659 |
| dbo.QBM_ZViewBuildAll calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, DialogTable | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QBM-K-CommonRebuildViewV, QBM-K-CommonRebuildViewP, QBM-K-CommonRebuildViewU, QBM-K-CommonRebuildViewR | 4 | 1 | 57.122 |
| dbo.CPL_PAfterMigrationTasks calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMModuleDef, ComplianceRule, ComplianceSubRule | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | CPL-K-ComplianceSubRuleFillPerson, CPL-K-ComplianceCheckForRule, QBM-K-CommonReCalculate, CPL-K-ComplianceSubRuleFillObject | 4 | 1 | 56.61 |
| dbo.QBM_TDDialogGroup calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes DELETE not; reads/joins deleted | SQL_TRIGGER | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, QBM-K-CommonGroupNumber, QBM-K-CommonGroupPattern, QBM-K-CommonGroupCollection | 4 | 1 | 43.666 |
| dbo.QER_TUOrgRootAssign calls QBM_PExecuteSQLWithRetry_LLP, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, OrgRootAssign, BaseTreeAssign, DialogTable… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-AllForOnePerson, QER-K-AllForOneWorkdesk, QER-K-AllForOneHardware | 3 | 2 | 122.345 |
| dbo.TSB_TUTSBAccountDef calls QER_PIsForITShopFlagCheck, QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, del | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-TSBAccountDefFlags, TSB-K-PersonHasTSBAccountDef, TSB-K-OrgHasTSBAccountDef | 3 | 2 | 121.322 |
| dbo.QER_TUDynamicGroup calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PExecuteSQLMulti, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DynamicGroup, BaseTree, Dialog | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QER-K-DynamicGroupMakeProc, QER-K-DynamicGroupTest, QER-K-DynamicGroupMakeTrigger | 3 | 2 | 102.115 |
| dbo.ATT_TUAttestationPolicy calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, AttestationObject, DialogTable, AttestationPolicy | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ATT-K-Attestation-RESET, ATT-K-Attestation-ABORT, ATT-K-HelperAttestationPolicy | 3 | 2 | 96.831 |
| dbo.QBM_ZRecalculate calls QBM_PJournal, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueTask, QBMDBQueueTaskMetric, DialogDBQueue | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-All, QBM-K-BaseMigrationReady, QBM-K-CommonReCalculate | 3 | 1 | 94.9 |
| dbo.QER_TIDynamicGroup calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTree, DialogTable, orgrootassign, BaseTreeAssign…; uses s | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QER-K-DynamicGroupMakeProc, QER-K-DynamicGroupTest, QER-K-DynamicGroupMakeTrigger | 3 | 2 | 93.303 |
| dbo.QBM_TUDialogTable calls QBM_PSQLCheckExecutable, QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PGUIDReplaceCustomizerFill, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogTable, QBM_VStar | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropTable, QBM-K-CommonMakeWatchtrigger, QBM-K-MissingDisplayRightFill | 3 | 2 | 93.069 |
| dbo.QBM_TIDialogTable calls QBM_PPrePropCheckSyntax, QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PGUIDReplaceCustomizerFill, QBM_PDBQueueInsert_Single…; writes INSERT not, INSERT trigger, INSERT into; reads/joins inserted, DialogTab | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QBM-K-CommonPrepropTable, QBM-K-TableRevisionFill, QBM-K-MissingDisplayRightFill | 3 | 3 | 88.793 |
| dbo.ATT_ZAllForPersonInBaseTree calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, QERWorkingStep, AttestationHelper, AccProduct, AccProductGr | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-Commonrecalculate, ATT-K-AttestationHelper, ATT-K-AttestationHelper-Cfg | 3 | 1 | 88.403 |
| dbo.TSB_TUUNSAccountBInUNSGroupB1 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBInUNSGroupB1, UNSGroupB1, UNSAccountB…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesA | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB1, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 84.997 |
| dbo.TSB_TUUNSAccountBInUNSGroupB2 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBInUNSGroupB2, UNSGroupB2, UNSAccountB…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesA | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB2, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 84.997 |
| dbo.TSB_TUUNSAccountBInUNSGroupB3 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBInUNSGroupB3, UNSGroupB3, UNSAccountB…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesA | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB3, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 84.997 |
| dbo.TSB_TUUNSAccountBInUNSGroupB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBInUNSGroupB, UNSGroupB, UNSAccountB…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAcc | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 84.984 |
| dbo.TSB_TIUNSAccountBInUNSGroupB1 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB1, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; us | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 84.276 |
| dbo.TSB_TIUNSAccountBInUNSGroupB2 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB2, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; us | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 84.276 |
| dbo.TSB_TIUNSAccountBInUNSGroupB3 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB3, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; us | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB3, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 84.276 |
| dbo.TSB_TIUNSAccountBInUNSGroupB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; use | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 84.262 |
| dbo.QBM_TUDialogDatabase calls QBM_PDBQueueInsert_Single, QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE not, UPDATE DialogConfigParm, UPDATE in; reads/joins inserted, deleted, DialogDatabase; uses config QBM\DBQueue\CountSlotsMax, | SQL_TRIGGER | QBM_PDBQueueInsert_Single | QBM-K-GetServerProperties, QBM-K-CommonWaitForCompiler, QBM-K-BaseMigrationReady | 3 | 3 | 83.458 |
| dbo.TSB_TIUNSAccountBHasUNSGroupB1 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB1, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; us | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB1, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 81.924 |
| dbo.TSB_TIUNSAccountBHasUNSGroupB2 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB2, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; us | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB2, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 81.924 |
| dbo.TSB_TIUNSAccountBHasUNSGroupB3 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB3, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; us | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB3, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 81.924 |
| dbo.TSB_TIUNSAccountBHasUNSGroupB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSAccountB, UNSRootB, UNSGroupB, DPRNameSpace…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; use | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-UNSAccountBHasUNSItemB, TSB-K-PersonHasObject | 3 | 2 | 81.914 |
| dbo.LDP_TILDAPGroupExclusion calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, LDAPGroup, LDAPGroupCollection, LDAPAccountInLDAPGroup, LDPMachineInLDAPGroup…; uses | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup | 3 | 2 | 81.869 |
| dbo.TSB_TUUNSAccountBHasUNSGroupB1 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBHasUNSGroupB1, UNSAccountB, TSBPersonUsesAccount…; uses config QER\ComplianceCheck\IncludeTSB | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB1, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 76.29 |
| dbo.TSB_TUUNSAccountBHasUNSGroupB2 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBHasUNSGroupB2, UNSAccountB, TSBPersonUsesAccount…; uses config QER\ComplianceCheck\IncludeTSB | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB2, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 76.29 |
| dbo.TSB_TUUNSAccountBHasUNSGroupB3 calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBHasUNSGroupB3, UNSAccountB, TSBPersonUsesAccount…; uses config QER\ComplianceCheck\IncludeTSB | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB3, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 76.29 |
| dbo.TSB_TUUNSAccountBHasUNSGroupB calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, UNSAccountBHasUNSGroupB, UNSAccountB, TSBPersonUsesAccount…; uses config QER\ComplianceCheck\IncludeTSBP | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-PersonHasObject, TSB-K-UNSAccountBHasUNSItemB | 3 | 2 | 76.282 |
| dbo.QBM_TUAssembly_QBMRelation calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE QBMRelation; reads/joins inserted, deleted, QBMRelation, DialogColumn, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITriggerPre | 3 | 3 | 74.689 |
| dbo.QBM_TUAssembly_DialogColumn calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE dialogcolumn; reads/joins inserted, deleted, DialogColumn, dialogtable, Dialogcolumn | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-ScriptAssemblyReset, QBM-K-CommonRebuildView, QBM-K-CommonMakeWatchtrigger | 3 | 3 | 74.381 |
| dbo.QBM_TUDialogState calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogState, QBM_VQBMRelation, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonStateUTCOffset2, QBM-K-CommonStateUTCOffset, QBM-K-CommonCountryUTCOffset | 3 | 2 | 74.35 |
| dbo.QBM_TUDialogGroup calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE dialoggroup; reads/joins inserted, deleted, DialogGroup, dialogGroup | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropGroup, QBM-K-CommonGroupNumber, QBM-K-CommonGroupPattern | 3 | 3 | 72.017 |
| dbo.QER_TDPerson calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, DELETE not, DELETE person, DELETE delegation; reads/joins deleted, QERUniversalSubstitute, delegation, PersonWantsOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QER-K-HelperHeadPerson, QBM-K-CommonReCalculate, QER-K-ITShopRepairClosed | 3 | 4 | 70.604 |
| dbo.QBM_TUDialogConfigParm calls QBM_PHistoryColumnSetDefault, QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, dialogconfigparm, DialogConfigParm, QBMConfigPa | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_bulk | QBM-K-CommonConfigParm, QBM-K-PrepropGenerateFunction, QBM-K-CommonReCalculate | 3 | 2 | 66.824 |
| dbo.QER_TUPWODecisionMethod calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, PWODecisionMethod, QERWorkingMethod, PersonWantsOrg…; uses config QER\ITShop\OnWorkflowAssign | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ITSHOPOrder-RESET, QER-K-ITSHOPOrder-ABORT, QER-K-ShoppingRack-All | 3 | 2 | 66.31 |
| dbo.QER_ZDynGroupSinglePerson calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, DynamicGroup, DialogTable, DialogDBQueue | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-DynamicGroupSinglePerson, QER-K-DynamicGroupTest, QER-K-DynamicGroupSingleBasic | 3 | 1 | 62.226 |
| dbo.QER_TUQERUniversalSubstitute calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, QERUniversalSubstitute, PWOHelperPWO, PersonWantsOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-HelperHeadOrg, QER-K-HelperHeadPerson | 3 | 2 | 60.259 |
| dbo.LDP_TDLDAPGroupExclusion calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, LDAPGroupCollection, LDAPAccountInLDAPGroup, LDPMachineInLDAPGroup, BaseTreeHasLDAPGroup | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | LDP-K-LDAPAccountInLDAPGroup, LDP-K-LDPMachineInLDAPGroup, LDP-K-OrgHasLDAPGroup | 3 | 2 | 58.955 |
| dbo.QBM_TUAssembly_DialValDynRef calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogValidDynamicRef, DialogColumn, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-CommonMakeRITriggerPre, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger | 3 | 2 | 58.954 |
| dbo.ADS_TDDomainTrustsDomain calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, ADSDomain, adsaccount, ADSContact, ADSMachine | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup | 3 | 2 | 58.585 |
| dbo.ADS_TIDomainTrustsDomain calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, ADSDomain, adsaccount, ADSContact, ADSMachine | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSAccountInADSGroup, ADS-K-ADSContactInADSGroup, ADS-K-ADSMachineInADSGroup | 3 | 2 | 58.585 |
| dbo.CPL_TIComplianceRule calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | CPL-K-ComplianceSubRuleFillPerson, CPL-K-ComplianceCheckMakeProc, CPL-K-ComplianceCheckForRule | 3 | 2 | 56.706 |
| dbo.QER_TIQERUniversalSubstitute calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, PWOHelperPWO, PersonWantsOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-HelperHeadOrg, QER-K-HelperHeadPerson | 3 | 2 | 54.679 |
| dbo.QER_TDQERUniversalSubstitute calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, PWOHelperPWO, PersonWantsOrg | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-HelperHeadOrg, QER-K-HelperHeadPerson | 3 | 2 | 54.673 |
| dbo.QBM_TIAssembly_DialValDynRef calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, DialogColumn, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-CommonMakeRITriggerPre, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger | 3 | 2 | 54.376 |
| dbo.QBM_TDAssembly_DialValDynRef calls QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, DialogColumn, DialogTable | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-CommonMakeRITriggerPre, QBM-K-CommonMakeWatchtrigger, QBM-K-CommonMakeRITrigger | 3 | 2 | 54.359 |
| dbo.QBM_TIDialogStateHasTimeZone calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, dialogstate | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonStateUTCOffset2, QBM-K-CommonStateUTCOffset, QBM-K-CommonCountryUTCOffset | 3 | 2 | 50.108 |
| dbo.QBM_TDDialogStateHasTimeZone calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted, dialogstate | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonStateUTCOffset2, QBM-K-CommonStateUTCOffset, QBM-K-CommonCountryUTCOffset | 3 | 2 | 50.104 |
| dbo.QBM_TIDialogState calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonStateUTCOffset2, QBM-K-CommonStateUTCOffset, QBM-K-CommonCountryUTCOffset | 3 | 2 | 48.016 |
| dbo.QBM_TDDialogState calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, DELETE not; reads/joins deleted | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonStateUTCOffset2, QBM-K-CommonStateUTCOffset, QBM-K-CommonCountryUTCOffset | 3 | 2 | 48.011 |
| dbo.QER_TUDialogConfigParm calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE not; reads/joins inserted, deleted, dialogconfigparm | SQL_TRIGGER | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, QER-K-DynamicGroupMakeProc, QER-K-DynamicGroupTest | 3 | 1 | 42.961 |
| dbo.ATT_TUDialogConfigParm calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE not; reads/joins inserted, deleted, dialogconfigparm | SQL_TRIGGER | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, ATT-K-PrepropAttestationObject, ATT-K-PrepropAttestationWizardParm | 3 | 1 | 42.914 |
| dbo.QER_TUDialogColumn calls QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes UPDATE not; reads/joins inserted, deleted, DialogColumn | SQL_TRIGGER | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, QER-K-QERRiskIndexMakeProc, QER-K-QERRiskIndexCalculate | 3 | 1 | 42.858 |
| dbo.QBM_ZRITriggerCreate calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QBM-K-CommonMakeRITriggerI, QBM-K-CommonMakeRITriggerU, QBM-K-CommonMakeRITriggerD | 3 | 1 | 40.703 |
| dbo.QER_TUHelperHeadOrg calls QBM_PJournal, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOCallMethod, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE trigger, DELETE Delegation; reads/joins deleted, inse | SQL_TRIGGER | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, QER-K-ShoppingRackPWODecisionMaker | 2 | 4 | 154.457 |
| dbo.QER_ZITShopOrderReset calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QER_PITShopHelperFill_bulk, QER_PITShopPersonHasObjFill_b, QBM_PDBQueueInsert_Bulk…; writes INSERT into, INSERT PWODecisionHistory, UPDATE personwantsorg, DELETE Hel | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-ShoppingRackPersonHasObject | 2 | 6 | 148.366 |
| dbo.QBM_PDeleteDeep_L calls QBM_PTriggerDisable, QBM_PSessionErrorAdd, QBM_PTriggerEnable, left, QBM_PTriggersInactiveForTable…; writes INSERT into, DELETE statement; reads/joins DialogTable, DialogColumn, QBM_VForeignKeyRepairable, BaseTree, | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-OrgAutoChild, QER-K-AllForPersonInBaseTree | 2 | 2 | 137.362 |
| dbo.QER_TIPersonWantsOrg calls QER_PITShopPersonHasObjFill_b, QBM_PJobCreate_HOCallMethod_L, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, INSERT DialogProcess, INSERT PersonWantsOrg, UPDATE personwantsorg; reads | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackPWOHelperPWO, QER-K-ShoppingRackPersonHasObject | 2 | 5 | 136.257 |
| dbo.RMS_TIESetHasEntitlement calls QBM_PDBQueueInsert_Bulk, QBM_PExecuteSQLMulti, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, BaseTreeAssign, DialogTable, BaseTreehaseset, PersonHasESet… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-ESetHasEntitlement, RMS-K-ESetCollection | 2 | 2 | 121.398 |
| dbo.RPS_TURPSReport calls QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Bulk, QBM_PPrePropCheckSyntax…; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RPS-K-AllForOneRPSReport, RPS-K-PrepropRPSReport | 2 | 2 | 114.914 |
| dbo.QER_TUQERResource calls QER_PIsForITShopFlagCheck, QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, del | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERResource, QER-K-OrgHasQERResource | 2 | 2 | 113.588 |
| dbo.QER_TUQERReuseUS calls QBM_PDBQueueInsert_Bulk, QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, del | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERReuseUS, QER-K-OrgHasQERReuseUS | 2 | 2 | 113.548 |
| dbo.QER_TUQERAssign calls QBM_PDBQueueInsert_Bulk, QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, del | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERAssign, QER-K-OrgHasQERAssign | 2 | 2 | 113.493 |
| dbo.QER_TUQERReuse calls QBM_PDBQueueInsert_Bulk, QER_PIsForITShopFlagCheck, QBM_PJobCreate_HOUpdate_B, QER_PITShopHelperFill_Recalc, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins QER_VPWOProductNodesSlim, inserted, del | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERReuse, QER-K-OrgHasQERReuse | 2 | 2 | 113.45 |
| dbo.RMS_TUESetHasEntitlement calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not, UPDATE ESetHasEntitlement; reads/joins deleted, inserted, ESetHasEntitlement, Eset, ESet… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-ESetHasEntitlement, RMS-K-ESetCollection | 2 | 3 | 110.845 |
| dbo.ATT_TUPerson calls QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Single, QBM_PJobCreate_HOUpdate_L, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT AttestationHistory, UPDATE not, UPDATE AttestationCase; | SQL_TRIGGER | QBM_PDBQueueInsert_Single, QBM_PDBQueueInsert_Bulk | QBM-K-CommonReCalculate, ATT-K-AttestationHelper | 2 | 4 | 110.357 |
| dbo.QER_ZDynamicGroupMakeTrigger calls QBM_PTriggerDrop, QBM_PDBQueueInsert_Bulk, QBM_PSQLCreate, QBM_PSessionErrorAdd; writes INSERT into; reads/joins inserted, deleted, DynamicGroupHasImmediateColumn, DynamicGroup, DialogColumn…; uses config QER\Struc | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-DynamicGroupSingleBasic, QER-K-DynamicGroupTest | 2 | 1 | 105.29 |
| dbo.QER_ZOrgRoot calls QBM_PDBQueueCalculateDelta, QBM_PFESimulationFill, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTreeCollection, DELETE BaseTreeCollection; reads/joins orgroot, BaseTreeCollection, B | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-AllForOneOrg, QER-K-BaseTreeCollectionF | 2 | 3 | 102.864 |
| dbo.QBM_FSQXDateSubItemUpdate calls QBM_PDBQueueInsert_Bulk; writes INSERT into; reads/joins DialogTable, QBMDBQueueTask, DialogColumn, deleted, QBMRelation | SQL_SCALAR_FUNCTION | QBM_PDBQueueInsert_Bulk | QBM-K-XDateSubItemUpdate, QBM-K-XDateSubItemUpdateFU | 2 | 1 | 96.541 |
| dbo.ADS_TUADSAccount calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT ADSOtherSID, INSERT into, UPDATE not, UPDATE ADSAccountInADSGroup, DELETE ADSOtherSID; reads/joins inserted, deleted, ADSGroup, ADSAccount, ADSAccountInA | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-PersonHasObject, ADS-K-ADSAccountInADSGroup | 2 | 5 | 93.785 |
| dbo.QBM_ZPrePropTree calls QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QBM_PDBQueueInsert_WaitForComp, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMTree; reads/joins QBMDBQueueCurrent, QBMTree, DialogTable, DialogDashBoardDef, QB | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_WaitForComp | QBM-K-CommonPrepropSheet, QBM-K-CommonPrepropTree | 2 | 2 | 88.194 |
| dbo.QER_PITShopCheckMethodBO calls QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, INSERT PWOHelperBoardMethod, DELETE PWOHelperBoardMethod; reads/joins PWOHelperBoardMethod, pwodecisionmethod, PWODecisi | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | QER-K-ShoppingRackProductNode, QER-K-ShoppingRackPWODecisionMaker | 2 | 3 | 84.981 |
| dbo.QBM_ZPrePropObject calls QBM_PSessionContextSet, QBM_PDBQueueInsert_WaitForComp, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogObject; reads/joins QBMDBQueueCurrent, DialogObject, dialogtable, DialogObject | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_WaitForComp, QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropSheet, QBM-K-CommonPrepropTreeResult | 2 | 2 | 84.971 |
| dbo.QBM_ZPrePropColumnFK calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogColumn; reads/joins QBMDBQueueCurrent, dialogcolumn, dialogtable, QBMRelation, DialogColumn…; uses session con | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropColumnFK, QBM-K-CommonPrepropTableFK | 2 | 2 | 82.639 |
| dbo.QER_ZOrgInherite calls QBM_PDBQueueInsert_single, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, QBMDBQueueTaskMetric, BaseTree, Orgroot, DialogDBQueue… | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_single, QBM_PDBQueueInsert_Bulk | QER-K-OrgROOT, QER-K-OrgSubTree | 2 | 1 | 82.032 |
| dbo.QBM_ZPrePropTreeResult calls QBM_PDBQueueInsert_Bulk, QBM_PSessionContextSet, QBM_PDBQueueInsert_WaitForComp, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QBMTreeResult; reads/joins QBMDBQueueCurrent, QBMTreeResult, DialogObject, QBMTreeRe | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_WaitForComp | QBM-K-CommonPrepropSheet, QBM-K-CommonPrepropTree | 2 | 2 | 78.085 |
| dbo.ATT_PAfterMigrationTasks calls QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HOTemplate_B, QBM_PJobCreate_HOFireEvent, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE AttestationCase; reads/joins AttestationCase, Attestatio | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk, QBM_PDBQueueInsert_Single | ATT-K-HelperAttestationPolicy, QER-K-DynamicGroupMakeTrigger | 2 | 2 | 75.817 |
| dbo.ADS_TUADSAccountInADSGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, ADSAccountInADSGroup, ADSGroup, ADSAccount…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSAccountInADSGroup, ADS-K-PersonHasObject | 2 | 2 | 75.316 |
| dbo.LDP_TULDAPAccountInLDAPGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, LDAPAccountInLDAPGroup, LDAPGroup, LDAPAccount…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAcc | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | LDP-K-LDAPAccountInLDAPGroup, LDP-K-PersonHasObject | 2 | 2 | 75.27 |
| dbo.ADS_TUADSContactInADSGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, ADSContactInADSGroup, ADSGroup, ADSContact…; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSContactInADSGroup, ADS-K-PersonHasObject | 2 | 2 | 75.244 |
| dbo.RMS_TIPersonHasESet calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, ESet, ESetHasEntitlement, DialogTable, BaseTreeAssign | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-PersonHasESet, RMS-K-PersonHasObject | 2 | 2 | 74.85 |
| dbo.ADS_TIADSAccountInADSGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, ADSGroup, ADSAccount, TSBPersonUsesAccount; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; uses ses | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSAccountInADSGroup, ADS-K-PersonHasObject | 2 | 2 | 74.734 |
| dbo.ADS_TIADSContactInADSGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, ADSGroup, ADSContact, TSBPersonUsesAccount; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; uses ses | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-ADSContactInADSGroup, ADS-K-PersonHasObject | 2 | 2 | 74.734 |
| dbo.LDP_TILDAPAccountInLDAPGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, LDAPGroup, LDAPAccount, TSBPersonUsesAccount; uses config QER\ComplianceCheck\IncludeTSBPersonUsesAccount; uses s | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | LDP-K-LDAPAccountInLDAPGroup, LDP-K-PersonHasObject | 2 | 2 | 74.731 |
| dbo.POL_TUQERPolicy calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_Bulk, QBM_PJobCreate_HODelete_L, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogTable, QERPolicy, QERPolicyHasObject | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | POL-K-QERPolicyMakeProc, POL-K-QERPolicyFill | 2 | 2 | 74.143 |
| dbo.TSB_TIUNSGroupB1Exclusion calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSGroupB1Collection, UNSAccountBInUNSGroupB1, UNSAccountBHasUNSGroupB1, BaseTreeHas | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB1, TSB-K-OrgHasUNSGroupB1 | 2 | 2 | 72.263 |
| dbo.TSB_TIUNSGroupB2Exclusion calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSGroupB2Collection, UNSAccountBInUNSGroupB2, UNSAccountBHasUNSGroupB2, BaseTreeHas | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB2, TSB-K-OrgHasUNSGroupB2 | 2 | 2 | 72.263 |
| dbo.TSB_TIUNSGroupB3Exclusion calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSGroupB3Collection, UNSAccountBInUNSGroupB3, UNSAccountBHasUNSGroupB3, BaseTreeHas | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB3, TSB-K-OrgHasUNSGroupB3 | 2 | 2 | 72.263 |
| dbo.TSB_TIUNSGroupBExclusion calls QER_PExclusionCheckCircular, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, UNSGroupBCollection, UNSAccountBInUNSGroupB, UNSAccountBHasUNSGroupB, BaseTreeHasUNS | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | TSB-K-UNSAccountBInUNSGroupB, TSB-K-OrgHasUNSGroupB | 2 | 2 | 72.23 |
| dbo.QBM_TUDialogCountry calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogCountry, QBM_VQBMRelation, DialogTable… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonCountryUTCOffset, QBM-K-CommonStateUTCOffset2 | 2 | 2 | 71.056 |
| dbo.RMS_TUPersonHasESet calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, PersonHasESet, ESetHasEntitlement, DialogTable… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RMS-K-PersonHasESet, RMS-K-PersonHasObject | 2 | 2 | 69.068 |
| dbo.ADS_TUDomain calls QER_PITShopHelperFill_Recalc, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, ADSDomain, ADSAccount, ADSAccountInADSGroup… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ADS-K-BaseTreeOwnsObject, ADS-K-ADSAccountInADSGroup | 2 | 2 | 68.459 |
| dbo.QBM_PMigrationNotReadyForComp calls QBM_PWaitForSeconds, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd, QBM_PSessionContextSet; reads/joins DialogDatabase; uses session context XUser, GenProcID | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-CommonWaitForCompiler, QBM-K-BaseMigrationReady | 2 | 0 | 67.563 |
| dbo.QER_ZITShopCheck calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, personwantsorg, Personwantsorg, PWOHelperPWO, QERWorkingMethod…; uses config Common\ProcessState\UseGenProcIDFromPWO | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackCheckValid, QER-K-ShoppingRackCheckDecision | 2 | 1 | 66.721 |
| dbo.QER_TIPersonHasQERReuse calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, QERReuse | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERReuse, QER-K-PersonHasObject | 2 | 2 | 65.792 |
| dbo.QBM_ZPrePropGroup calls QBM_PSessionContextSet, QBM_PDBQueueInsert_Single, QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogGroup; reads/joins QBMDBQueueCurrent, dialogGroup, DialogGroup; uses session context GenProcID | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Single | QBM-K-CommonReCalculate, QBM-K-CommonGroupCollection | 2 | 2 | 64.882 |
| dbo.QBM_TUDialogDashBoardDef calls QBM_PSQLCheckExecutable, QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogDashBoardDef | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QBM-K-CommonPrepropDashboardDef, QBM-K-CommonDashboardDef | 2 | 2 | 64.797 |
| dbo.QER_TUHardware calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, Hardware, Hardwaretype | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-AllForOneHardware, QER-K-HelperHardwareOrg | 2 | 2 | 64.658 |
| dbo.CPL_TUPerson calls QBM_PDBQueueInsert_Bulk, QER_PITShopHelperFillAll, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, person, ComplianceRule; uses config QER\ComplianceCheck\CalculateImmediately | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | CPL-K-ComplianceSubRuleFillPersonS, CPL-K-ComplianceCheckForPerson | 2 | 2 | 64.204 |
| dbo.QER_TUPWODecisionSubmethod calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, PWODecisionSubmethod, QERWorkingMethod, PersonWantsOrg…; uses config QER\ITShop\OnWorkflowUpdate | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ITSHOPOrder-RESET, QER-K-ShoppingRack-All | 2 | 2 | 64.1 |
| dbo.QER_TUPWODecisionRuleRulerDete calls QBM_PSQLCheckExecutable, QBM_PDBQueueInsert_bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, PWODecisionRuleRulerDetect | SQL_TRIGGER | QBM_PDBQueueInsert_bulk | QER-K-PWODecisionRuleMakeProc, QER-K-PWOHelperFillMakeProc | 2 | 2 | 63.988 |
| dbo.QER_TIPersonHasQERResource calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, QERResource | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERResource, QER-K-PersonHasObject | 2 | 2 | 63.782 |
| dbo.QER_TIPersonHasQERReuseUS calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, QERReuseUS | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERReuseUS, QER-K-PersonHasObject | 2 | 2 | 63.776 |
| dbo.QER_TIPersonHasQERAssign calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into; reads/joins inserted, QERAssign | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-PersonHasQERAssign, QER-K-PersonHasObject | 2 | 2 | 63.77 |
| dbo.RPS_TIPersonHasRPSReport calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT not, INSERT into, UPDATE RPSSubscription; reads/joins inserted, RPSReport | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | RPS-K-PersonHasRPSReport, RPS-K-PersonHasObject | 2 | 3 | 63.119 |
| dbo.RPS_ZAllForOneRPSReport calls QBM_PJournal, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins RPSReport, BaseTreeHasRPSReport, BaseTreeCollection, PersonHasRPSReport, PersonInBaseTree… | SQL_STORED_PROCEDURE | QBM_PDBQueueInsert_Bulk | RPS-K-OrgHasRPSReport, RPS-K-PersonHasRPSReport | 2 | 1 | 62.725 |
| dbo.ATT_TUAttestationObject calls QBM_PPrePropCheckSyntax, QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, DialogColumn, AttestationObject, AttestationWizardParm | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | ATT-K-PrepropAttestationObject, ATT-K-PrepropAttestationWizardParm | 2 | 2 | 62.034 |
| dbo.QER_TUAccProductGroup calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE not; reads/joins inserted, deleted, QER_VACCProductGroupCollection, AccProduct, BaseTree… | SQL_TRIGGER | QBM_PDBQueueInsert_Bulk | QER-K-ShoppingRackProductNode, QER-K-AccProductGroupCollection | 2 | 2 | 61.116 |