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".