cancel
Showing results for 
Search instead for 
Did you mean: 

How to estimate the impact of BWA?

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

MartinMaruskin
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

Vitaliy-R
Developer Advocate
Developer Advocate
0 Kudos

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