Post reply

Messure table activity

  • February 23, 2009 at 12:17 pm

    #72436

    Hello

    I'm new in a small company, but i have seen there's a big database with around 1000 tables, however I know they use it in a internal system design ad developed by them. My problem is that there're a lot of tables with no link,unusued tables or any descriptive name and i want to delete those tables without affect the system. Is there a way to know how many insertes,updates, or general activity a table has???

    i dont have access to the system sourcecode

    Thanks

  • February 23, 2009 at 12:53 pm

    #948888

    You could find that from the log files, if you can get a parser. Another way to get it might be a server trace.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • February 23, 2009 at 1:24 pm

    #948925

    If this is 200 there is column rowmodctr in sysindexes which tells you the no. of updates , inserts, deletes since last stats update.

    Of course that leaves selects!

    Otherwise a server trace seeems best, either filterd by objectid or search for the tabename afterwards.

    But how do you know table is not used just once a month or once a year?

    ---------------------------------------------------------------------

  • February 23, 2009 at 4:46 pm

    #949074

    thanks i will try at least with rowmodctr and i will cooment my results

Viewing 4 posts - 1 through 4 (of 4 total)

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