Davidson Louis. Performance Tuning with SQL Server Dynamic Management Views

Simple Talk Publishing, 2010. — 326 p. Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA’s troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.