Question 3 Replies 167 Views × Close popover Mariane Ammar (MarianeA) Murex Murex LB View Profile Send Message MarianeA Member since 2016 72 posts Murex Posted: July 20, 2017 Last activity: July 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*** Data Integration System Administration × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years ago Posted: 20 Jul 2017 10:40 EDT × Close popover Swarnendu Mukherjee (SwarnenduM) Infosys Technology Architect Infosys AU View Profile Send Message SwarnenduM Infosys replied to MarianeA 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 Posted: 3 years ago Posted: 20 Jul 2017 11:40 EDT × Close popover Mariane Ammar (MarianeA) Murex Murex LB View Profile Send Message MarianeA Murex replied to SwarnenduM 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 Posted: 3 years ago Posted: 20 Jul 2017 12:58 EDT × Close popover Wai-Kei Kwok (WaikeiKwok_GCS) PEGA Principal Software Solutions Engineer Pegasystems Inc. US View Profile Send Message WaikeiKwok_GCS PEGA replied to MarianeA https://pdn.pega.com/community/pega-product-support/question/how-set-higher-threshold-value-specific-web-servicedb-call should help on how to customize db query execution time threashold.