How to estimate the impact of BWA?

[former_member341062]

Hi,

Maybe I'm not looking in the right places, but I can't find any information on how to estimate the inpact to query runtime by introducing BWA. Most articles contain statistics that show that "there was improved performance" based on before and after measurements. I'd like to calculate the approximate effect before buying the system

Should I assume DB time ->0 and keep the rest of the query performance stats or is there a better model?

Regards

Ola

[MartinMaruskin · Accepted solution]

Kindly notice that BWA improves only database manager time not OLAP processing time. You should use BW statistics to determine what part of query execution is the most time consuming... Based on this to determine impact of BWA implementation.

See also BWA homepage @:

http://www.sdn.sap.com/irj/sdn/bwa

[Vitaliy-R]

Ola, DB time does not go to '0', the world is not perfect. The result time of the query execution by BWA as well greatly depends on the number of records returned - DBTRANS in RSDDSTAT_DM. Sorry. -Vitaliy