• I have used WhoIs-Active version 11..

    I found as below script frequently access in database from application, Pl. suggest me, How can escalate to application developer?

    Wait Info: (1ms)LATCH_EX [ACCESS_METHODS_DATASET_PARENT]

    CPU: 4,220

    Memory: 11.841

    status: suspended

    <?query --

    Select J.Doc_Type, J.Doc_No, J.RegnNo, J.Doc_Date, J.Doc_Dept,

    PM.First_Name, PM.Last_Name, PM.Dt_Birth, PM.Sex,

    Replace(IsNull(EM.MobileNo,''),'+91','') as MobileNo,

    PM.CaseNo, PM.Emp_No, EM.Email_ID, RM.Description As Relation

    From Patient_Master PM

    Join DailyCase_Det DD ON PM.CaseNo = DD.CaseNO

    Join Employee_Master EM ON EM.Emp_No = PM.Emp_No

    Join Code_Master RM ON RM.Hosp_Code = 0 And RM.Type_Code = 7 And RM.Code = PM.Relation

    Join Jio_Interface J ON J.Regnno = DD.RegnNo

    Where J.Doc_Status <> 'Success' And J.Doc_No > 0 And IsNull(J.Doc_Tried,0) <= 5 And J.Doc_Date >= '12 Apr 2016'

    --?>