Analyzing the table growth

[Former Member]

Dears Colleagues,

I was wondering if we can pull the growth report for any user table in Sybase?

Business had a requirement, which demands them to analyse how a particular table had grown for the pat couple of weeks or months.

Perhaps we could set a script which does a sp_spaceused  of the tables on regular basis, which can be then used for drawing a report.

But how about the past records, How could I get that?

Please share your thoughts on this regard.

[former_member188958 · Accepted solution]

If you have database dumps covering that period, you could load the dumps somewhere (perhaps using the "archive database' feature to keep disk space needed to a minimum)
to run sp_spaceused.  This would give you the historical values for each dump instant.

[Former Member · Accepted solution]

Thanks Bret. Sounds tedious though.

DB02 T -codes, which I found googling. Would this be of any help for historics analysisi of tables? Do you have any idea about this T code.

Regards,

Ajith Prabahakaran

[victoria_normand · Accepted solution]

Hi Ajith,
Just to answer your cuestion about DB02 / DBACOCKPIT t-code . Yes it should help you. You have under Space tab > Tables and Indexes > the option Tables that will help you to analyze space of all tables or specific table, during a frame time, and shows you which are the largest and fastest growing tables, which tables might need to be reorganized regarding space reclaim and performance degradation.

You also have from Performance  > Tables option on the Database tab page that shows historical monitoring of table I/Os.

You don't have there the detailed space used by the table but it helps you to determine which tables are accessed the most, that have update operations and therefore may need to have statistics updated permanently, tables that will need reorganization due to space fragmentation, etc

HTH,

Regards
Victoria.

[JanStallkamp · Accepted solution]

Hi.

Regarding DB02: For SAP ASE this is a redirect to the DBA Cockpit

As Victoria described the screen Space -> Tables & Indexes -> Tables will give you a lot of information on table sizes. You can either look at the list of the fastest growing or changing or larges tables. Or you look for a specific table. What is important here: You can select the time window you are interested in and you can select a table in the result list. And in the details screen you can get a good overview about the growth/change of this specific table. And you can define your own custome charts! I've added some screenshots to show you how this can look like.

Best regards,

Jan