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'
--?>