Post reply

help in recognizing unused tables

  • June 22, 2010 at 2:03 am

    #1183126

    I know the ETLs and Reports that are used but i do not have any list of tables which are being referenced by them.

    No, I'm afraid you have some tedious detective work to do. You need to look through your SSIS package (or whatever mechanism your ETL uses) and find the names of tables, views, procs and functions. You need to do the same with your report definitions. When you're finished, you will have a list of tables that you can compare against the tables in your database and deduce which tables may not be being used.

    John

  • June 22, 2010 at 2:10 am

    #1183131

    @ John, this is my last option i know 🙂

    Really a tedious task for a lazy person like me.

    Anyways i am planning to write to the SSIS/RS team to provide me a list of tables they are using. Thereby narrowing down my scope 😀

    Cheers

  • June 29, 2010 at 7:36 am

    #1186370

    And when the time comes to actually start deleting the tables, I would rename them first, say saveTableName. Then if it is really needed it will be quite easy to get it back by just renaming it.

    Then after a sufficiently long time (1 year?) you can delete the save table.

    Steve

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply