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:
- Query processing tasks
- Query wait events
- Performance tuning and troubleshooting