SQL Server DMVs in Action


 * SQL Server DMVs in Action
 * Better Queries with Dynamic Management Views
 * Ian W. Stirk
 * May 2011 ISBN 9781935182733 352 pages printed in black & white
 * https://www.manning.com/books/sql-server-dmvs-in-action

(chapters 1 and 3, and all the code is available for free):
 * chapter 1
 * chapter 3
 * source code

found through this article:
 * What SQL Statements Are Currently Using The Transaction Logs? - SQLServerCentral
 * http://www.sqlservercentral.com/articles/Transaction+Log/122600/