Monitoring Databases  «Prev 

sp_spaceused for a Table

The following output is generated when running sp_spaceused on a table.
name       rows   reserved    data     index_size   unused 

---------- ------ ----------- -------- ------------ -------
Customer   230    48 KB       8 KB     40 KB        0 KB

  1. name is the table you are gathering information about.
  2. rows is the number of rows in the table.
  3. reserved is the total amount of space assigned to the table and its indexes.
  4. data is the amount of space used to store data.
  5. index_size is the amount of space used to store indexes.
  6. unused is the space assigned, but does not have any data stored on it.