Dennes Torres Exploring Query Plans in SQL SQL Server keeps the most-used execution plans in cache, so it doesn't need to recompile the same queries every time.... 31 December 2014 15 min read
Timothy Ford Investigating Transactions Using Dynamic Management Objects There can be a great difference in the performance of a particular routine in a test database, and in a... 30 September 2010 39 min read
Louis Davidson Tim Ford DMVs for Query Plan Metadata Before you can tackle any performance issues with a working database, you need to know which queries to work on... 17 August 2010 57 min read
Louis Davidson Tim Ford Performance Tuning with SQL Server Dynamic Management Views This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need... 14 June 2010 4 min read
Eric Brown Troubleshooting with Dynamic Management Views If you work with SQL Server 2000, then you know how painful it is to triage a server that has... 12 April 2007 5 min read
