Symptoms
You experience performance issues in your Visual Composer models using BPM data sources and/or in SAP Business Warehouse when info packages extract data from BPM data source. You would like to know the real time spent by the queries on the BPM data sources.
HINTS
Step 1 Check following note to get exact query which caused the issue:
1746624 - NetWeaver BPM: trace queries executed on BPM data sources
Step 2 If you don't find any query caused the issue, Check if there is any issue with BPM system itself, you could take threaddump and heapdump as per following notes:
1095473 - How to get a full thread dump in AS Java
2065346 - How to manually generate a Heapdump