TIBCO BusinessWorks ProcessMonitor Server Performance Tuning :"How to improvise query execution time of "PROC_ACTIVITY_STATISTICS"

TIBCO BusinessWorks ProcessMonitor Server Performance Tuning :"How to improvise query execution time of "PROC_ACTIVITY_STATISTICS"

book

Article ID: KB0071669

calendar_today

Updated On:

Products Versions
TIBCO BusinessWorks ProcessMonitor TIBCO BusinessWorks ProcessMonitor Server 3.1.0

Description

 
  Few Tips on tuning BWPM performance related to  query execution time of "PROC_ACTIVITY_STATISTICS" are listed below. 

Resolution

     Performance of BWPM is directly related to the performance of the underlying RDBMS.
 
  -  Index and Table statistics are to be calculated frequently, as this will help the DB's optimizer to build a better execution plan.
 
  -  DBA can implement the following:
    
  • SGA tuning
  • Redo log tuning
  • Partitioning
 
  - If activity statistics not required simply replace the body of the mentioned stored procedure with "NULL".

Issue/Introduction

TIBCO BusinessWorks ProcessMonitor Server Performance tuning on query execution time of "PROC_ACTIVITY_STATISTICS". Indexes and tables statistics to be calculated and DBA can implement : SGA Tuning, Redo log tuning, Partitioning or if statistics not required then replace the body of the stored procedure with "Null".