SQL Server Performance

table and index size calculation

Discussion in 'General DBA Questions' started by contactjimmyus, May 12, 2009.

  1. I am optimizing the index and space utilization
    I have run sp_space used on a table and the output is attached
    Name Rows reserved Data Index size Unused
    RskCalB_Invoices_Save 43501427 26325208 KB 4704472 KB 2746120 KB 18874616 KB
    I need an interpretation of the out put .Is it meens that the total size of the table is 4.7 gb including 2.6 gb of index size ?What is ment by reserved and unused represents in the output...
    Thanks a lot


  2. MohammedU New Member

    Data + Index size + Unused = 26325208
    4704472 + 2746120 + 18874616 = 26325208
    Reserved - amount of total reserved space for the table
    Data - amount of space used by the data for the table
    Index_Size - amount of space used by the table's indexes
    Unused - amount of usused space in the table
  3. So as per the data 26 gb is allocated for this table and 18 gb is not used ,the actual data and the index comes to 6 gb.The allocated space will add up to the database file size
  4. Sandy New Member

    Adding to All, You can also check this as references.Thanks,
    Sandy.

Share This Page