cancel
Showing results for 
Search instead for 
Did you mean: 

BW Record Size Calculation

mohitsahu
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (10)

Answers (10)

mohitsahu
Participant
0 Kudos

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

RafkeMagic
Active Contributor
0 Kudos

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

mohitsahu
Participant
0 Kudos

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

mohitsahu
Participant
0 Kudos

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

RafkeMagic
Active Contributor
0 Kudos

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

mohitsahu
Participant
0 Kudos

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

mohitsahu
Participant
0 Kudos

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

RafkeMagic
Active Contributor
0 Kudos

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?

mohitsahu
Participant
0 Kudos

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

RafkeMagic
Active Contributor
0 Kudos

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, ...)