SQL Server Performance Tuning and Optimization

SQTH01 Performance Tuning SQL Server using Wait Statistics


8:00am - 9:15am

Level: Introductory to Intermediate

Thomas LaRock

Manager, Data Engineering


In this session we will learn how the SQL Server engine processes queries. We will dive into common wait types, causes, and remedies using wait time response analysis. Attend this session and leave with the knowledge of how the SQL Server engine works, and what knobs you can turn to improve performance.

You will learn:

  • About Query processing tasks
  • About Query wait events
  • About performance tuning and troubleshooting