Post reply

Calculating space consumed by the record

  • July 5, 2007 at 3:58 am

    #177331

    Hi,

            How to calculate the space consumed for a record in the table. I want to calculate the size based on a id. For all records having that id i want to calculate the space consumed.

    Thanks

      

  • July 5, 2007 at 5:03 am

    #717328

    for example if you are using a big int in your column and you have 1000 records.

    bigint storage size is 8 bytes so that would be

    8*1000 = 8000 bytes => 0.0076MB

    you will basically do the same calculation for all your columns and then sum them up to find the required size

    Everything you can imagine is real.

  • July 5, 2007 at 5:34 am

    #717338

    This you should have done during the capacity planning phase estimating the row size of each record and the table, database sizes. Anyways now you have given me a good task to script something. I shall post the query sooner.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

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

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