Techorama Netherlands 2019

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!