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