SQL Server Performance Tuning and Optimization

SQH16 Troubleshoot SQL Server Performance Issues using Wait Statistics

11/21/2013

1:30pm - 2:45pm

Level: Intermediate to Advanced

Edwin Sarmiento

Managing Director

15C

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