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
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, ...)
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
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?
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
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
get the table with of your PSA table via SE11 > Extras > Table Width... => that will give you 1MB (or more) for one record
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
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
how about reading the help on those fields (via F1)?
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