Skip to Content
avatar image
Former Member

Table space history and fastest growing tables in DB02

Hi All,

I have Windows SQL server.

Now i want to find out the Table space history for last one year,but in DB02 -->statistics i get the table space history but the sample dates are not of present.

All the DB collector jobs are running fine .

Can someone help me in finding the last one year table space history?

Also in DB02 in fastest growing tables i get only 16 tables.

Please help me in knowing how can i find out 100 fastest growing tables.

Thanks and regards

Tushar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 07, 2010 at 06:53 AM

    Hi,

    Note Note 1027512 - MSSQL: DBA cockpit for basis release 7.00 and later

    would address your problem.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2010 at 07:07 AM

    Hi,

    Please check this:

    RSMSSTABGROW MS SQL Server Display Top Growning Tables

    Regards,

    Sharib Tasneem

    Edited by: T.sharib on Sep 7, 2010 9:22 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2010 at 08:43 AM

    Hi Sharib,

    I am not clear what "RSMSSTABGROW" is?

    Can you please explain hoe to get the fastest growing tables using this.?

    Thanks and regards

    Tushar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      This is an ABAP report that you can run in the TX se38.

      Paste this report in program RSMSSTABGROW and execute this.

      This will give you the Top 25 Tables growing per Day/Week/Month.

      You can also see top "N" tables from the DB and also the table history.

      Regards,

      Sharib Tasneem

  • avatar image
    Former Member
    Sep 07, 2010 at 11:56 AM

    Hi Sharib,

    This program gives a dump in my enviornment.

    Is there any other way of finding the fastest growing tables?

    One more thing in DB02 space statistics i i get the data showing "Sample dates" which is not same for every table.

    Please let me know what this sample date means and why is it diffrent for all tables.

    Regards

    Tushar Pathak

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 08, 2010 at 12:34 AM

    FIRST OF ALL.....................

    MS SQL SERVER HAS NO TABLESPACE CONCEPT LIKE ORACLE...............

    work on SQL server database to find the data files and logs.

    You can resize data files as per your requirement.

    Also check if the Full backup was taken recently so that that log files are truncated.

    Add comment
    10|10000 characters needed characters exceeded