-Find longest running transaction and identify the SPID
-Shows the query being processed so you can assess whether it is safe to kill
-More info about SPID
DBCC SQLPERF ( LOGSPACE )
-Shows log size and Log Space used
-Shows log and database file locations, growth and size.