Check how many VLFs in Transaction Log File

We can use the following SQL Statement:

DBCC LOGINFO

Each record represent one VLF

2 means Active, 0 is inactive.

Please notice the column FSeqno: if =0 means 'never been used'.

Refer:

http://blog.sqlxdetails.com/transaction-log-truncate-why-it-didnt-shrink-my-log/

http://sqlblog.com/blogs/kalen_delaney/archive/2009/12/21/exploring-the-transaction-log-structure.aspx