Question
3
Replies
121
Views
Posted: September 5, 2016
Last activity: December 1, 2016
Closed
Solved
Recording of DB operation time
We see some perfomance on prod env. There are spikes in graph of perfomance for etalon operation. We want to understand side of root cause.
We need to trace pure time that Pega spent to work with DB. Is there any configuration to switch on recording of DB operation time to log.
***Updated by moderator: Lochan to add Categories***
Posted: 4 years ago
I addition to what Kevin suggested, you can also analyze PAL reading for any specific transaction . PAL would present the time each components like DB , CPU taken in a transaction. You can find many useful links about PAL in PDN.
check this link for details: https://pdn.pega.com/sites/pdn.pega.com/files/help_v719/procomhelpmain.htm#howto/howto2/monitorlengthydatabaseresponses.htm