The following is a list of items that I have (so far) used in writing the book on dynamic management views.  There are such a lot of great material out there on the subject, I want to  share as many of the sources as I possibly could.

 

Not by any means complete (and it will never be in any real order), and I have a bit more to do with adding the name of the writer, but here for people who come here from my Devlink session or any other reason. 

 

1. Books Online

2. Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

 

3. SQL Server 2005 Waits and Queues
Tom Davidson
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc  

4. Dynamic Management Views and Functions (Gregory A. Larsen )
http://www.databasejournal.com/features/mssql/article.php/3608296

5. SQL Server 2005 Performance Dashboard Reports
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

6. Related Query Tuning Features
http://msdn2.microsoft.com/en-us/library/ms345577.aspx

 

7. How can SQL Server 2005 help me evaluate and manage indexes?

http://blogs.msdn.com/sqlcat/archive/2005/12/12/502735.aspx

 

8. SQL Server Performance Tuning And Optimization Glossary (Brad McGehee)
http://www.sql-server-performance.com/glossary.asp

 

9. The Table Scan From Hell (Hugo Kornelis)
http://sqlblog.com/blogs/hugo_kornelis/archive/2006/11/03/The-table-scan-from-hell.aspx

 

10. Fun for the Day – Automated Auto-Indexing
http://blogs.msdn.com/queryoptteam/archive/2006/06/01/613516.aspx

 

11. Why should I create an index?
http://blogs.msdn.com/queryoptteam/archive/2006/04/06/570176.aspx

 

12. Good Info about Non-Clustered Indexes
http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!546.entry

 

13. Troubleshooting Memory Issues in SQL Server 2005
http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!526.entry

 

14. Paul Randal on SQL Server 2005 Performance and Recovery 03/06/07
http://perseus.franklins.net/dotnetrocks_0217_paul_randal.pdf

 

15. It’s 3 AM. Do you know where your appdomain is?
http://blogs.msdn.com/sqlclr/archive/2006/02/22/536507.aspx

 

16. Database Administrator’s Guide to SQL Server Database Engine .NET CLR Environment
http://www.microsoft.com/technet/prodtechnol/sql/2005/clr4dbas.mspx

 

17. Troubleshooting Insufficient Disk Space in tempdb
http://msdn2.microsoft.com/en-us/library/ms176029.aspx

 

18. Query Execution Timeouts in SQL Server (Part 1 of 2)
http://blogs.msdn.com/sqlqueryprocessing/archive/2006/11/22/query-execution-timeouts-in-sql-server-part-1-of-2.aspx

 

19. Query Execution Timeouts in SQL Server (Part 2 of 2)
http://blogs.msdn.com/sqlqueryprocessing/archive/2006/11/22/query-execution-timeouts-in-sql-server-part-2-of-2.aspx

 

20. Estimating Query Costs by Brian Moran
http://www.sqlmag.com/Article/ArticleID/40663/sql_server_40663.html

 

21. Under the covers: IAM chains and allocation units in SQL Server 2005
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/25/under-the-covers-iam-chains-and-allocation-units-in-sql-server-2005.aspx

 

22. Using Asynchronous Statistics Updating in SQL Server
http://www.sql-server-performance.com/bm_asynchronous_statistics.asp

 

23. Microsoft SQL Server I/O Basics, Chapter 2
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQLIOBasicsCh2.doc

 

24. Cached query plans and top stored procedures that are recompiled
http://sqlserver-qa.net/blogs/perftune/archive/2007/05/11/cached-query-plans-and-top-stored-procedures-that-are-recompiled.aspx

 

25. Get statistics on Query plan optimizer execution
http://sqlserver-qa.net/blogs/perftune/archive/2007/05/11/get-statistics-on-query-plan-optimizer-execution.aspx

 

26. Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005
http://www.microsoft.com/technet/prodtechnol/sql/2005/recomp.mspx

 

27. 4.0 Useful Queries on DMV’s to understand Plan Cache Behavior
http://blogs.msdn.com/sqlprogrammability/archive/2007/01/23/4-0-useful-queries-on-dmv-s-to-understand-plan-cache-behavior.aspx

 

28. T-SQL text hashing in SQL Servers 2000 and 2005
http://blogs.msdn.com/sqlprogrammability/archive/2006/06/15/633108.aspx

 

29. 2.0 Sql_Handle and Plan_Handle Explained
http://blogs.msdn.com/sqlprogrammability/archive/2007/01/09/2-0-sql-handle-and-plan-handle-explained.aspx

 

30. SQL Server 2005 I/O Capacity Issues (Glenn Berry)
http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!564.entry

 

31. Using Bound Sessions
http://msdn2.microsoft.com/en-us/library/ms177480.aspx

 

32. "SQL Server 2005 Waiting and Blocking Issues" Sample Chapter By Ken Henderson.
http://www.samspublishing.com/articles/article.asp?p=686168&seqNum=3&rl=1

 

33. sys.dm_os_waiting_tasks on Slava Oks's WebLog
http://blogs.msdn.com/slavao/archive/2006/11/14/sqlosdmv-s-continue.aspx

 

34. beta_lockinfo (Erland Sommarskag)
http://www.sommarskog.se/sqlutil/beta_lockinfo.html

 

35. Understanding Row Versioning-Based Isolation Levels
http://msdn2.microsoft.com/en-us/library/ms189050.aspx

 

36. Managing Data Space (Kalen Delaney)
http://www.sqlmag.com/Articles/ArticleID/50009/pg/2/2.html

 

37. Transactions in MARS
http://www.sqlteam.com/article/multiple-active-result-sets-mars-transactions-and-debugging

 

38. What are the different cached objects in the plan cache?

http://blogs.msdn.com/sqlprogrammability/archive/2006/05/04/Ketan-Duvedi.aspx

 

39. Row Versioning Resource Usage
http://msdn2.microsoft.com/en-us/library/ms175492.aspx

 

40. SQL Server Database Devices (Kevin Cox, William Jones)
http://www.windowsitlibrary.com/Content/77/08/1.html

 

41. SQLOS's memory manager: responding to memory pressure (Slava Oks)
http://blogs.msdn.com/slavao/archive/2005/02/19/376714.aspx

 

42. SQL Server and NUMA Architectures
http://portal.sqltrainer.com/2007/04/sql-server-and-numa-architectures.html

 

43. SQL Server 2005 Resource Database Values in Dynamic Management Views\Functions (Chad Boyd)
http://www.mssqltips.com/tip.asp?tip=1181

 

44. SQLCLR appdomain usage
http://www.sqlskills.com/blogs/bobb/2004/11/21/SQLCLRAppdomainUsage.aspx

 

45. I Found my AppDomain, Now What?
http://blogs.msdn.com/sqlclr/archive/2006/02/23/537435.aspx

46. 1.0 Structure of the Plan Cache and Types of Cached Objects
http://blogs.msdn.com/sqlprogrammability/archive/2007/01/09/1-0-structure-of-the-plan-cache-and-types-of-cached-objects.aspx

 

47. Talking Points around Memory Manager in SQL Server 2005 (Slava Oks)
http://blogs.msdn.com/slavao/archive/2005/08/30/458036.aspx

 

48. SQLOS's memory manager and SQL Server's Buffer Pool
http://blogs.msdn.com/slavao/archive/2005/02/11/371063.aspx

 

49. Troubleshooting with Dynamic Management Views
http://www.simple-talk.com/sql/t-sql-programming/troubleshooting-with-dynamic-management-views/

 

50. What Query Plans are in SQL Server's Memory? (Bill Graziano)
http://www.sqlteam.com/article/what-query-plans-are-in-sql-server-memory

 

51. 2.0 Diagnosing Plan Cache Related Performance Problems and Suggested Solutions

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/21/2-0-diagnosing-plan-cache-related-performance-problems-and-suggested-solutions.aspx

 

52. Q and A: Clock Hands - what are they for?
http://blogs.msdn.com/slavao/archive/2005/11/20/495093.aspx

 

53. 5.0 Retrieving Query Plans from Plan Cache DMV’s
http://blogs.msdn.com/sqlprogrammability/archive/2007/01/12/5-0-retrieving-query-plans-from-plan-cache-dmv-s.aspx

 

54. Be aware: To Hyper or not to Hyper (Slava Oks)
http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx

 

55. A DMV a day keeps the Doctor away
http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!351.entry

 

56. Performance Impact of Querying SQL Server 2005 Scheduler-Related DMV's
http://sqlblog.com/blogs/linchi_shea/archive/2007/01/18/performance-impact-of-querying-sql-server-2005-scheduler-related-dmv-s.aspx

 

57. SQLOSDMV's Continue;sys.dm_os_waiting_tasks (Slava Oks)
http://blogs.msdn.com/slavao/archive/2006/11/14/sqlosdmv-s-continue.aspx

 

58. SQL Server Batch or Task Scheduling
http://msdn2.microsoft.com/en-us/library/ms189267.aspx

 

59. A look at Virtual Address Space – VAS (Slava Oks)
http://blogs.msdn.com/slavao/archive/2005/01/27/361678.aspx

 

60. Tracking VAS in Yukon, cont... (Slava Oks)
http://blogs.msdn.com/slavao/archive/2005/01/28/362423.aspx

 

61. Initialization of Mixed Assemblies
http://msdn2.microsoft.com/en-us/library/ms173266(VS.80).aspx

 

62. Monitoring Performance of SQL Server 2005 Objects (Tim Sneath)
http://blogs.msdn.com/tims/archive/2004/08/31/223434.aspx

 

63. Obtaining Statement-Level Query Plans (Stuart Ozer)
http://blogs.msdn.com/sqlcat/archive/2005/09/23/473367.aspx

 

64. RDTSC
http://en.wikipedia.org/wiki/RDTSC

 

65. Poking at SQLCLR (Bob Beauchemin)
http://www.sqlskills.com/blogs/bobb/2006/03/23/PokingAtSQLCLR.aspx