SIZING RESULTS IN GB
Based on the selected table(s), the anticipated maximum requirement are
for S/4HANA:
- Memory requirement for the initial installation 346,5
- Net data size on disk for the initial installation 270,4
- Estimated memory requirement after data clean-up 279,7
- Estimated net data size on disk after data clean-up 249,7
Other possible additional memory requirement:
- during the transition to S/4HANA (See FAQ) 1,0
- for an upgrade shadow instance 38,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: 70
Date of analysis: 05.07.2017
Selected accuracy: M
Number of work processes used: 10
HANA version sized: 2.0
SID EMP
NW release: 731 SP 16
Kernel version 721_EXT_REL
Operating system on AS NT 6.1 7601 S x86
Type of analyzed database: MSSQL
Database version: 11.00.5657
Unicode system: Yes
Used size on disk of the analysed database in GB: 889
Number of tables successfully analyzed: 94.119
Number of tables partially analyzed: 0
Number of tables with error: 0
MEMORY SIZING CALCULATION DETAILS HANA SIZE IN GB
Column store data 129,5
+ Row store data 4,6
+ Changes in FI tables and columns 4,7
+ Changes in MM/SD tables and columns 1,0
= Anticipated memory requirement for the initial data 139,8
+ Cached Hybrid LOB (20%) 16,9
+ Work space 139,8
+ Fixed size for code, stack and other services 50,0
= Anticipated initial memory requirement for HANA 346,5
DISK SIZING CALCULATION DETAILS HANA SIZE IN GB
Column store data 129,5
+ Row store data 4,6
+ Changes in FI tables 4,7
+ Changes in MM/SD tables 1,0
+ hybrid LOBs 84,6
+ Space required for merges 21,0
+ Metadata and statistics 25,0
= Initial net data size on disk 270,4
DATA MODEL CHANGES AND CLEAN UP DETAILS HANA SIZE IN GB
Anticipated memory requirement for the initial data 139,8
- Obsolete financial data (Aggregates, indexes...) 8,8
- Obsolete logistics data (Aggregates, indexes...) 2,1
- Basis Data aged to disk 25,0
= Anticipated memory requirement of data after clean-up 103,9
+ Cached Hybrid LOB (20%) 16,9
+ Cached data from aged partitions (20%) 5,0
+ work space 103,9
+ Fixed size for code, stack and other services 50,0
= Anticipated total requirement for HANA after clean-up 279,7
DISK SIZING AFTER CLEAN-UP HANA SIZE IN GB
Anticipated disk requirement for the data after clean-up 103,9
+ Data aged on disk 25,0
+ hybrid LOBs 84,6
+ Space required for merges 11,2
+ Metadata and statistics 25,0
= Net data size on disk after clean-up 249,7
CLEAN UP CALCULATION DETAILS HANA SIZE IN GB
Changes in FI tables and columns (Total: 4.7GB)
New financial tables: (Total: 3.9GB)
ACDOCA Lower estimation 1,8
ACDOCA Upper estimation 3,2
ACDOCA_M_EXTRACT Lower estimation 0,1
ACDOCA_M_EXTRACT Upper estimation 0,6
New columns in existing tables: (Total: 0.8GB)
COEP 0,6
BSEG 0,2
Changes in logistics tables and columns (Total: 1.0GB)
- New tables: (Total: 1.2GB)
MATDOC 1,0
MATDOC_EXTRACT 0,2
- Changes in VBFA: (Total: 0.3-GB)
Old VBFA table 0,6
New VBFA table 0,4
Obsolete financial data (Total: 8.8GB)
- Obsolete tables to unload: (Total: 2.6GB)
FAGLFLEXA 2,2
BSIM 0,3
ANLP 0,1
- Tables moved to historical partitions: (Total: 1.5GB)
BSIS 1,3
BSAS 0,2
BSAK 0,1
BSAD 0,1
- Deletion of obsolete CO documents: (Total: 4.6GB)
COEP 2,7
COSS 1,2
COSP 0,7
Obsolete logistics data (Total: 2.1GB)
- Obsolete tables: (Total: 2.1GB)
MSEG 0,8
VLPMA 0,2
VBOX 0,2
VBUP 0,1
VAPMA 0,1
VRPMA 0,1
MKPF 0,1
MSPRH 0,1
MARDH 0,1
MSSQH 0,1
Basis Data aged to disk with 15 days retention: (Total: 25.0GB)
BALDAT 13,0
CDPOS 5,8
EDID4 2,8
EDIDS 2,3
BALHDR 0,6
CDHDR 0,5
ESTIMATED REQUIREMENT FOR UPGRADE SHADOW INSTANCES HANA SIZE IN GB
Estimated size of tables cloned to shadow instances 19,2
+ Estimated corresponding work space requirement 19,2
= Total memory requirement for shadow instances 38,5
= Total disk requirement for shadow instances 38,5
LARGEST COLUMN ESTIMATED HANA ESTIMATED RECORD
STORE TABLES MEMORY SIZE IN GB COUNT
BALDAT 13,2 44.237.054
SWWCNTP0 7,7 10.917.488
CDPOS 6,2 71.804.947
COEP 4,7 67.545.151
FAGL_SPLINFO_VAL 3,5 103.176.942
EDID4 3,2 74.601.938
ACDOCA 3,2 70.140.315
APQD 2,7 12.814.337
EDIDS 2,6 43.507.567
FAGLFLEXA 2,2 30.576.105
COSS 2,2 21.984.278
DMS_CONT1_CD1 2,2 1.266.629
BSEG 2,1 28.991.411
JEST 1,8 63.300.988
JCDS 1,6 48.853.926
ACCTCR 1,6 45.313.087
DOKTL 1,6 40.723.504
FAGL_SPLINFO 1,6 34.087.227
D010TAB 1,4 39.500.776
SWWLOGHIST 1,4 23.242.345
BDCP2 1,3 31.752.070
BSIS 1,3 21.555.287
RORQSTPRMS 1,2 25.515.857
COSP 1,2 17.494.496
ACCTIT 1,2 15.335.158
DBTABLOG 1,2 7.710.838
CMFP 1,1 25.065.658
QASV 1,0 23.292.871
QAMV 1,0 16.279.612
MATDOC 1,0 9.271.592
LARGEST COLUMN STORE PRIMARY KEY ENTIRE TABLE
PRIMARY KEYS MEMORY SIZE IN GB SIZE IN GB
CDPOS 3,8 6,2
FAGL_SPLINFO_VAL 2,1 3,5
EDID4 1,4 3,2
EDIDS 1,2 2,6
COSS 1,1 2,2
COEP 1,0 4,7
JEST 1,0 1,8
ACCTCR 1,0 1,6
JCDS 0,9 1,6
BALDAT 0,9 13,2
DOKTL 0,8 1,6
D010TAB 0,8 1,4
FAGL_SPLINFO 0,7 1,6
SWWLOGHIST 0,7 1,4
FAGLFLEXA 0,6 2,2
RORQSTPRMS 0,6 1,2
BSIS 0,6 1,3
COSP 0,6 1,2
BDCP2 0,5 1,3
BSEG 0,5 2,1
QASV 0,5 1,0
S027 0,5 0,8
COSB 0,5 0,8
CMFP 0,4 1,1
WBCROSSGT 0,4 0,7
RPSCO 0,4 0,8
MCKALKW 0,4 0,8
D010INC 0,4 0,7
COSSD 0,4 0,6
AUAS 0,3 0,9
LARGEST ROW ESTIMATED HANA ESTIMATED RECORD
STORE TABLES MEMORY SIZE IN GB COUNT
LTEX 1,6 587.147
ARFCSDATA 0,8 492.618
SWNCMONI 0,8 283.355
DDFTX 0,3 1.663.762
ARFCSSTATE 0,3 398.358
TRFCQOUT 0,2 400.284
DDTYPES 0,1 1.195.305
COVREF 0,1 255.716
TBTCO 0,1 114.723
LTDX 0,1 34.369
LARGEST COLUMN STORE ESTIMATED LOB ESTIMATED RECORD
TABLES WITH LOB SIZE ON DISK COUNT
SOFFCONT1 41,0 1.642.216
REPOLOAD 13,8 348.477
FCC_INST_FILE 5,4 3.773
APQD 4,4 12.814.337
REPOSRC 4,3 4.028.196
DYNPSOURCE 3,2 224.482
SIGNDO 1,9 130.436
DYNPLOAD 1,5 69.198
REPOTEXT 0,6 1.081.144
DBTABLOG 0,2 7.710.838
WDY_CTLR_COMPO 0,2 233.861
WDR_ADP_CONST_MP 0,2 10.157
TFRT_BLOB 0,2 27
STXL 0,1 1.486.798
COV_GENDATA 0,1 256.344
D342L 0,1 26.139
WDY_CONFIG_DATA 0,1 9.965
D345T 0,1 7.558
SFDG 0,1 4.790
WDR_RR_LOAD 0,1 3.659
N2EXTLOAD 0,1 2.768
FINB_CONTENT_HIS 0,1 132
LARGEST ROW STORE ESTIMATED LOB ESTIMATED RECORD
TABLES WITH LOB SIZE ON DISK COUNT
FPLAYOUTT 1,8 7.920
ENHOBJCONTRACT 1,4 905
TST03 0,8 118.566
ENHLOG 0,6 88.668
ECTD_XML_STR 0,6 20.397
FPCONTEXT 0,5 3.578
ENHHEADER 0,3 16.378
ECTD_DATA 0,2 33.606
ECSCR_XML_STR 0,1 26.986
ENHSPOTHEADER 0,1 8.875
LARGEST TABLES ESTIMATED HANA STORE
AFTER CLEAN-UP MEMORY SIZE IN GB
SWWCNTP0 7,7 CS
FAGL_SPLINFO_VAL 3,5 CS
ACDOCA 3,2 CS
APQD 2,7 CS
DMS_CONT1_CD1 2,2 CS
BSEG 2,1 CS
COEP 2,0 CS
JEST 1,8 CS
JCDS 1,6 CS
ACCTCR 1,6 CS
DOKTL 1,6 CS
FAGL_SPLINFO 1,6 CS
LTEX 1,6 RS
D010TAB 1,4 CS
SWWLOGHIST 1,4 CS
BDCP2 1,3 CS
RORQSTPRMS 1,2 CS
ACCTIT 1,2 CS
DBTABLOG 1,2 CS
CMFP 1,1 CS
QASV 1,0 CS
QAMV 1,0 CS
MATDOC 1,0 CS
COSS 0,9 CS
AUAS 0,9 CS
REPOSRC 0,9 CS
RPSCO 0,8 CS
MCKALKW 0,8 CS
S027 0,8 CS
COSB 0,8 CS
LARGEST TABLES CLONED ESTIMATED HANA ESTIMATED RECORD
DURING UPGRADES MEMORY SIZE IN GB COUNT
APQD 2,7 12.814.337
DOKTL 1,6 40.723.504
D010TAB 1,4 39.500.776
DBTABLOG 1,2 7.710.838
REPOSRC 0,9 4.028.196
ARFCSDATA 0,8 492.618
SWNCMONI 0,8 283.355
WBCROSSGT 0,7 15.390.370
D010INC 0,7 14.327.277
E071K 0,6 14.281.070
SCPRSVALS 0,4 9.385.764
DD03L 0,4 7.562.299
E071 0,3 8.271.009
SEOSUBCOTX 0,3 5.184.771
ARFCSSTATE 0,3 398.358
RSMPTEXTS 0,2 6.334.754
SCPRVALS 0,2 5.913.791
FUNCT 0,2 4.764.847
WBCROSSI 0,2 4.040.110
OCSCMPLOBJ 0,2 2.837.819
SMIMCONT1 0,2 153.210
SEOCOMPOTX 0,1 3.502.211
CROSS 0,1 3.501.592
FUPARAREF 0,1 3.390.933
TADIR 0,1 3.169.587
DOKHL 0,1 3.128.791
T100 0,1 2.730.082
DOKIL 0,1 2.719.994
SEOSUBCO 0,1 2.544.111
SEOSUBCODF 0,1 2.539.460
TABLE GROUP ESTIMATED MEMORY ESTIMATED MEMORY
NAMES SIZE BEFORE CLEANUP SIZE AFTER CLEANUP
FI_DOCUMENT 16,1 12,8
BC_SBAL 13,9 0,3
BC_WORKITEM 11,7 11,7
BC_CHDO 6,8 0,5
BC_IDOC 5,8 0,7
STATUS 3,8 3,8
ACC_DOC 2,9 2,9
MM_MATDOC 1,2 1,2
SD_VBAK 1,0 1,0
LE_LIKP 0,3 0,3
MM_EKKO 0,3 0,3
DETAILED INITIAL SIZING PER COMPONENT MEMORY SIZE IN GB
Column Store tables: 73,2
- High cardinality: 1,7
- Med. cardinality: 0,9
- Low cardinality: 0,8
- Others: 69,9
Column Store keys: 56,2
- Primary keys: 43,7
- Row ID: 9,7
- Udiv: 1,8
- Secondary unique keys: 1,0
Row Store tables: 4,2
Row Store primary keys: 0,1
Row Store secondary keys: 0,2
LOB CS data stored on disk: 78,2
LOB RS data stored on disk: 6,4
Check SAP Note 1986747 for more information
LARGEST TABLES AGING LAST AGING
OBJECT RUN
BALDAT BC_SBAL
SWWCNTP0 BC_WORKITEM
CDPOS BC_CHDO
COEP
FAGL_SPLINFO_VAL FI_DOCUMENT
EDID4 BC_IDOC
ACDOCA FI_DOCUMENT
APQD
EDIDS BC_IDOC
FAGLFLEXA
COSS
DMS_CONT1_CD1
BSEG FI_DOCUMENT
JEST STATUS
JCDS STATUS
ACCTCR
DOKTL
FAGL_SPLINFO FI_DOCUMENT
LTEX
D010TAB
SWWLOGHIST BC_WORKITEM
BDCP2
BSIS
RORQSTPRMS
COSP
ACCTIT
DBTABLOG
CMFP
QASV
QAMV
LARGEST TABLES ARCHIVING LAST ARCHIVING
OBJECT RUN
BALDAT
SWWCNTP0
CDPOS
COEP
FAGL_SPLINFO_VAL
EDID4
ACDOCA
APQD
EDIDS
FAGLFLEXA
COSS
DMS_CONT1_CD1
BSEG
JEST
JCDS
ACCTCR
DOKTL
FAGL_SPLINFO
LTEX
D010TAB
SWWLOGHIST
BDCP2
BSIS
RORQSTPRMS
COSP
ACCTIT
DBTABLOG
CMFP
QASV
QAMV
