SQL Server DMVs in Action


 * 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/