We have portal page which is taking more than 3 minutes to load. I have found the slow running widget on that page and have reduced the server side script and debugged it but it is still showing total processing time as 3 minutes in that CPU time is more than 2 minutes and SQL time is less than 1 minute. Please see the debug log below.
End #11515710 /api/now/sp/page, user: xxxxx, total time: 0:03:08.307, processing time: 0:03:08.307, CPU time: 0:02:20.831, SQL time: 0:00:58.245 (count: 222,342), business rule: 0:00:00.005 (count: 2), ACL time: 0:00:00.033, Cache build time: 0:00:00.001, Script time: 0:00:00.011 (count: 19), source: 136.226.254.82, type: rest , method:GET, api_name:now/sp, resource:now/sp/page, version:Default, user_id:xxxxxxxxxxxx, response_status:200
This problem is happening only in Prod instance.
Please let me know how to fix this CPU time.
