Space Usage

sys.dm_db_log_space_usage Returns space usage information for the transaction log. Column name Data type Description database_id smallint Database ID. total_log_size_in_bytes bigint The size of the log…

Running out of disk space in TempDB can cause significant disruptions in the SQL Server production environment and can prevent applications that are running from completing operations. You can use the sys.dm_db_file_space_usage dynamic…