Question

1
Replies
136
Views
HariSureshBabuG5756 Member since 2016 10 posts
World Bank
Posted: February 5, 2017
Last activity: February 6, 2017
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
Share this page LinkedIn