<p>We're working with a fixed transaction log size on our databases, and I'd like to put together an application to monitor the log sizes so we can see when things are getting too tight and we need to grow the fixed trn log. </p>

<p>Is there any TSQL command that I can run which will tell me the current size of the transaction log, and the fixed limit of the transaction log?</p>

A quick google search revealed this:
```
```
DBCC SQLPERF ( LOGSPACE )
```
```
Why aren't you using autogrowth on the transaction log?  It seems like this would be a more reliable solution.