Query tuning is essential for achieving peak performance in SQL Server databases, yet many developers and DBAs struggle to identify the root causes of performance issues, often spending excessive time trying to resolve them. In this on-demand session, you'll discover proven best practices for tuning SQL statements and addressing other issues by leveraging Wait Time Analysis, reviewing execution plans, and applying SQL diagramming techniques. Additionally, real-world case studies will demonstrate the effectiveness of these practices.
Regardless of the complexity of your database or your skill level, this systematic approach will guide you to the correct SQL performance tuning path, eliminating guesswork and saving countless hours in query tuning and database optimization.
Topics that will be discussed include:
- Effectively using wait types to quickly identify bottlenecks and determine the best tuning approach
- Quickly identifying inefficient operations through query execution plan reviews
- Applying SQL diagramming techniques to find the optimal execution plan
Speaker
Janis Griffin
Senior Database Administrator, SQL Performance Expert