The following examples use the catalog view sys. Database_files and the dynamic management view sys. Dm_db_file_space_usage to return size information for the tempdb database.