Skip to main content
Contact a Moderator

Question

1
Replies
163
Views
 Hari Suresh Babu Gummadi (HariSureshBabuG5756) World Bank
World Bank
US
HariSureshBabuG5756 Member since 2016 10 posts
World Bank
Posted: February 5, 2017
Last activity: February 6, 2017
Posted: 5 Feb 2017 20:42 EST
Last activity: 6 Feb 2017 8:25 EST
Closed

PEGA heavy I/O issue on server

Hi Team,

The below SQL statement is getting executed 417 times per second which will impact the performance.

select 1 from IFCRULES.pr_sys_app_hierarchy_flat where pzTopAppHash = :1 and pzAppHash = :2select 1 from IFCRULES.pr_sys_app_hierarchy_flat where pzTopAppHash = :1 and pzAppHash = :1

Please help in which component is causing this issues.

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

System Administration
Moderation Team has archived post, 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: 5 years ago
Posted: 6 Feb 2017 8:25 EST
Santanu Bhattacherjee (Santanu) PEGA Senior Manager, Cloud Engineering, Management Plane Services
Pegasystems Inc.
IN

Hello

Couple of queries

1. Which version you are on ?

2. From where you are monitoring these queries ?

3. Are you seeing any ALERT in the PEGA ALERT log files which is related to this ?

4. What is the DB version you are on 

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