-------------------------------------------------------------------------------- | SIZING RESULTS IN GB | |------------------------------------------------------------------------------| | Based on the selected table(s), the anticipated maximum requirement are | | | | for Business Suite on HANA: | | - Memory requirement 132.5 | | - Net data size on disk 123.1 | | | | - Estimated memory requirement after data clean-up 130.3 | | - Estimated net data size on disk after data clean-up 123.7 | | | | Other possible additional memory requirement: | | - for an upgrade shadow instance 33.5 | -------------------------------------------------------------------------------- Check the FAQ document attached to SAP Note 1872170 for explanations on how to interpret the sizing terms and calculations. Sizing report: /SDF/HDB_SIZING Version of the report: 80 Date of analysis: 05.06.2022 Selected sample size: M Data aging retention in days for technical objects: 015 Number of work processes used: 01 Duration of the analysis in seconds: 14,566 HANA version sized: 2.0 SID ECD NW release: 702 SP 10 Kernel version 720_REL Operating system on AS NT 5.2 3790 S x86 Type of analysed database: ORACLE Database version: 11.2.0.3.0 Unicode system: Yes Data used size on disk of the analysed database in GB: 256 Date of last disk size analysis (See FAQ): 05.06.2022 Number of tables successfully analysed: 83,732 Number of tables partially analysed: 1 Number of tables with error: 0 -------------------------------------------------------------------------------- | TABLES PARTIALLY READ NUMBER OF RECORDS SAMPLED | |------------------------------------------------------------------------------| | REPOLOAD 26,855 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | MEMORY SIZING CALCULATION DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Column store data 23.6 | | + Row store data 11.7 | | ------------------------------------------------------------------------- | | = Anticipated memory requirement for the initial data 35.3 | | + Cached Hybrid LOB (20%) 12.0 | | + Work space 35.3 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Anticipated initial memory requirement for HANA 132.5 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | DISK SIZING CALCULATION DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Column store data 23.6 | | + Row store data 11.7 | | + hybrid LOBs 59.8 | | + Space required for merges 3.1 | | + Metadata and statistics 25.0 | | ------------------------------------------------------------------------- | | = Initial net data size on disk 123.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | DATA MODEL CHANGES AND CLEAN UP DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Anticipated memory requirement for the initial data 35.3 | | - Basis Data aged to disk 1.2 | | ------------------------------------------------------------------------- | | = Anticipated memory requirement of data after clean-up 34.1 | | + Cached Hybrid LOB (20%) 12.0 | | + Cached data from aged partitions (20%) 0.2 | | + work space 34.1 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Anticipated total memory requirement after clean-up 130.3 | -------------------------------------------------------------------------------- |------------------------------------------------------------------------------| | DISK SIZING AFTER CLEAN-UP HANA SIZE IN GB | |------------------------------------------------------------------------------| | Anticipated disk requirement for the data after clean-up 34.1 | | + Data aged on disk (50% overhead) 1.8 | | + hybrid LOBs 59.8 | | + Space required for merges 3.0 | | + Metadata and statistics 25.0 | | ------------------------------------------------------------------------- | | = Net data size on disk after clean-up 123.7 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | CLEAN UP CALCULATION DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Basis Data aged to disk: (Total: 1.2GB) | | BALDAT 0.8 | | EDIDS 0.2 | | SWWCNTP0 0.1 | | BALHDR 0.1 | | EDID4 0.1 | | | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | ESTIMATED REQUIREMENT FOR UPGRADE SHADOW INSTANCES HANA SIZE IN GB | |------------------------------------------------------------------------------| | Estimated size of tables cloned to shadow instances 16.7 | | + Estimated corresponding work space requirement 16.7 | | ------------------------------------------------------------------------- | | = Total memory requirement for shadow instances 33.5 | | = Total disk requirement for shadow instances 35.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | MEMORY SIZING FOR PERSISTENT MEMORY (NVRAM) HANA SIZE IN GB | |------------------------------------------------------------------------------| | Column store data 23.6 | | ------------------------------------------------------------------------- | | = Anticipated initial requirement for the Persistent Memory 23.6 | | | | Row store data 11.7 | | + Cached Hybrid LOB (20%) 12.0 | | + Work space 35.3 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Anticipated initial requirement for the DRAM 109.0 | -------------------------------------------------------------------------------- Check SAP Note 2618154 for more information on Persistent Memory. -------------------------------------------------------------------------------- | LARGEST COLUMN ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | DOKTL 1.2 30,030,353 | | FAGLFLEXA 1.1 15,332,014 | | REPOSRC 0.8 3,347,299 | | BALDAT 0.8 2,811,163 | | PCL4 0.6 896,119 | | FMIFIIT 0.5 7,315,335 | | VBPA 0.4 14,875,184 | | ACCTCR 0.4 11,056,970 | | VBFA 0.4 10,495,929 | | BSEG 0.4 7,498,965 | | PCL2 0.4 275,306 | | KONV 0.3 9,505,367 | | SCPRSVALS 0.3 8,233,383 | | PPOIX 0.3 7,689,391 | | BSIS 0.3 5,589,178 | | ACCTIT 0.3 3,685,923 | | E071K 0.2 5,695,030 | | STXH 0.2 5,223,981 | | E071 0.2 5,050,534 | | SCPRVALS 0.2 4,950,550 | | FAGL_SPLINFO_VAL 0.2 4,690,038 | | COEP 0.2 3,768,633 | | WBCROSSGT 0.2 3,696,125 | | BKPF 0.2 3,429,010 | | FMIOI 0.2 3,295,503 | | SEOSUBCOTX 0.2 3,228,485 | | EDIDS 0.2 3,147,500 | | CE1QNCD 0.2 3,070,362 | | OCSCMPLOBJ 0.2 2,293,551 | | STXL 0.2 1,924,415 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN STORE PRIMARY KEY ENTIRE TABLE | | PRIMARY KEYS MEMORY SIZE IN GB SIZE IN GB | -------------------------------------------------------------------------------- | DOKTL 0.6 1.2 | | FAGLFLEXA 0.3 1.1 | | VBPA 0.2 0.4 | | ACCTCR 0.2 0.4 | | VBFA 0.2 0.4 | | KONV 0.2 0.3 | | SCPRSVALS 0.2 0.3 | | PPOIX 0.2 0.3 | | FMIFIIT 0.2 0.5 | | BSEG 0.1 0.4 | | E071K 0.1 0.2 | | BSIS 0.1 0.3 | | STXH 0.1 0.2 | | E071 0.1 0.2 | | SCPRVALS 0.1 0.2 | | FAGL_SPLINFO_VAL 0.1 0.2 | | MLCR 0.1 0.1 | | RSMPTEXTS 0.1 0.1 | | PPOPX 0.1 0.1 | | TODIR 0.1 0.1 | | COEP 0.1 0.2 | | WBCROSSGT 0.1 0.2 | | ACCTIT 0.1 0.3 | | REPOSRC 0.1 0.8 | | FUNCT 0.1 0.1 | | FMIOI 0.1 0.2 | | SEOSUBCOTX 0.1 0.2 | | FUPARAREF 0.1 0.1 | | EDIDS 0.1 0.2 | | NAST 0.1 0.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | D010TAB 3.6 29,884,258 | | D010INC 2.1 11,835,527 | | DD03L 1.7 6,551,600 | | DDPRS 0.3 1,618,060 | | SEOCOMPODF 0.3 1,401,125 | | DD04T 0.2 1,013,524 | | APQD 0.2 583,280 | | ARFCSDATA 0.2 139,458 | | SMIMCONT1 0.2 138,550 | | DD05S 0.1 1,420,017 | | TST03 0.1 1,176,522 | | DD08T 0.1 841,975 | | DD02T 0.1 770,368 | | REPOTEXT 0.1 699,683 | | DD08L 0.1 675,221 | | DDFTX 0.1 602,847 | | DD27S 0.1 535,081 | | CLS_ASSIGNMENT 0.1 434,120 | | DD04L 0.1 415,455 | | DD02L 0.1 384,673 | | USR12 0.1 378,256 | | INDTEXT 0.1 340,330 | | REPOLOAD 0.1 285,499 | | COVREF 0.1 223,970 | | SPROXDAT 0.1 127,373 | | SWFREVTCNT 0.1 122,030 | | LTDX 0.1 39,554 | | EUDB 0.1 33,928 | | STXFCONT 0.1 21,872 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN STORE ESTIMATED LOB ESTIMATED RECORD | | TABLES WITH LOB SIZE ON DISK COUNT | |------------------------------------------------------------------------------| | SOFFCONT1 18.5 761,332 | | REPOSRC 3.4 3,347,299 | | STXL 0.1 1,924,415 | | N2EXTLOAD 0.1 2,768 | | FINB_CONTENT_HIS 0.1 113 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW STORE ESTIMATED LOB ESTIMATED RECORD | | TABLES WITH LOB SIZE ON DISK COUNT | |------------------------------------------------------------------------------| | REPOLOAD 12.7 285,499 | | DYNPSOURCE 12.0 203,739 | | TST03 8.3 1,176,522 | | DYNPLOAD 1.2 60,160 | | FPLAYOUTT 0.9 4,240 | | FPCONTEXT 0.4 2,805 | | REPOTEXT 0.3 699,683 | | ENHOBJCONTRACT 0.3 45 | | ENHHEADER 0.2 12,016 | | COVREF 0.1 223,970 | | WDY_CTLR_COMPO 0.1 157,331 | | D342L 0.1 24,080 | | ENHLOG 0.1 13,875 | | WDR_ADP_CONST_MP 0.1 8,250 | | ENHSPOTHEADER 0.1 7,375 | | ECTD_DATA 0.1 6,895 | | D345T 0.1 5,355 | | SFDG 0.1 4,790 | | SLIN_CACHE 0.1 1,329 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES ESTIMATED HANA STORE | | AFTER CLEAN-UP MEMORY SIZE IN GB | |------------------------------------------------------------------------------| | D010TAB 3.6 RS | | D010INC 2.1 RS | | DD03L 1.7 RS | | DOKTL 1.2 CS | | FAGLFLEXA 1.1 CS | | REPOSRC 0.8 CS | | PCL4 0.6 CS | | FMIFIIT 0.5 CS | | VBPA 0.4 CS | | ACCTCR 0.4 CS | | VBFA 0.4 CS | | BSEG 0.4 CS | | PCL2 0.4 CS | | KONV 0.3 CS | | SCPRSVALS 0.3 CS | | PPOIX 0.3 CS | | BSIS 0.3 CS | | ACCTIT 0.3 CS | | DDPRS 0.3 RS | | SEOCOMPODF 0.3 RS | | E071K 0.2 CS | | STXH 0.2 CS | | E071 0.2 CS | | SCPRVALS 0.2 CS | | FAGL_SPLINFO_VAL 0.2 CS | | COEP 0.2 CS | | WBCROSSGT 0.2 CS | | BKPF 0.2 CS | | FMIOI 0.2 CS | | SEOSUBCOTX 0.2 CS | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES CLONED ESTIMATED HANA ESTIMATED RECORD | | DURING UPGRADES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | D010TAB 3.6 29,884,258 | | D010INC 2.1 11,835,527 | | DD03L 1.7 6,551,600 | | DOKTL 1.2 30,030,353 | | REPOSRC 0.8 3,347,299 | | SCPRSVALS 0.3 8,233,383 | | DDPRS 0.3 1,618,060 | | SEOCOMPODF 0.3 1,401,125 | | E071K 0.2 5,695,030 | | E071 0.2 5,050,534 | | SCPRVALS 0.2 4,950,550 | | WBCROSSGT 0.2 3,696,125 | | SEOSUBCOTX 0.2 3,228,485 | | OCSCMPLOBJ 0.2 2,293,551 | | DD04T 0.2 1,013,524 | | APQD 0.2 583,280 | | ARFCSDATA 0.2 139,458 | | SMIMCONT1 0.2 138,550 | | RSMPTEXTS 0.1 4,005,698 | | FUNCT 0.1 3,340,574 | | FUPARAREF 0.1 3,153,115 | | TADIR 0.1 2,724,054 | | DOKHL 0.1 2,429,098 | | SEOCOMPOTX 0.1 2,178,856 | | DOKIL 0.1 2,071,430 | | SEOSUBCO 0.1 1,965,728 | | SEOSUBCODF 0.1 1,954,750 | | CROSS 0.1 1,592,059 | | DD05S 0.1 1,420,017 | | SEOCOMPO 0.1 1,402,305 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | SCALE OUT ESTIMATED MEMORY ESTIMATED MEMORY | | TABLE GROUP NAMES SIZE BEFORE CLEANUP SIZE AFTER CLEANUP| |------------------------------------------------------------------------------| | COL_TABLES_NOT_GROUPED 26.8 26.8 | | FI_DOCUMENT 3.1 3.1 | | SD_VBAK 2.7 2.7 | | BC_SBAL 0.9 0.0 | | ACC_DOC 0.7 0.7 | | BC_IDOC 0.3 0.1 | | LE_LIKP 0.2 0.2 | | STATUS 0.2 0.2 | | MM_MATDOC 0.2 0.2 | | BC_WORKITEM 0.2 0.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN ESTIMATED HANA SCALE OUT | | STORE TABLES MEMORY SIZE IN GB TABLE GROUP NAMES | |------------------------------------------------------------------------------| | DOKTL 1.2 | | FAGLFLEXA 1.1 FI_DOCUMENT | | REPOSRC 0.8 | | BALDAT 0.8 BC_SBAL | | PCL4 0.6 | | FMIFIIT 0.5 | | VBPA 0.4 SD_VBAK | | ACCTCR 0.4 ACC_DOC | | VBFA 0.4 SD_VBAK | | BSEG 0.4 FI_DOCUMENT | | PCL2 0.4 | | KONV 0.3 SD_VBAK | | SCPRSVALS 0.3 | | PPOIX 0.3 | | BSIS 0.3 FI_DOCUMENT | | ACCTIT 0.3 ACC_DOC | | E071K 0.2 | | STXH 0.2 | | E071 0.2 | | SCPRVALS 0.2 | | FAGL_SPLINFO_VAL 0.2 FI_DOCUMENT | | COEP 0.2 FI_DOCUMENT | | WBCROSSGT 0.2 | | BKPF 0.2 FI_DOCUMENT | | FMIOI 0.2 | | SEOSUBCOTX 0.2 | | EDIDS 0.2 BC_IDOC | | CE1QNCD 0.2 | | OCSCMPLOBJ 0.2 | | STXL 0.2 | -------------------------------------------------------------------------------- Check SAP Note 2408419 and 2428711 for more information about Scale-Out. -------------------------------------------------------------------------------- | DETAILED INITIAL SIZING PER COMPONENT MEMORY SIZE IN GB | |------------------------------------------------------------------------------| | Column Store tables: 11.8 | | - High cardinality: 0.3 | | - Med. cardinality: 0.2 | | - Low cardinality: 0.2 | | - Others: 11.0 | | Column Store keys: 11.8 | | - Primary keys: 8.1 | | - Row ID: 2.1 | | - Udiv: 1.2 | | - Secondary unique keys: 0.4 | | | | Row Store tables: 7.1 | | Row Store primary keys: 1.7 | | Row Store secondary keys: 2.8 | | | | LOB CS data stored on disk: 22.3 | | LOB RS data stored on disk: 37.4 | | | | | | Check SAP Note 1986747 for more information | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES AGING LAST AGING | | OBJECT RUN | |------------------------------------------------------------------------------| | D010TAB | | D010INC | | DD03L | | DOKTL | | FAGLFLEXA | | REPOSRC | | BALDAT BC_SBAL | | PCL4 | | FMIFIIT | | VBPA SD_VBAK | | ACCTCR | | VBFA SD_VBAK | | BSEG FI_DOCUMENT | | PCL2 | | KONV | | SCPRSVALS | | PPOIX | | BSIS | | ACCTIT | | DDPRS | | SEOCOMPODF | | E071K | | STXH | | E071 | | SCPRVALS | | FAGL_SPLINFO_VAL FI_DOCUMENT | | COEP | | WBCROSSGT | | BKPF FI_DOCUMENT | | FMIOI | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES ARCHIVING LAST ARCHIVING | | OBJECT RUN | |------------------------------------------------------------------------------| | D010TAB | | D010INC | | DD03L | | DOKTL | | FAGLFLEXA FI_DOCUMNT | | REPOSRC | | BALDAT 3 OBJECTS | | PCL4 PA_LDOC | | FMIFIIT FM_DOC_FI | | VBPA 5 OBJECTS | | ACCTCR MM_ACCTIT | | VBFA 6 OBJECTS | | BSEG FI_DOCUMNT | | PCL2 2 OBJECTS | | KONV 48 OBJECTS | | SCPRSVALS | | PPOIX PA_PIDX | | BSIS FI_DOCUMNT | | ACCTIT MM_ACCTIT | | DDPRS | | SEOCOMPODF | | E071K BC_E071K | | STXH *6 OBJECTS | | E071 | | SCPRVALS BC_BCSET | | FAGL_SPLINFO_VAL FI_DOCUMNT | | COEP 26 OBJECTS | | WBCROSSGT | | BKPF FI_DOCUMNT | | FMIOI FM_DOC_OI | --------------------------------------------------------------------------------