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.
You will learn:
- About Query processing tasks
- About Query wait events
- About performance tuning and troubleshooting