Question
Anthem
US
Last activity: 18 Dec 2017 0:21 EST
Intermittent Development environment slow down issues.
Hi Team,
We have been facing Intermittent Development environment slow down issues.I could find a lot of errors and Alerts in the logs but couldnt find a starting point to work upon the issue.
Please find the attachment for the PAL Report (Alerts and Errors).
Regards,
Pradeep P.
JPMorgan Chase & Company
US
Hi Pradeep,
In attached document we are not able to see any alerts please check and upload alert and rules log for analysis.
Updated: 27 Nov 2017 13:54 EST
Anthem
US
Hi,
Sure.
Please find the attachment for the Pega Error and Alert logs.
Regards,
Pradeep P.
Anthem
US
Hi Team,
Please find the attachment regarding the PAL report (contains Alerts and Errors) for the issue reported.
Pegasystems Inc.
US
Hi Pradeep,
I opened the spreadsheet you provided (AES_LiteParser.xls), but it appears just to be the base template without any data. Can you check again and make sure the data is saved before uploading.
Pegasystems Inc.
US
Pradeep,
What is the specific version you are running? The logs don't show startup sequence to get the version.
Pegasystems Inc.
US
Hi Pradeep,
I took a quick look at the log files and I have identified a query that appears to be causing delays for other threads/requestors in the system and is likely the slowness that you are experiencing. I believe there are locks associated with that query. Once these queries finish, then the other processes/threads waiting for them complete. Since you are running Oracle, I would suggest working with your DBA to run an explain plan to see where the slowness is occurring and identify if any indexes/statistic updates are needed to make the query run faster. The attached document lists 3 instances of the query, one for Check-in, delete, and saveas. In addition, I did see some PEGA0017 alerts that may indicate a cache hit issue and provided a solution for that in the document as well.
Anthem
US
Hi Brad,
Thank you for your recommendations.Will implement and provide an update.
correction # We are running on MSSQL DB.
Anthem
US
Hi Brad,
Although the indexes of the 3 cache tables has been updated,we are still facing the slowness issues.
PFA for the alerts.
Please suggest.
Pegasystems Inc.
US
Hi Pradeep,
I do not see the same query as being a problem in this latest alert log you provided. This looks more like slowness with searches. See Attached for examples. Can you confirm the activity that was being done when the slowness occurred?
Anthem
US
Hi Brad,
Slowness observed throughout the whole day and it is not easy to point out a specific activity.Everytime I could find different errors and alerts getting clogged.
PFA for the latest logs.