SQL Server Performance Monitoring & Optimization

Developers can dramatically improve performance by understanding how their queries are executing in the 'real world'. This session will cover ways in which attendees can monitor performance at various levels, and how they can use this information to optimize queries and improve overall application performance. We'll start with a discussion of developing a performance optimization strategy and how various tools can help. Then, we'll walk through the process of using SQL Profiler to collect data in a real-world case: Generating a 'hit list' of worst-performing queries based on execution times and frequency.

Next we'll look at using the Database Tuning Advisor to make suggestions related to physical database structures such as indexes and partitions. Also included will be ways in which built-in reports and dynamic management views can be used to monitor performance of production systems. Time permitting, the presentation will include methods for reducing deadlocks and managing long-running transactions. Finally, the presentation will include an overview of analyzing query plans. The overall emphasis will be on solving practical, real-world database performance problems.

• Anil Desai

  5 Recordings

  Anil Desai is an independent consultant based in Austin, TX. He has over 15 years of experience in architecting, implementing, and managing IT software and datacenter solutions. He has worked extensively with IT management, development, and database technology. Anil holds many technical certifications and is a ten-time Microsoft MVP Award recipient (most recently for Microsoft Hyper-V). Anil is the author of over 20 technical books focusing on the Windows Server platform, virtualization, databases, and IT management best practices. He is also a frequent contributor to IT publications and conferences. For more information, please see http://AnilDesai.net, or e-mail Anil@AnilDesai.net.

• Austin CodeCamp 22 Recordings

• SQL 28 Recordings