Post reply

Estimate single record growth size calculation

  • September 1, 2016 at 1:21 am

    #329708

    Hi.

    There is one table record counts are one month total = 199034556, so how can we estimate total estimate size of table?

    Per Record size 8KB, 199034556*8 = 1592276448KB, so per month estimate growth size 1.518GB. can we assume this calculation? Pl. suggest

    Thanks

  • September 1, 2016 at 4:54 am

    #1898721

    SQL Galaxy (9/1/2016)

    Hi.

    There is one table record counts are one month total = 199034556, so how can we estimate total estimate size of table?

    Per Record size 8KB, 199034556*8 = 1592276448KB, so per month estimate growth size 1.518GB. can we assume this calculation? Pl. suggest

    Thanks

    Use sys.dm_db_index_physical_stats to get the average "record" size and the % of page fullness. Not every "record" is going to be 8KB because you can likely get more than 1 per page.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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