Transactional Log file used space monitoring

Following is the T-SQL script to monitor the transactional log file. It specifies the size of log file and how much is being used out of it and also calculates the percentage of use. Also gives information on log file growht and size limit and mentions what it is waiting to reuse the log file.

--//-------------------------------------//-- 
--// Credits http://sqlgear.blogspot.com //--
--//-------------------------------------//--
DECLARE @LogFilePercentUsed INT

SET @LogFilePercentUsed = 60 --//Modify the value here to set the threshold

SELECT db.NAME
 ,db.log_reuse_wait_desc
 ,ls.cntr_value / 1024 AS SizeMB
 ,lu.cntr_value / 1024 AS UsedMB
 ,(CAST(lu.cntr_value AS FLOAT) / CAST(ls.cntr_value AS FLOAT)) * 100 AS UsedPercent
 ,@LogFilePercentUsed AS Threshold
 ,CASE 
  WHEN (CAST(lu.cntr_value AS FLOAT) / CAST(ls.cntr_value AS FLOAT)) * 100 > @LogFilePercentUsed
   THEN CASE 
     WHEN db.NAME = 'tempdb'
      AND log_reuse_wait_desc NOT IN (
       'CHECKPOINT'
       ,'NOTHING'
       )
      THEN 'WARNING' --//tempdb special monitoring
     ELSE 'WARNING' --//all other databases, monitor for the given fill case
     END
  ELSE 'OK'
  END AS LogStatus
 ,CASE 
  WHEN mf.max_size = - 1
   THEN 'Unrestricted'
  WHEN mf.max_size = 268435456
   THEN 'Upto 2 TB'
  WHEN mf.max_size = 0
   THEN 'Disabled'
  ELSE CAST(mf.max_size / 128 AS CHAR(5)) + 'MB'
  END AS MaxMB
 ,mf.growth AS Growth
 ,CASE mf.is_percent_growth
  WHEN 1
   THEN 'Percent'
  ELSE 'MB'
  END AS GrowthBy
FROM sys.databases db
JOIN sys.dm_os_performance_counters lu ON db.NAME = lu.instance_name
JOIN sys.dm_os_performance_counters ls ON db.NAME = ls.instance_name
JOIN sys.master_files mf ON mf.database_id = db.database_id
 AND mf.type_desc = 'LOG'
WHERE lu.counter_name LIKE 'Log File(s) Used Size (KB)%'
 AND ls.counter_name LIKE 'Log File(s) Size (KB)%'
ORDER BY UsedPercent DESC