Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Mariane Ammar (MarianeA)
Murex

Murex
LB
MarianeA Member since 2016 78 posts
Murex
Posted: Jul 20, 2017
Last activity: Jul 20, 2017
Posted: 20 Jul 2017 8:40 EDT
Last activity: 20 Jul 2017 12:58 EDT
Closed

Set log alert if query takes longer than 30 seconds

Hello,

Is it possible to set some pega alert when sql queries (ran when report definition or data pages are called) take longer than 30 seconds?

Thank you,

Mariane

***Updated by moderator: Lochan to add Categories***

To see attachments, please log in.
Data Integration
System Administration

Posted: 7 years ago
Posted: 20 Jul 2017 10:40 EDT
Swarnendu Mukherjee (SwarnenduM)
BUPA
Swarnendu Mukherjee
BUPA
AU

By default PRPC provides alert log for long running SQLs. If you want you can customize the threshold time. 

For specific solution, you can capture pre and post steps and print in log

To see attachments, please log in.
Posted: 7 years ago
Posted: 20 Jul 2017 11:40 EDT
Mariane Ammar (MarianeA)
Murex

Murex
LB

 Hello SwarnenduM,

Thank you for reply !

Can you please provide me with information on how to customize the threshold time ?

Which logger detects the long running SQLs? If there isn't any specific logger for that, can you please share with me an example of an alert log that detects the long running SQL.

Thank you,

Mariane

 

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice