Find Total Allocated Space for Database

  • How to find total allocated space for each database in a server?

  • sp_spaceused gives you this sort of info:

    database_name database_size unallocated space

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

    xxxxDB1 2.13 MB 0.18 MB

    reserved data index_size unused

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

    968 KB 408 KB 432 KB 128 KB

    also look at

    sp_helpdb and sp_helpfile

    HTH

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

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