Sharing a query to get the usage sizing. Little easier than MS kb query.

use tempdb

SELECT sum(unallocated_extent_page_count) [Free_Pages], (sum(unallocated_extent_page_count)*1.0/128) [Free_Space_MB] FROM sys.dm_db_file_space_usage

Sharing a query to get the usage sizing. Little easier than MS kb query.

use tempdb
go;

SELECT sum(unallocated_extent_page_count) [Free_Pages],
 (sum(unallocated_extent_page_count)*1.0/128) [Free_Space_MB]
FROM sys.dm_db_file_space_usage;