Post reply

Most hit table

  • July 31, 2006 at 12:33 pm

    #62567

    Is there a way to find out the most hit tables .The table that has the most IO ?

    Thanks for your help

     

     

  • August 1, 2006 at 2:43 pm

    #652660

    Create trace using Profiler for specific period of time with events tsql and SP.

    Then collect the trace data in table and check with like on textdata column.   

    This is one way to get clue,

    Hope this helps.

     

    Kindest Regards,

    Sameer Raval [Sql Server DBA]
    Geico Insurance
    RavalSameer@hotmail.com

  • August 2, 2006 at 5:07 am

    #652777

    Thanks Sameer that seems to be the way out of it

     

    Mike

  • August 3, 2006 at 12:19 pm

    #653180

    You can check the sysindexes table for the rowmodctr columns. It holds the data of the total number of inserted, deleted, or updated rows since the last time statistics were updated for the table



    Bye
    Gabor

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

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