Skip to Content
avatar image
Former Member

BW Record Size Calculation

Hello Guys,

I need to calculate the size of individual record from the data source which will help us to plan for the future growth in BW and also calculating the size.

Do anyone have an idea how we can calculate it?

Kind Regards,

MKS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Jan 11, 2017 at 01:35 PM

    get the table with of your PSA table via SE11 > Extras > Table Width...

    multiply this with the number of (expected) records and you'll have the max size of your table (the actual size depends on the actual values stored in each column, whether it's a row store or a column store table, if you're using indexes, ...)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 02:25 PM

    Hello raf,

    Thank you for the input.

    We have a scenario where we have multiple ERP productive clients and they are sending data record to the BW (on HANA) system. We are not going to have a project where we will have a new client in ERP system that will also start sending data to BW system.

    So we would like to first make a formula to calculate size of individual record and then plan accordingly for the data growth in BW.

    What you have provided is the 2nd step based on records. But i am interested in calculating the size of individual reocrd. (based on parameters or so on).

    Kind Regards,

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 11, 2017 at 03:13 PM

    I actually gave you both. I told you to "multiply" by the number of records, that only makes sense if you have the size of 1 record (table width), no?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 12:22 PM

    Hello Raf,

    No i think i did make you clear.

    What i am looking for is a formula.

    How i can calculate the size of record on basis of the filed and the attributes types.

    for example: i am having a table PSA table that has 80,000 records and now when i look into SE11 and its fileds using different type varchar, nchar etc etc. I would like to calculate this record on the basis of these fileds.

    Which will help us in future if we have a simmilar table then we can predict the growth on that basis.

    Kind Regards,

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2017 at 12:44 PM

    Hello Raf,

    One Step further i need to know :)

    I think i did not make you clear.

    I am looking for a solution to 'How we can calculate record size on the field and table character basis.'

    For example : I have a table which has 80,000 records. Now i would like to know how much size one record took and then

    how this record took this much space on the basis of its field like varchar, nchar etc etc.

    1 table 800 MB 800 record

    1 record 800/800 = 1 MB for one record

    then how this 1 MB is calculated from the filed characters and all.

    This will help in calculating in building future tables and its growth accordinly.

    Kind Regards,

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2017 at 10:52 AM

    get the table with of your PSA table via SE11 > Extras > Table Width... => that will give you 1MB (or more) for one record

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2017 at 10:59 AM

    I got the point but I want to know how this 1 MB size will be calculated from the table fields basis.

    varchar 8 Bit and so on..

    for example i create a table with 8 fields.

    Now i make a entry in this table. How this will be calculated.

    Kind Regards,

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2017 at 08:07 AM

    Hello Raf,

    In SE11 ---> Table Length option i see Dictionary and ABAP entries. Could you please tell me how i can calculate it further?

    I have 846 Records in this table and in SE11 i see Dictionary (Lenght of Data Part) is 1110 and ABAP is 1880.

    So now how i can calculate size of 1 record.

    Kind Regards,

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16, 2017 at 10:18 AM

    how about reading the help on those fields (via F1)?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2017 at 11:34 AM

    Hello raf,

    Yes i have read the information. But the calculation does not seems to be correct.

    I have taken a sample table which has 846 records and now for this i would like to calculate the individual record size.

    Estimated Maximum Memory Consumption (MB) 3MB*1024= 3072 KB

    in Main Storage 178,05 KB

    Delta Storage 2,83*1024= 2897 KB

    Size on Disk 1679 KB

    and in SE11 i get

    dictionary

    Structure width 1.136

    Key length 26

    Length of Data Part 1.110

    and for ABAP

    1900, 20 and 1880

    i have calculated 1136*846 = 961056 Bytes = 938 Kbytes

    But this value is not matching with value in DB02

    Kind Regards,

    Mohit

    Add comment
    10|10000 characters needed characters exceeded