Practical SQL Server Performance Monitoring & Optimization
Developers can dramatically improve performance by monitoring and analyzing real world queries. This session covers SQL Server monitoring at various levels to the most impactful performance improvements. The presentation will start with an overview of different optimization tools and techniques and will be based on practical examples of real-world performance monitoring and troubleshooting. Details include the use of server monitoring tools, SQL Profiler, the Database Tuning Advisor, and analyzing query plans, Dynamic Management Views, and related methods. The overall emphasis will be on solving practical, real-world database performance problems.
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
- Server Performance 1 Recording