on 11-28-2011 3:24 AM
Dear All,
We would like to build HANA as EDW Layer, Would please suggest best practice , Node configuration etc
Regards,
manoj.
Hi Manoj,
I suggest you check out the material about BW on HANA on http://experiencesaphana.com.
There is no general answer, as the configuration highly depends on you data volume, update frequency, etc.
The largest single HANA server available comes with 2 TB of memory - that gives you about 1 - 1.2 TB in data storage (the rest will be used for processing the data). That doesn't sound like much, but early BW on HANA projects have seen a data volume reduction of about 1:5, so if your existing data warehouse is less than 5 TB, a single node might be an option...
If you go for a multi-node system, there's not a lot of options for landscape configuration. Just follow the [scaleout guide|http://help.sap.com/hana/hana1_imdb_scale_en.pdf]...
Not an official best practice, but personally I would say that bigger is better - so if you decide to build a multi-node landscape, I would go with XL servers...
cheers
--Juergen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Would please suggest best practice , Node configuration etc
If you are looking for SAP HANA sizing - then please check this SAP note:
Note 1514966 - SAP HANA 1.0: Sizing SAP In-Memory Database
Tomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.