SQL Server Performance Tuning and Optimization

SQH20 SQL Server Query Performance Tuning: A 12-Step Process


3:00pm - 4:15pm

Level: Intermediate

Scott Klein

Data Platform Technical Evangelist


Performance tuning is complex; it's hard to know which knob to turn or button to press that will give you the biggest performance boost. If you have ever been handed a query and told to "make it go", these 12 steps will help you break down performance tuning easy to digest pieces that anyone can accomplish. You will learn what actions to take when you get back to work and are handed a query to tune for the first time.

You will learn:

  • Steps involved in the query tuning process
  • How to read an execution plan
  • Tips and tricks for writing faster queries