Symptom
You are planning to migrate your BW system to BW-on-HANA or build a
new BW-on-HANA system. You need to do a proper sizing for the SAP HANA
database.
Other Terms
HANA SIZING MASTER NODE WORKER SLAVE ROWSTORE
Reason and Prerequisites
You consider to run a scale-out SAP HANA appliance.
Solution
In a BW-on-HANA system with a scale-out SAP HANA appliance we
distinguish between a "master" node and several "worker" nodes. The
"master" node handles the transactional load of the BW system, while the
"worker" nodes handle the load from data read access and data loading.
This is enabled by distributing the tables according to their usage
type. System tables are stored on the "master" node either as RowStore
tables or as ColumnStore tables (examples: RSDDSTAT*, REPOLOAD, BALDAT*,
RSD*, # ). Tables generated by BW to store the transactional and master
data are distributed across the "worker" nodes (basically all tables
with the name /BIC/*, /BI0/*, # ).
The storage requirement for the system tables is partially stable and independent of the size of the BW system, but other parts grow as the systems sizes grows, e.g. statistic tables, log tables, object metadata tables, # . The size of these system tables should be kept minimal by proper house-keeping methods (see e.g. link http://scn.sap.com/docs/DOC-13132). Nevertheless for systems larger than approximately 20TB (size of the original uncompressed BW system) we recommend to consider a scale-out HANA appliance based on nodes with at least 1TB of RAM per node to ensure stable operations.
Of course, this is a very general guideline which must be assessed individually based on the system usage pattern and other operational aspects. Please discuss this with your Hardware partner and get help from your consulting team or SAP services.
The storage requirement for the system tables is partially stable and independent of the size of the BW system, but other parts grow as the systems sizes grows, e.g. statistic tables, log tables, object metadata tables, # . The size of these system tables should be kept minimal by proper house-keeping methods (see e.g. link http://scn.sap.com/docs/DOC-13132). Nevertheless for systems larger than approximately 20TB (size of the original uncompressed BW system) we recommend to consider a scale-out HANA appliance based on nodes with at least 1TB of RAM per node to ensure stable operations.
Of course, this is a very general guideline which must be assessed individually based on the system usage pattern and other operational aspects. Please discuss this with your Hardware partner and get help from your consulting team or SAP services.
Header Data
| Released On | 03.05.2013 11:42:18 | ||
| Release Status | Released for Customer | ||
| Component | HAN-DB SAP HANA Database | ||
| Other Components |
| ||
| Priority | Recommendations / Additional Info | ||
| Category | Consulting |
sap hana online training in usa
ReplyDeletesap hana online training in usa
Great information. Thanks for sharing.
ReplyDeletesap hana online training in usa