Back To Schedule
Tuesday, October 1 • 3:00pm - 4:00pm
Run Query Run - Wait Stats Reborn (SQL Server 2017 Cloud Version)

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
SQL Server Wait Statistics and Queues subject was introduced in the year 2005. Since every single DBA and Developers have spent countless hours learning about wait stats. However, there are quite a few new DBAs and Developers in the last 10 years often wonder how they can get started with SQL Wait Statistics so they can be as proficient as experienced DBAs. In this session, we will see how we can learn the to various tricks derived from SQL Server Wait Statistics which can help us run our queries faster. We will focus on new Wait Statistics features introduced in SQL Server 2017 on-premises and Azure to tune our queries so they can run faster. Besides the most popular malign wait statistics, we will cover following important topics in our session a) Impact of Enabling Query Wait Stats b) New Session Level Wait Statistics c) New CPU wait types introduced in SQL Server 2017 d) Significance of Auto-Tuning e) Waits for Adaptive Joins After all, don't we all want to run our queries at flash speed!

avatar for Pinal Dave

Pinal Dave

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4100 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years... Read More →

Tuesday October 1, 2019 3:00pm - 4:00pm CEST
Room 10