SQL Server Tranlog size

How are you monitoring your Transaction logs?

AppInsight on SQL?

Assuming AppInsight on SQL:

SELECT N.Caption, N.Ip_Address, app.DatabaseName, app.DatabaseSize, app.TransactionLogSize

  FROM [APM_SqlBbDatabaseAlertsData] App

  JOIN dbo.nodes n on app.NodeID = n.nodeid

  WHERE

    --If you need to exclude certain databases....they can be listed below

   app.Databasename Not IN ('master', 'tempdb', 'model')

  And

  app.TransactionLogSize > app.DatabaseSize

  Order BY app.DatabaseSize DESC