Checking Information for a Table and Its Indexes

Include the parameter 1 (one) and the table name to view information about the space used by individual indexes.

For example:

sp_spaceused titles, 1

index_name           size       reserved   unused
-------------------- ---------- ---------- ----------
titleidind           2 KB       32 KB      24 KB
titleind             2 KB       16 KB      14 KB
     
name       rowtotal   reserved   data   index_size unused
---------- --------  ---------  ------- ---------- ----------
titles          18      46 KB     6 KB      4 KB      36 KB

Space taken up by the text/image page storage is reported separately from the space used by the table. The object name for text and image storage is always “t” plus the table name:

sp_spaceused blurbs,1

index_name           size       reserved   unused
-------------------- ---------- ---------- ---------- 
blurbs               0 KB       14 KB      12 KB
tblurbs              14 KB      16 KB      2 KB

name       rowtotal reserved    data    index_size unused
---------- -------- ----------- ------- ---------- ---------- 
blurbs            6       30 KB    2 KB      14 KB      14 KB