Post reply

How to know which tables are frequently get updated

  • June 11, 2009 at 12:18 am

    #135090

    Hi,

    We have sql server 2000 and 2005 servers. Recently, I noticed that the size of 2 databases is rapidly increasing. Iam using a script to get database size, used space, free space. But I want to know in those 2 databases which table are updating and increasing in size?

    How can you guys monitor this table growth and database growth?

  • June 11, 2009 at 12:33 am

    #1007794

    Hi.

    This might help

    --

    --SQL Server 2005

    SELECT [Name], Create_Date, Modify_Date

    FROM sys.objects

    WHERE [type] = 'P' and [Name] = ''

    --SQL Server 2000

    select specific_Catalog,specific_name,created,last_altered

    from information_schema.routines

    WHERE

    Routine_Type='procedure'

    AND specific_Catalog='database'

    --

    Tanx 😀

  • June 12, 2009 at 3:23 pm

    #1008918

    Better use a script to cature rowcount of all user tables in a central table for few days and then compare the difference in rowcount. Those with too many row differences in short interval would be of intrest to you.

    HTH!

    MJ

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

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