-------------------------------------------------------------------------------- | SIZING RESULTS IN GB | |------------------------------------------------------------------------------| | The anticipated maximum requirements for the HANA DATABASE SERVER are: | | | | for S/4HANA: | | - Memory requirement 169.0 | | - Net data volume size on disk 176.6 | | - SAPS category XS | | | | - Memory requirement after optimization 142.4 | | - Net data volume size on disk after optimization 165.2 | | | | - Memory requirement of client-dependent data 37.8 | | | | Other possible additional memory requirement: | | - during the transition to S/4HANA (See FAQ) 1.5 | | - for an upgrade shadow instance 37.1 | -------------------------------------------------------------------------------- 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: 89 Date of analysis: 17.06.2022 Date of CPU analysis: 17.06.2022 Selected sample size: M Cluster sampling mode: S TAANA results used: No Number of work processes used: 01 Duration of the analysis in seconds: 17,250 SID ECP NW release: 702 SP 21 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: 454 Date of last disk size analysis (See FAQ): 14.06.2022 Number of tables successfully analysed: 86,063 Number of tables with error: 0 -------------------------------------------------------------------------------- | MEMORY SIZING CALCULATION DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Column Store data 45.9 | | + Row Store data 9.1 | | + Changes in FI tables and columns 2.2 | | + Changes in MM/SD tables and columns 0.3 | | ------------------------------------------------------------------------- | | = Anticipated memory requirement for the initial data 57.5 | | + Cached Hybrid LOB (10% of size on disk) 8.6 | | + Work space (100% Column + 50% Row Store) 52.9 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Anticipated initial memory requirement 169.0 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | DISK SIZING CALCULATION DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Column Store data 45.9 | | + Row Store data 9.1 | | + Changes in FI tables 2.2 | | + Changes in MM/SD tables 0.3 | | + Hybrid LOBs 85.8 | | + Space required for merges 8.4 | | + Metadata and statistics 25.0 | | ------------------------------------------------------------------------- | | = Initial net data size on disk 176.6 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | MEMORY SIZING AFTER OPTIMIZATION HANA SIZE IN GB | |------------------------------------------------------------------------------| | Memory requirement for the initial data 57.5 | | - Obsolete financial data (Aggregates, indexes...) 4.6 | | - Obsolete logistics data (Aggregates, indexes...) 2.7 | | - Native Storage Extension (NSE) 6.4 | | ------------------------------------------------------------------------- | | = Anticipated memory requirement of data after optimization 43.8 | | + NSE Buffer cache (1/8 of pageable data disk size) 0.8 | | + Work space (100% Column + 50% Row Store) 39.2 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Anticipated total memory requirement after optimization 142.4 | |------------------------------------------------------------------------------| -------------------------------------------------------------------------------- | DISK SIZING AFTER OPTIMIZATION HANA SIZE IN GB | |------------------------------------------------------------------------------| | Disk requirement for the loadable data after optimization 43.8 | | + Pageable data on disk 6.4 | | + Space required for merges 4.3 | | + Metadata and statistics 25.0 | | ------------------------------------------------------------------------- | | = Net data size on disk after optimization 165.2 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | OPTIMIZATION CALCULATION DETAILS HANA SIZE IN GB | |------------------------------------------------------------------------------| | Changes in FI tables and columns (Total: 2.2GB) | | New financial tables: (Total: 2.0GB) | | ACDOCA Lower estimation 1.5 | | ACDOCA Upper estimation 1.9 | | New columns in existing tables: (Total: 0.2GB) | | BSEG 0.1 | | COEP 0.1 | | | | Changes in logistics tables and columns (Total: 0.3GB) | | - New tables: (Total: 0.6GB) | | MATDOC 0.5 | | MATDOC_EXTRACT 0.1 | | - Changes in VBFA: (Total: 0.3-GB) | | Old VBFA table 1.0 | | New VBFA table 0.7 | | | | Obsolete financial data (Total: 4.6GB) | | - Obsolete tables to unload: (Total: 2.8GB) | | FAGLFLEXA 2.5 | | BSIM 0.2 | | ANLP 0.1 | | - Tables moved to historical partitions: (Total: 1.2GB) | | BSIS 0.7 | | BSAD 0.3 | | BSAS 0.3 | | - Deletion of obsolete CO documents: (Total: 0.6GB) | | COEP 0.5 | | | | Obsolete logistics data (Total: 2.7GB) | | - Obsolete tables: (Total: 2.7GB) | | VBOX 0.3 | | VBUK 0.3 | | MSEG 0.3 | | VAPMA 0.2 | | VAKPA 0.2 | | VLPMA 0.2 | | VLKPA 0.2 | | VRPMA 0.2 | | VRKPA 0.2 | | VBUP 0.2 | | MKPF 0.1 | | | | Native Storage Extension pageable size: (Total: 6.4GB) | | BALDAT 1.4 | | BALHDR 0.1 | | CDPOS 3.6 | | DOKTL 1.0 | | EDID4 0.2 | | TADIR 0.1 | | | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | CPU SIZING DETAILS | |------------------------------------------------------------------------------| | Available aggregated statistics basis: Intervals | | Hourly 12.06.2022 - 15.06.2022 | | Daily 17.05.2022 - 01.06.2022 | | Weekly 24.01.2022 - 16.05.2022 | | Monthly 01.04.2021 - 01.01.2022 | | | | Peak (Select equivalent/h) 5,330,740 | | Peak period basis 15.06.2022 | | Peak Factor 9.45 | | Estimated SAPS 10,000 | | Estimated SAPS category XS | | Peak period background tasks percentage 28.45 | -------------------------------------------------------------------------------- Check the FAQ document attached to SAP Note 1872170 for explanations on how to interpret the CPU sizing calculations. -------------------------------------------------------------------------------- | INITIAL PERSISTENT MEMORY SIZING HANA SIZE IN GB | -------------------------------------------------------------------------------- | Column Store data 45.9 | | + Changes in FI tables and columns 2.2 | | + Changes in MM/SD tables and columns 0.3 | | ------------------------------------------------------------------------- | | = Persistent Memory (NVRAM) initial requirement 48.4 | | | | Row store data 9.1 | | + Cached Hybrid LOB (10%) 8.6 | | + Work space 52.9 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Volatile memory (DRAM) initial requirement 120.6 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | PERSISTENT MEMORY SIZING AFTER OPTIMIZATION HANA SIZE IN GB | |------------------------------------------------------------------------------| | Column Store data after optimization 34.7 | | ------------------------------------------------------------------------- | | = Persistent Memory (NVRAM) requirement after optimization 34.7 | | | | Row store data 9.1 | | + Cached Hybrid LOB (10%) 8.6 | | + NSE Buffer cache (1/8 of pageable data disk size) 0.8 | | + Work space 39.2 | | + Fixed size for code, stack and other services 50.0 | | ------------------------------------------------------------------------- | | = Volatile memory (DRAM) requirement after optimization 107.7 | -------------------------------------------------------------------------------- Check SAP Note 2618154 and 2786237 for more information on Persistent Memory. -------------------------------------------------------------------------------- | LARGEST COLUMN ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | CDPOS 4.0 70,379,721 | | FAGLFLEXA 2.5 35,010,170 | | ACDOCA 1.9 44,237,590 | | BALDAT 1.4 4,571,231 | | DOKTL 1.2 30,300,553 | | FMIFIIT 1.2 16,768,880 | | BSEG 1.1 17,189,163 | | VBPA 1.0 35,533,116 | | D010TAB 1.0 29,832,547 | | WBCROSSGT 1.0 15,678,810 | | ACCTCR 0.9 25,385,644 | | PRCD_ELEMENTS 0.8 22,706,181 | | REPOSRC 0.8 3,504,043 | | VBFA 0.7 17,788,784 | | BSIS 0.7 12,811,853 | | PPOIX 0.6 16,008,010 | | CDHDR 0.6 14,710,916 | | ACCTIT 0.6 8,451,755 | | STXH 0.5 12,104,048 | | D010INC 0.5 11,842,025 | | EDIDS 0.5 9,195,251 | | COEP 0.5 8,726,015 | | FMIOI 0.5 7,697,846 | | CE1QNCD 0.5 7,373,389 | | MATDOC 0.5 4,396,657 | | STXL 0.5 4,367,143 | | PCL4 0.5 1,426,978 | | SCPRSVALS 0.4 8,615,366 | | BKPF 0.4 7,967,085 | | NAST 0.4 7,397,218 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN STORE PRIMARY KEY ENTIRE TABLE | | PRIMARY KEYS MEMORY SIZE IN GB SIZE IN GB | |------------------------------------------------------------------------------| | CDPOS 2.3 4.0 | | FAGLFLEXA 0.7 2.5 | | DOKTL 0.6 1.2 | | D010TAB 0.6 1.0 | | ACCTCR 0.6 0.9 | | VBPA 0.5 1.0 | | WBCROSSGT 0.5 1.0 | | PRCD_ELEMENTS 0.4 0.8 | | FMIFIIT 0.4 1.2 | | BSEG 0.3 1.1 | | PPOIX 0.3 0.6 | | CDHDR 0.3 0.6 | | BSIS 0.3 0.7 | | D010INC 0.3 0.5 | | VBFA 0.2 0.7 | | STXH 0.2 0.5 | | FAGL_SPLINFO_VAL 0.2 0.3 | | MLCR 0.2 0.3 | | EDIDS 0.2 0.5 | | SCPRSVALS 0.2 0.4 | | ACCTIT 0.2 0.6 | | PPOPX 0.2 0.3 | | FMIOI 0.2 0.5 | | NAST 0.2 0.4 | | CE1QNCD 0.2 0.5 | | VBOX 0.2 0.3 | | VBUK 0.1 0.3 | | COEP 0.1 0.5 | | BKPF 0.1 0.4 | | FMIFIHD 0.1 0.3 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST ROW ESTIMATED HANA ESTIMATED RECORD | | STORE TABLES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | ARFCSDATA 6.2 3,952,168 | | APQD 2.6 8,040,399 | | COVREF 0.1 221,665 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | ESTIMATED REQUIREMENT FOR UPGRADE SHADOW INSTANCES HANA SIZE IN GB | |------------------------------------------------------------------------------| | Estimated size of tables cloned to shadow instances 18.5 | | + Estimated corresponding work space requirement 18.5 | | ------------------------------------------------------------------------- | | = Total memory requirement for shadow instances 37.1 | | = Total disk requirement for shadow instances 37.7 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN STORE ESTIMATED LOB ESTIMATED RECORD | | TABLES WITH LOB SIZE ON DISK COUNT | |------------------------------------------------------------------------------| | SOFFCONT1 50.3 1,987,284 | | REPOLOAD 12.0 288,460 | | DYNPSOURCE 12.0 204,927 | | REPOSRC 3.6 3,504,043 | | DYNPLOAD 1.0 49,930 | | PCL2 0.9 444,063 | | PCL4 0.5 1,426,978 | | ZHCM_SICKLEAVE 0.5 1,104 | | SMIMCONT1 0.3 168,885 | | REPOTEXT 0.2 653,711 | | SWFREVTCNT 0.2 237,151 | | SWWCNTP0 0.2 214,316 | | WDY_CTLR_COMPO 0.2 168,091 | | TFRT_BLOB 0.2 27 | | STXL 0.1 4,367,143 | | STXFCONT 0.1 21,304 | | D342L 0.1 15,483 | | ECTD_DATA 0.1 8,597 | | SFDG 0.1 4,790 | | D345T 0.1 4,020 | | 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 | |------------------------------------------------------------------------------| | FPLAYOUTT 1.0 4,250 | | FPCONTEXT 0.4 2,944 | | TST03 0.3 38,129 | | ENHHEADER 0.2 12,341 | | ENHOBJCONTRACT 0.2 38 | | COVREF 0.1 221,665 | | SWNCMONI 0.1 25,229 | | ENHLOG 0.1 13,914 | | ENHSPOTHEADER 0.1 7,932 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES ESTIMATED HANA STORE | | AFTER OPTIMIZATION MEMORY SIZE IN GB | |------------------------------------------------------------------------------| | ARFCSDATA 6.2 RS | | APQD 2.6 RS | | ACDOCA 1.9 CS | | FMIFIIT 1.2 CS | | BSEG 1.1 CS | | VBPA 1.0 CS | | D010TAB 1.0 CS | | WBCROSSGT 1.0 CS | | ACCTCR 0.9 CS | | PRCD_ELEMENTS 0.8 CS | | REPOSRC 0.8 CS | | VBFA 0.7 CS | | PPOIX 0.6 CS | | CDHDR 0.6 CS | | ACCTIT 0.6 CS | | STXH 0.5 CS | | D010INC 0.5 CS | | EDIDS 0.5 CS | | FMIOI 0.5 CS | | CE1QNCD 0.5 CS | | MATDOC 0.5 CS | | STXL 0.5 CS | | PCL4 0.5 CS | | SCPRSVALS 0.4 CS | | BKPF 0.4 CS | | NAST 0.4 CS | | DD03L 0.4 CS | | CDPOS 0.3 CS | | FAGL_SPLINFO_VAL 0.3 CS | | MLCR 0.3 CS | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES CLONED ESTIMATED HANA ESTIMATED RECORD | | DURING UPGRADES MEMORY SIZE IN GB COUNT | |------------------------------------------------------------------------------| | ARFCSDATA 6.2 3,952,168 | | APQD 2.6 8,040,399 | | DOKTL 1.2 30,300,553 | | D010TAB 1.0 29,832,547 | | WBCROSSGT 1.0 15,678,810 | | REPOSRC 0.8 3,504,043 | | D010INC 0.5 11,842,025 | | SCPRSVALS 0.4 8,615,366 | | DD03L 0.4 6,931,321 | | E071K 0.2 5,184,553 | | E071 0.2 5,138,862 | | SCPRVALS 0.2 5,060,973 | | SEOSUBCOTX 0.2 3,394,746 | | OCSCMPLOBJ 0.2 2,740,428 | | FUNCT 0.1 3,377,078 | | RSMPTEXTS 0.1 3,298,697 | | FUPARAREF 0.1 3,220,389 | | TADIR 0.1 2,802,116 | | DOKHL 0.1 2,460,243 | | SEOCOMPOTX 0.1 2,299,198 | | SEOSUBCO 0.1 2,104,394 | | SEOSUBCODF 0.1 2,099,355 | | DOKIL 0.1 2,096,797 | | CROSS 0.1 1,838,732 | | SEOCOMPODF 0.1 1,515,647 | | SEOCOMPO 0.1 1,513,664 | | WDY_UI_PROPERTY 0.1 1,462,714 | | TTREEI 0.1 1,377,749 | | TMDIR 0.1 1,072,079 | | REPOTEXT 0.1 653,711 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | SCALE OUT ESTIMATED MEMORY ESTIMATED MEMORY | | TABLE GROUP NAMES SIZE BEFORE OPTIM. SIZE AFTER OPTIM. | |------------------------------------------------------------------------------| | COL_TABLES_NOT_GROUPED 31.1 30.0 | | FI_DOCUMENT 9.1 4.5 | | SD_VBAK 6.3 4.0 | | BC_CHDO 4.5 0.9 | | ACC_DOC 1.6 1.6 | | BC_SBAL 1.5 0.0 | | MM_MATDOC 1.1 0.6 | | BC_IDOC 0.9 0.7 | | LE_LIKP 0.4 0.4 | | STATUS 0.3 0.3 | | CKML 0.2 0.2 | | BC_WORKITEM 0.2 0.2 | | MM_EKKO 0.1 0.1 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST COLUMN ESTIMATED HANA SCALE OUT | | STORE TABLES MEMORY SIZE IN GB TABLE GROUP NAMES | |------------------------------------------------------------------------------| | CDPOS 4.0 BC_CHDO | | FAGLFLEXA 2.5 FI_DOCUMENT | | ACDOCA 1.9 FI_DOCUMENT | | BALDAT 1.4 BC_SBAL | | DOKTL 1.2 | | FMIFIIT 1.2 | | BSEG 1.1 FI_DOCUMENT | | VBPA 1.0 SD_VBAK | | D010TAB 1.0 | | WBCROSSGT 1.0 | | ACCTCR 0.9 ACC_DOC | | PRCD_ELEMENTS 0.8 SD_VBAK | | REPOSRC 0.8 | | VBFA 0.7 SD_VBAK | | BSIS 0.7 FI_DOCUMENT | | PPOIX 0.6 | | CDHDR 0.6 BC_CHDO | | ACCTIT 0.6 ACC_DOC | | STXH 0.5 | | D010INC 0.5 | | EDIDS 0.5 BC_IDOC | | COEP 0.5 FI_DOCUMENT | | FMIOI 0.5 | | CE1QNCD 0.5 | | MATDOC 0.5 MM_MATDOC | | STXL 0.5 | | PCL4 0.5 | | SCPRSVALS 0.4 | | BKPF 0.4 FI_DOCUMENT | | NAST 0.4 SD_VBAK | -------------------------------------------------------------------------------- Check SAP Note 2408419 and 2428711 for more information about Scale-Out. -------------------------------------------------------------------------------- | DETAILED INITIAL SIZING PER COMPONENT MEMORY SIZE IN GB | |------------------------------------------------------------------------------| | Column Store tables: 20.8 | | - High cardinality: 0.5 | | - Med. cardinality: 0.6 | | - Low cardinality: 0.4 | | - Others: 19.3 | | Column Store keys: 25.0 | | - Primary keys: 18.5 | | - Row ID: 4.3 | | - Udiv: 1.4 | | - Secondary unique keys: 0.9 | | | | Row Store tables: 8.7 | | Row Store primary keys: 0.3 | | | | LOB CS data stored on disk: 83.4 | | LOB RS data stored on disk: 2.4 | | | | | | Check SAP Note 1986747 for more information | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES ARCHIVING LAST ARCHIVING | | OBJECT RUN | |------------------------------------------------------------------------------| | ARFCSDATA | | CDPOS *2 OBJECTS | | APQD | | FAGLFLEXA FI_DOCUMNT | | ACDOCA | | BALDAT 3 OBJECTS | | DOKTL | | FMIFIIT FM_DOC_FI | | BSEG FI_DOCUMNT | | VBPA 5 OBJECTS | | D010TAB | | WBCROSSGT | | ACCTCR MM_ACCTIT | | PRCD_ELEMENTS 48 OBJECTS | | REPOSRC | | VBFA 6 OBJECTS | | BSIS FI_DOCUMNT | | PPOIX PA_PIDX | | CDHDR *2 OBJECTS | | ACCTIT MM_ACCTIT | | STXH *8 OBJECTS | | D010INC | | EDIDS 2 OBJECTS | | COEP 26 OBJECTS | | FMIOI FM_DOC_OI | | CE1QNCD 2 OBJECTS | | MATDOC | | STXL *8 OBJECTS | | PCL4 PA_LDOC | | SCPRSVALS | -------------------------------------------------------------------------------- The information below is only used by SAP Support and is not sizing relevant. Maximum statistics age in years: 5 Minimum number of records for count: 10,000,000 Number of times statistics were inconsistent: 3 -------------------------------------------------------------------------------- | LARGEST TABLES WITH COUNT DOUBT | | FORCED COUNT METHOD REASON | |------------------------------------------------------------------------------| | USRBF3 3 01 | | DDXTT 3 01 | | DDXTF 3 01 | -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- | LARGEST TABLES WITH COUNT DOUBT | | NEGATIVE STATS METHOD REASON | |------------------------------------------------------------------------------| | USRBF3 3 01 | | DDXTT 3 01 | | DDXTF 3 01 | --------------------------------------------------------------------------------