Performance Tuning with SQL Server Dynamic Management Views

Performance Tuning with SQL Server Dynamic Management Views

“Performance Tuning with SQL Server Dynamic Management Views” is available in ePub format. 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.


This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and “patterns” that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements including how to:

  1. Root out the queries that are causing memory or CPU pressure on your system
  2. Investigate caching, and query plan reuse
  3. Identify index usage patterns
  4. Track fragmentation in clustered indexes and heaps
  5. Get full details on blocking and blocked transactions, including the exact commands being executed, and by whom.
  6. Find out where SQL Server is spending time waiting for resources to be released, before proceeding
  7. Monitor usage and growth of tempdb

Table of Contents

  • Using Dynamic Management Objects
  • Connections, Sessions and Requests
  • Query Plan Metadata
  • Transactions
  • Indexing Strategy and Maintenance
  • Physical Disk Statistics and Utilization
  • OS and Hardware Interaction

Book Details

Author(s): Louis Davidson and Tim Ford
Publisher: Simple Talk Publishing
Format(s): ePub
File size: 1.72 MB
Number of pages: 214
Link: Download.

Leave a Reply