Level: Intermediate to Advanced
Have you ever scratched your head trying to figure out what is causing performance issues in your SQL Server databases? This session will uncover your SQL Server's performance issues by learning about wait statistics. You'll look at SQL Server wait statistics and how we can troubleshoot performance problems using this methodology—from finding the root cause to resolving the issues.
You will learn:
- What SQL Server wait statistics are
- The SQL Server query execution model and how it affects query performance
- How to identify and troubleshoot performance issues using SQL Server Wait Statistics