find out how much space is used in my transaction log

this query will provide you all the space used by all the database

DBCC SQLPERF (LOGSPACE)