Cricinfo scores widget

International Scores: Get the latest scores of all the international cricket matches from Cricinfo. Add the Cricinfo International Scores widget now!

How to find MSSQL transaction log size

What is MSSQL transaction log :

Transaction log is basically used to write the transactions before committing them to database.  Never know the usage till now, even though used this term lot of times.

Why we need to know about the transaction log size.

Because this log file will grow and most of us are not aware of how much is being used and how much is left. So if the transaction log is full, the application using the database will not be able to write or read from it.

How to find the size. 

Simple. Connect to MSSQL studio and execute 'dbcc sqlperf(logspace)' .
Columns to look at is Log Size (MB)  and Log Space Used(%)

1.  Log Size (MB) - Current total log size for that table in MB.
2 . Log Space Used(%) - This will tell the used percentage with respect to the allocated/max size.

If some thing is greater than 90%, then probably you have to think of shrinking the log file or extending the MAX/allocated size.

Any other way to find this.

Connect to MSSQL studio, select the databases -->> right click --> Properties -->Files .

-Krishna.