SQLConfiguration SQLConfiguration


Monitoring Databases  «Prev 

sp_spaceused for a Database

The following output is generated when running sp_spaceused without a table name parameter.

database_name      database_size      unallocated space  

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

pubs               2.00 MB            0.73 MB
 
reserved      data           index_size     unused         

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

1296 KB       472 KB         712 KB         112 KB

  1. database_name is the name of your current database.
  2. database_size is the total size of all files used in the database, include transaction log files.
  3. unallocated space is the total size that is not assigned, including all tables and indexes.
  4. reserved is the number of KB that is assigned to tables and indexes.
  5. data is the number of KB that has data.
  6. index_size is the number of KB that is used for index.
  7. unused is the number of KB that is assigned to data, but currently does not have any data stored on it.