Skip to Content
0
Jun 26, 2009 at 08:02 AM

bad query performance - how to analyze it?

88 Views

Hi all,

since 8 weeks we locate a bad query performance (round about 30% worse than before) in our BW system. At the moment we use a BIA on revision 49 with 4 blades (16GB).

I have already read note 1318214 and analyzed that the most time is spend on the virtual provider(over 80%!).

I´ve seen that a lot of time is spend on the "Datamanager":

For example: It takes 0,76s to select 3.5million items in the relative provider and 78s!!! to select 0 items in the virtual provider.

information from RSDDSTATTREXSERV:

RFC Server BIA client BIA Kernel ABAP RFC

497 464 450 619

So it seems to be a problem an the BW site, what can we do to improve the performance or analyse the query performance better.

Best Regards,

Jens