How to find Content Server data store

[SAPSupport]

Hello Team,

We have ECC 6 with EHP 7 SP12 system and one Content server (Database is MaxDB). 

All the PDF, JPG files are stored into Content server this is working since last 5 yeas, now we have a new requirement to store all other data also move to Content server, for that management is asking us, month wise how much data will be store into Content server and what will be size of each document.

We found the table TOA01 tables, which is show number of data store into Content server, but we are not able to find the size of the data. 

Please help us, is there any query in ECC end to get the data as well as size of each document. 

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear,

To check the database size of the Content Server, you can refer to 3582379 - How to check the MaxDB Database Growth History used for SAP Content Server.

The size of the document can be calculated from the SAP Content Server database, however the search may take a significant amount of time.

To find the largest document in the components table, you can use the following SQL statement:

select length(long_value), name from <component_name> where length(long_value) = (select max(length(long_value)) from <component_name>)

The returned value represents the size of the document in kilobytes (kB). If you want to obtain the size in megabytes (MB), you can execute the following command:

select ceil(length(long_value)/1024) DocSzMB, name from  <component_name> where length(long_value) = (select max(length(long_value)) from <component_name>)

Additionally, if you need to retrieve documents ordered by size, you can use the following command:

select ceil(length(long_value)/1024) DocSzMB, name from <component_name> order by (length(long_value)) desc

Please be aware that executing this query on large databases may result in a long processing time！

Best regards,
SAP Support