SAP provided an ABAP program /SDF/HDB_SIZING to generate a sizing report for the existing system, such as ECC6 EHP7, and giving proposed information for the targeted system like Suite on HANA, S/4 SFIN,etc.
To be able to run this report, we'll have to apply a couple of SAP notes, then execute the ABAP program.
However, what I have found is, by default settings the ABAP program runs for ever, which seems to analyze all the tables within the SAP systems(for example, in EHP7 there are more than 600,000 tables), and for each table it'll do some sampling. This is easy to understand, since the for each customer its database varies, such as Oracle, SQL Server or DB2, all these databases have different computing on data files, blocks, high watermarks, those sort of things.
As an example, we choose minimum 10,000 sampling which I think it's for each table, the maximum records samples. However it still runs more than 1 hour without returning anything. To be able to see the sample of the report, I'll have to terminate the ABAP program, and key in a specific table, for example, the tiny table USR02. This time the report is OK and give us some information.
Conclusion: This ABAP utility is too 'German over-engineering' which in another word: "useless"
SAP provided an ABAP program /SDF/HDB_SIZING to generate a sizing report for the existing system, such as ECC6 EHP7, and giving proposed information for the targeted system like Suite on HANA, S/4 SFIN,etc.
To be able to run this report, we'll have to apply a couple of SAP notes, then execute the ABAP program.
However, what I have found is, by default settings the ABAP program runs for ever, which seems to analyze all the tables within the SAP systems(for example, in EHP7 there are more than 600,000 tables), and for each table it'll do some sampling. This is easy to understand, since the for each customer its database varies, such as Oracle, SQL Server or DB2, all these databases have different computing on data files, blocks, high watermarks, those sort of things.
As an example, we choose minimum 10,000 sampling which I think it's for each table, the maximum records samples. However it still runs more than 1 hour without returning anything. To be able to see the sample of the report, I'll have to terminate the ABAP program, and key in a specific table, for example, the tiny table USR02. This time the report is OK and give us some information.
**Conclusion: This ABAP utility is too 'German over-engineering' which in another word: "useless"**
https://c2.staticflickr.com/6/5303/29731555662_9175917ff2_b.jpg
https://c1.staticflickr.com/9/8316/29217319714_0099daca82_b.jpg
https://c2.staticflickr.com/6/5157/29217319154_ca260b533f_b.jpg
https://c1.staticflickr.com/9/8536/29217338644_c601e8d6f2_b.jpg
edited Sep 22 '16 at 2:47 am