Select
SUM (user_object_reserved_page_count)*8 as user_objects_kb,
SUM (internal_object_reserved_page_count)*8 as internal_objects_kb,
SUM (version_store_reserved_page_count)*8 as version_store_kb,
SUM (unallocated_extent_page_count)*8 as freespace_kb
From sys.dm_db_file_space_usage
Where database_id = 2
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2010/09/14/1825906.html
相关资源：如何查看SQLSERVER中某个查询用了多少TempDB空间