SOA Suite 12.2.1 Quick Look at Integration Workload Statistics

SOA Suite 12.2.1 Integration Workload Statistics

SOA Suite 12.2.1 has a new feature called Integration Workload Statistics for troubleshooting and monitoring SOA composites. It provides a performance graph and a chart for the average throughput time for the synchronous and asynchronous messages. It can provide details around the endpoints which might be causing delays, or bpel process activities which is taking up most of the execution time. There are five levels at which the data can be collected.

OFF	No data is collected. Default.
MINIMUM	System-wide resource usage data. Resource Utilization Metrics Only
BASIC	MINIMUM + Service and reference endpoint statistics, BPEL and EDN backup queue statistics, BPEL instance statistics.
Normal	BASIC + Key BPEL activities like Receive, Invoke, Pick, and onMessage
FINEST	NORMAL + Data on all BPEL activities.

At the finest level it gives details around all the BPEL activities (assign, transform pick invoke etc.), this details can be downloaded in the form of an excel sheet and analyzed offline.

The report can be downloaded in the form of a csv, html or pdf. It has details around system resources like JVM, system load, data-sources, work managers; composite statistics like composite endpoint performance details, internal queues and EDN queue. It also contains the top 25 slowest composite inbound and outbound endpoints, wires , backups in internal queues , top 25 slowest running process and top 25 most time consuming BPEL activities.

By default this feature is off. Following are the steps to enable it.

• Login to EM console. Navigate to SOA_INFRA->Monitoring->IWS Reports.
  
  
  
  
  
• Set the time and Click configure on top right hand corner.
  
• Set the level and time interval from the dropdown.
  
• Click on OK and we are all done.

I then tested few of my composites (synchronous and asynchronous both) and below is how chart was populated. It shows the throughput and the average response time in milliseconds for the synchronous and asynchronous process.

1. We can switch to a table view which looks like below. 
   
2. It also gives details around total number of synchronous and asynchronous messages, average throughput and total processing time
   
3. The details around average request processing time for synchronous and asynchronous processes, active requests  and requests processed for each of the engines i.e BPEL, Mediator, human workflow, business rules and spring engine can also be viewed. 
   
4. The reports can be downloaded by using links on the top right hand corner of the page.  
   
5. I downloaded a csv report at the finest level and below are some of the screen shots. Details around system resources can be seen below. 
   
6. Details around composite statistics. 
   
7. Details around slowest composite endpoint top 25 only. 
   
8. Details around backups in internal queues.
   
    
9. Details around longest running business processes and most time consuming activities top 25 only. 
   

Continue reading at Oracle DOC