Post reply

Somebody knows as I can know the rate of growth of a table

  • July 21, 2010 at 9:08 am

    #146306

    Somebody knows as I can know the rate of growth of a table in SQL SERVER 2005

  • July 21, 2010 at 9:30 am

    #1196249

    Hello,

    To determine growth rate of a single table, you'd have to setup a process to collect some history about the space used by the table. The rate would depend on the frequency at which you collect the space data.

    To determine the size of a table run the sp_spaceused stored procedure:

    Syntax:

    sp_spaceused [[ @objname = ] 'objname' ]

    [,[ @updateusage = ] 'updateusage' ]

    Reference: http://msdn.microsoft.com/en-us/library/ms188776(SQL.90).aspx

    Hope this helps.

    Best Regards,

    ~Rusty

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

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