Level: Intermediate to Advanced
Have you ever scratched your head trying to figure out what is causing performance issues in your SQL Server databases? In this session, we will look at uncovering your SQL Server's performance issues by learning about wait statistics. We will 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:
- The importance of SQL Server Wait Statistics in performance tuning and optimization
- About what wait statistics are
- To apply performance troubleshooting methodology using wait statistics