In SQL server to check transaction log file size you can simply run this dbcc sqlperf(“logspace”) . This query will provide you the transaction log usage statistics for all the databases.   The other way round is to run this DMV query which will provide you the usage for the selected database. Note,this will provide you