SQL Server Optimization for Developers

Abstract:

Database optimization is a critical component of overall application performance, and sub-optimal configurations can limit reliability, scalability, and the user experience. Unfortunately, many developers see database monitoring and optimization as a black art – something that’s better left to production and operations specialists. This presentation will focus on practical, real-world methods for monitoring and optimizing performance for SQL Server-based applications. Demonstrations will include understanding index types, capturing query data with SQL Profiler, analyzing indexes and using the Database Engine Tuning Advisor. In addition to live demos the content will focus on managing locking, managing schema changes, and application design best practices for developers.

Speakers:

  • 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.

Recorded At:

Recorded on:

Apr 14, 2014

More Info:

http://adnug.org/Home/april-14-2014-sql-server-optimization-for-developers/

Tags:

  • SQL 28 Recordings