This 100-300 level, live, online training course will give anyone that works with SQL Server a better understanding of how to analyze and troubleshoot poor query performance. The first problem people tend to have is understanding where to find performance data and how to evaluate a query’s plan. To understand this better, Erin will spend the first day showing how to capture query information, and then how to evaluate, understand, and analyze the many aspects of a plan’s performance. But, what is the real problem? Is it caching? Is it inefficient code? Is it statistics? On the second day, Jonathan will focus on common but ineffective query patterns that lead to performance problems as well as better solutions to handling them. And finally, on the last day, Kimberly will show you how to tell if your query problems are because of caching problems or because of statistics.
With techniques to determine your query’s actual problem and the many possible solutions for solving them, if you work with SQL Server in almost any capacity but just don’t know how to dig into query performance – this class is for you! And, while there are still other potential problems that can occur, dedicating only 3 half-days of your time for 9 hours of lecture and up to 4.5 hours of open Q&A, this is an amazing ROI while you can still get work done during your day! Spend some time with us so that we can help you tackle many of the most common and problematic scenarios that often plague SQL Server systems.
This class is delivered live via online streaming.
For a detailed agenda click HERE.
If you need help justifying training to your organization, we can help you:
Click HERE to go to our events registration page, and please make sure to select the correct class from the drop-down menu at the top of the page.
If you have any questions, please contact us.