determine fast growing tables

[Former Member]

In DB02, I can see a table growth by month. However, in order to determine a set of tables that have the most growth, I'll need to get the inforamtion manually for each table. Does anyone have a sql query that can select the most growth tables via some SAP table, such as SNAP, etc. ?

We'll need to identify a set of tables that are fast growing for archiving.

Appreciate any feed back.

Jay

[former_member204746]

activate an SQL trace when executing DB02 and investigate results, you will find your tables.

[Former Member]

Jay,

I would recomend you need to maintain Excel sheet which is filled every week and calculate percentage growth for all tables week by week , possibly you will get exact tables you want