sp_spaceused in sql server

Its a system stored procedure to check the free space in the database.
It provides details about the db size, free space, index_size, unused index_size, data size and reserved memory capacity.

Code Snippet

use master sp_spaceused

The above code snippet will provide you two result sets
1. General information like dbname,dbsize and unallocated space
2. Second result set will provide you info about index related information and reserved data.

Below query will provide the above information as a single result set.

Code Snippet

sp_spaceused 'DatabaseName'

Regards,
Venkatesan Prabu. J