Question:
Hi All,
I need to make some recommendations about hardware sizing. Is there a way I can use BW statistics to prove that the resources are not enought. Also, how can I provide statistics about loading times: to load 500000 records, the time taken was 60 minutes. This info I got from the monitor.
Is there a BW Statistics cube for the data extraction statistics?
Thanks
- Gary
Answer:
hi,
i think to say something to the performance, we need more input.
just the number of records isn't enough.
how huge is a record? one field .... 50 fields ?
are you feeding the data with routines? do you convert something?
business content extractor ?
to how many cubes the data flows ?
how many other jobs running at the same time?
did you rebuild the indecies ?
is thesource system r/3 ?
do you load the data at night ? are there running any jobs in r3 at the same time ?
and so on ... there are so many factors ...
think about all the points above ....
kind regards,
toadward
Answer:
It is hard to size BW systems. There are a lot of factors and variables involved. Every customers useage and development is different.
You have to take into account:
- network connectivity between BW and R/3
- availability of R/3 system to pull deltas
- # of records in the source system
- design of ODS and Cubes
- need for keeping "safety" data in PSA data
- number, amount and records for all infoobjects.
- number of users querying the system, also how they are querying the system. (Web vs. Excel - excel is actually worse, a lot more overhead).
- peak times of access.
- growth of db over time
- addtional Cubes/ODS/Data targets which plan to be added over time
There is a very basic calculation that you can make in that for the number/size of data in R/3 that you pull, it will grow about 5-10 times in BW. But again this is extremely general as a guide. It depends on how many Cubes/ODS objects you have, their size and design and the number of records being added on a daily basis.
In the case of looking at a DEV or TEST system it is hard to make really meaningful judgements on growth as they are normally not an accurate reflection of production.
You may want to look at the Know How Network transcripts (http://service.sap.com/bw -> Know How Network) to see if sizing had been one of the discussions. (I *think* it was, but I am not sure). There is a Know How Conf. call tomorrow on BW Performance Tuning which you might want to check out.
There was actuallly a recent discussion of BW and scalability. These might be starting points for you.
- Stephen
Answer:
Thanks Stephen.
That's very comprehensive. I definitely got a starting point. Now I can pt on paper and see actual data size loads and suggest recommendations on RAM and HardDisk and Network requirements.
- Gary
Answer:
Phase 2: SAP BW Hardware Sizing - June 2000
https://websmp102.sap-ag.de/~form/sapnet?_FRAME=CONTAINER&_OBJECT=012002523100000255262000E
This is a document from the ASAP section of SAP's website on the subject of sizing. It is dated, but it would be a start. They also make refernce to note 184905, A collective note on performance.
- Stephen
Answer:
i have one when did for some other company send me a email
nkvuppala@yahoo.com