Post reply

DB Size Space Used vs. sp_spaceused for each table

  • December 4, 2011 at 6:30 pm

    #249209

    Hi,

    When right clicking on a database in SSMS and obtataining "space used = size - space available", that number does not match with the sum of "space used = data + index" by running sp_spaceused on each individual table in the database. Suggestions?

    Thanks

  • December 5, 2011 at 8:24 am

    #1416726

    Looks like sp_spaceused is the mechanism used to get space used/available at a database level. Still not sure why there is a discrepancy. Can't imagine system objects to take some much space. Thoughts anyone?

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply