space used

  • The command sp_spaceused @updateusage = true

    returns following result. How do I have to calculate the single values that it gives me an equation:

    database size = data size plus reserved space minus etc.

    Somehow it is not clear to me how it is split up.

    Thank you

    mipo

    database_namedatabase_sizeunallocated space

    ------------------- -----------------------------------

    opms 3498.88 MB807.41 MB

    reserved data index_size unused

    ------------------ ------------------------------------ ------------------

    2479576 KB 1050720 KB 1344792 KB 84064 KB

  • Database size = MDF files size + LDF files size.

    Reserved = data + index_size + unused

    MDF files size = reserved + unallocated space

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

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