SQL Server Performance Tuning and Optimization

SQW02 Getting Started with Query Tuning

11/15/2017

8:00am - 9:15am

Level: Intermediate

In this session you will learn the basics of how to tune queries in a SQL Server environment, through a demo-heavy and technique focused session. You will learn how to read an execution plan, and gain knowledge of techniques to improve query performance and throughput.

You will learn:

  • How to read an execution plan
  • Why SQL Server chooses the operators it does, and which ones are fastest
  • About getting information from the Query Store