Database Performance Tuning and Optimization

DPT09 Performance Tuning SQL Server Using Wait Statistics

11/19/2024

4:15pm - 5:30pm

Level: Intermediate

Thomas LaRock

Manager, Data Engineering

BlackLine

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:

  • Query processing tasks
  • Query wait events
  • Performance tuning and troubleshooting