Waitstats for the accidental DBA
Proposed session for SQLBits 2026TL; DR
When SQL Server performance issues arise, finding, understanding and resolving wait statistics can be your secret weapon. This session explain wait statistics and provides actionable insights for improving query performance.
Session Details
Do you wear many hats at work and sometimes find yourself playing the role of a DBA? When SQL Server performance issues arise, finding, understanding and resolving wait statistics can be your secret weapon. This session explain wait statistics and provides actionable insights for improving query performance.
In this session, you will:
Learn what wait statistics are and why they matter.
Discover the most common wait types and what they reveal about your SQL Server's health.
Dive into real-world scenarios to identify and resolve common performance bottlenecks.
Gain tips to distinguish critical waits from those you can safely ignore.
Whether you're a developer, IT generalist, or accidental DBA, you’ll leave equipped with practical tools and knowledge to keep your SQL Server running smoothly.
Even though is goes about basics of wait statistics, it would be good to have the following knowledge.
A basic understanding of SQL Server concepts
This session is aimed at accidental DBAs, Developers and other professionals who need to deal with SQL Server performance as part of their job.
In this session, you will:
Learn what wait statistics are and why they matter.
Discover the most common wait types and what they reveal about your SQL Server's health.
Dive into real-world scenarios to identify and resolve common performance bottlenecks.
Gain tips to distinguish critical waits from those you can safely ignore.
Whether you're a developer, IT generalist, or accidental DBA, you’ll leave equipped with practical tools and knowledge to keep your SQL Server running smoothly.
Even though is goes about basics of wait statistics, it would be good to have the following knowledge.
A basic understanding of SQL Server concepts
This session is aimed at accidental DBAs, Developers and other professionals who need to deal with SQL Server performance as part of their job.
3 things you'll get out of this session
Learn about what waits starts are, how to find them and how to start solving the most common ones.
Speakers
Peter Kruis's other proposed sessions for 2026
An introduction to Extended Events - 2026
From GUI to Scripting: PowerShell for the DBA - 2026
Query Store Basics: A DBA’s Best Friend - 2026
From Disarray to Hooray: SQL Server Functions That Simplify T-SQL - 2026
Two Developers, One Mission: Make a Test Database That Doesn’t Suck - 2026