cancel
Showing results for 
Search instead for 
Did you mean: 

Performance of multiprovider vs composite provider

Former Member
0 Kudos

Hi All,

We are in BW 7.4 sp 13. What we have noticed is that the query in the multiprovider runs faster compared to the same query rebuilt on composite provider. The query is exactly the same and returns the same number of records,the composite provider uses the same infoproviders( SPOs and cubes total about 20) as the mpro. It is built via the new modeling tools only and has only the Union operation. The query itself is not that complex.

The observation via RSRT is that, the DB time is always more in comp prov. Both queries use execution mode 3. The multiproivder seems to perform select from all the individual infoproviders parallelly whereas the composite provider seems to cluster these 20 infoproviders into 4 parallel processes as shown in the access counter field.

We are also able to observe 20+ dialog processes in sm50 that perform database procedure execution when the query on the multiprovider is executed and 4 dialog processes for the other query which seems to confirm the above behavior.

The composite provider does not seem to utilize the maximum allowable QUERY_MAX_WP_DIAG value in RSADMIN whereas the multiprovider seems to do so which seems to result in much better DataManager event 9000 performance. Has any one observed such a behavior. Any pointers to make the query on the composite provider perform atleast as better as its multiprovider counterpart.

Regards,

Manideep


Accepted Solutions (1)

Accepted Solutions (1)

zili_zhou
Employee
Employee
0 Kudos

you can open an incident, if it is really as you described, the developer should fix this issue.

Former Member
0 Kudos

Hi,

Yes, Looking at the behavior, i too think, it needs to be addressed to SAP. Unfortunately i'm not in a position to followup with SAP, but i will ask the colleague whom i'm helping out to see if they want to pursue further.

Regards,

Mandeep.

Answers (1)

Answers (1)

former_member200967
Active Participant
0 Kudos

Hi Mandeep,

Is it possible for you to check the same with the query execution mode 6?

Regards,

Manpreet

Former Member
0 Kudos

Hi ,

Here are our observations.

Multi ProviderComposite Provider
Mode 3Mode 6Mode 3Mode 6
Datamanager time3 secs3 secs5 secs10 secs
Number of unique access counter values161642

For the multiprovider the mode is not changing the number of parallel read access , whereas for composite provider, the mode 6 seems to utilize even less parallel reads than mode 3 and performs even worse. Anyway, which mode could be better etc might be another topic for now we decided to stick to mode 3 and query on multiprovder.

Regards,

Mandeep