O'Reilly logo
  • Dustin Waybright thinks this is interesting:

index_type_desc  page_count  record_count  avg_page_space_used_in_percent
---------------  ----------  ------------  ------------------------------
HEAP             1           1             3.24932048430937

name           rows  reserved  data  index_size  unused
-------------  ----  --------  ----  ----------  ------
TestStructure  1     16 KB     8 KB  8 KB        0 KB

The table occupies one page with one row.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

In this average page space used check, you can see the table only has 1 row, thus the low fragmentation. If there were many pages and only 3% usage, it would be a potential resource efficiency issue.