historical information for table growth

[Patrice1]

Dear ALL

i am looking how to get historic of the growth of a table in HANA.

can you help?

thank you for your help

best regards

Patrice

Message was edited by: Tom Flanagan

[lucas_oliveira · Accepted solution]

Hi Patrice,

There are a few views in _SYS_STATISTICS schema that may be of help. Check the definition of GLOBAL_TABLE_PERSISTENCE_STATISTICS and HOST_COLUMN_TABLE_PART_SIZE here.

You can build your query on top of those (and probably others) to reach what you need. However, SAP Note 1969700 - SQL statement collection for SAP HANA - offers great queries for this purpose (and maaany other purposes) already (Big thanks to Martin!).

Take a look into queries below:

HANA_Tables_TopGrowingTables_Records_History

HANA_Tables_TopGrowingTables_Size_History

[]'s,

Lucas de Oliveira

[Former Member · Accepted solution]

Thanks, Lucas, for referencing SAP Note 1969700

In fact the best SQL statements for monitoring the historic growth of a specific table is SQL: "HANA_Tables_ColumnStore_TableSize_History" (if table is located in column store) or SQL: "HANA_Tables_RowStore_TableSize_History" (if table is located in row store). As usual the table name can be adjusted in the "Modification section" of the SQL statement.

SQL: "HANA_Tables_TopGrowingTables_Records_History" and SQL: "HANA_Tables_TopGrowingTables_Size_History" are more intended to determine the top growing tables in the whole system.

[Patrice1 · Accepted solution]

Hello

Thank you very much Lucas and Martin for your fast answer

i have what i want.

best regards

Patrice