Whenever I log in to the Service Desk 14.1 console for the first time everyday, my scoreboard do not load properly and it gives delay server response time msg for a long time. When I switch between the tabs to load it again, It gives the message as displayed in the following screenshot:
After log out and log in again, it loads properly and does not give delay server response either.
When I check my logs, I see the following log:
A FETCH for the following statement took 102219 milliseconds: SELECT call_req.open_date, call_req.id, call_req.ref_num, call_req.id FROM call_req WHERE ( call_req.assignee IS NOT NULL OR call_req.group_id IS NOT NULL ) AND ( call_req.type = N'R' OR call_req.type = N'' OR call_req.type IS NULL ) AND call_req.active_flag = 1 ORDER BY call_req.open_date DESC NULLS LAST
What can I do to load my scoreboard properly everytime?
Balram Singh Deswal