Monitoring JavaMelody on /SapphireIMS

Return

Main page

Update

PDF Choice of period : Day

Day

Week

All

Customized

Request	Hits by parent request	Mean time (ms)	Max time (ms)	Standard deviation	Mean cpu time (ms)	Mean allocated Kb	Mean hits sql	Mean time sql (ms)
/UserMgmt_Add.jsp GET		3,913	6,525	3,693	296	71,272	114	129
SELECT UserID FROM userdetails where UserName = ?	16.00	2	275	16
SELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1848	8.00	1	271	7
SELECT AccessType FROM usermgmt_details where AccessID in (1,5)	16.00	0	55	2
Select GroupID from groupdetail where UserID=1848	0.50	1	58	5
Select AccessTo from site_privilege_details where RuleID in(select RuleID from site_privilege_details where AccessCategory=2 and AccessTo in(0,1,5)) and AccessCategory=1	1.00	1	49	2
Select AccessTo from site_privilege_details where RuleID in(select RuleID from site_privilege_details where AccessCategory=3 and AccessTo=1848) and AccessCategory=1	0.50	0	3	0
Select ud.UserName as userid, um.FullName, um.EmailAddress from userdetails ud inner join usermgmt_master um on ud.userid = um.userid where ud.UserID = ?	1.00	1	40	3
select Accessid from usermgmt_details where accessid = (SELECT AccessID FROM usermgmt_master where userID = ?) and (accessnodes like '%Share BSM Dashboard%' or accessnodes like '%Performance%')	1.00	3	278	25
SELECT UserID FROM userdetails where UserName=?	2.00	0	38	2
SELECT um.userid FROM usermgmt_master um,usermgmt_details ud where um.accessid = ud.accessid and ud.accessnodes like '%Performance%' and um.userid = ?	1.00	1	31	3
select bsm.siteid from bsmrolebasedsystem_info bsm inner join inventorymaster i on bsm.siteid = i.siteid and bsm.systemid = i.systemid inner join devicecategorymaster d on d.devicecategoryid = i.devicecategoryid where bsm.custompoller=2 and bsm.rootid = 0 and bsm.userid = ? and d.DeviceGroupID = ? and i.configpoll = 1 limit 1	3.00	1	47	2
select bsm.siteid from bsmrolebasedsystem_info bsm inner join resourcepollermapping rpm on bsm.siteid = rpm.siteid and bsm.systemid = rpm.resourceid inner join pollercategorydetails pcd on rpm.pollerid = pcd.pollerid where bsm.userid = ? and bsm.custompoller=1 and bsm.rootid = 0 and pcd.pollergroupid=? limit 1	2.00	1	68	4
SELECT group_concat(PollerID) FROM pollercategorydetails where pollergroupid not in (67,63,130,257)	1.00	1	17	1
select bsm.siteid from bsmrolebasedsystem_info bsm inner join cp_sysinfo cp on bsm.siteid = cp.siteid and bsm.systemid = cp.monitoringid where bsm.custompoller=? and bsm.rootid = 0 and bsm.userid = ? and cp.iscustompoller=? limit 1	2.00	1	37	2
Select SettingValue from configsettings where SettingKEY='SYMANTEC_AV_COLLECTION'	1.00	1	28	4
SELECT GROUP_CONCAT(GroupID) FROM groupdetail where UserID=1	8.00	1	108	7
Select GroupID from groupdetail where UserID=1	0.50	0	47	1
Select AccessTo from site_privilege_details where RuleID in(select RuleID from site_privilege_details where AccessCategory=3 and AccessTo=1) and AccessCategory=1	0.50	0	34	1
select ifnull(group_concat(distinct accessto),'') from site_privilege_details where accesscategory = 4 and ruleid in (select ruleid from site_privilege_details where (accessto = 1 and accesscategory = 3) or (accesscategory = 2 and accessto in(Select GroupID from groupdetail where UserID=1))) and accessto not in(0)	0.50	1	47	3
SELECT ProjectID, ProjectName FROM sd_project_master where Status=0 and ProjectID in (SELECT distinct(ProjectID) FROM sd_project_roles where ProjectRoleID in (SELECT ProjectRoleID FROM sd_project_roles_details where UserID=1))	0.50	1	28	2
Select count(RoleID) from bsmroledetails where iscustompoller = 0 and type = 4 and MonitoringID = 0 and RoleID in (2,1)	1.50	1	18	1
SELECT * FROM privilege_details where GroupID in (select GroupID from groupdetail where UserID=1) and PrivilegeID=4	0.50	1	14	1