Data and Index size in MSSQL 2008 R2

This topic contains 1 reply, has 2 voices, and was last updated by Avatar Ossian 3 months, 3 weeks ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Avatar
    BumbleBee
    Participant
    #625285

    Hi,

    In the “Disk usage by top tables” I see Data (KB) and Indexes (KB) columns.
    Does the Data (KB) include the Indexes size?

    Thanks

    Avatar
    Ossian
    Moderator
    #625319

    AFAIK the data size does not include nonclustered indexes – the two should add up to the total space used – however I do not have a SQL server handy to check.
    If you look at the screenshots here https://raresql.com/tag/disk-usage-by-top-tables/ it seeems to confirm that – reserved space is approx data + indexes (+ metadata)

    • This reply was modified 3 months, 3 weeks ago by Avatar Ossian.
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.