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.
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".
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".
Feedback
Yes
No
Powered by
