Learn how the database engine processes a query and how to query wait statistics information through various SQL Server dynamic management views (DMVs). I will show you how Query Store (QS) create and gather metrics to build your own baselines.
Next, I will talk about Wait Types, dives into specific waits, the causes, some examples, and resolutions. I will break down waits into categories by CPU, IO, backups, locks, latches, high-availability and disaster-recovery, preemptive, background and miscellaneous, and In-Memory OLTP. I will show you how QS can find it in minutes!
This is a maximum demo session with minimum theory but it based on 25 years of experience and hundreds of lectures in tuning area including latest's version SQL Server 2022!