For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Database Training Days 101: Top Five SQL Server Query Tuning Tips with Janis Griffin

Do You Feel the Need … the Need for Speed? Top Five SQL Server Query Tuning Tips
On Demand
  • Recorded Date:Apr. 15, 2020
  • Event:On Demand
Do You Feel the Need … the Need for Speed? Top Five SQL Server Query Tuning Tips

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

Watch Your Free Webcast

Please wait...

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.