Database Performance Tuning and Optimization

DPH08 Performance Tuning SQL Server Using Wait Statistics

11/20/2025

2:30pm - 3:45pm

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.

Streaming and Event Data Techniques The need for real-time analytics is growing as more and more companies embrace Microsoft Fabric’s Real-Time Intelligence to gain actionable insights from both structured and unstructured real-time streaming event data. Data Platform Live! has it covered with an introduction to Real-Time Intelligence and an all-day workshop on harnessing data in motion.

You will learn:

  • Understanding wait statistics
  • Understanding performance tuning options
  • Understanding how to track wait statistics for performance