TIBCO BusinessWorks ProcessMonitor Server Performance Tuning :"How to improvise query execution time of "PROC_ACTIVITY_STATISTICS"
Article ID: KB0071669
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:
- If activity statistics not required simply replace the body of the mentioned stored procedure with "NULL".
- 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".
Feedback
Yes
No
Powered by
