The Query Store feature was introduced in SQL Server 2016 and it’s a game-changer for data professionals. Have you ever…
If so, then this is the course where you learn how to stop reacting and start making Query Store work for you.
Query Store allows you to proactively monitor query performance and find those queries that are currently causing problems, or have the potential to cause problems. In addition, you can stabilize query performance use plan forcing, whether that’s something you do manually or automatically with Automatic Plan Correction. Beyond the basics, you’ll see demos that teach you how to interrogate the data to find common patterns in query performance using T-SQL and visualization techniques, and how to take advantage of the wait statistics information captured. After this class you will have the skills to find and leverage important information in Query Store to make query tuning easier.
This class is delivered live via online streaming. By 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!
Instructor: Erin Stellato.
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 or combo from the drop-down menu at the top of the page.
If you have any questions, please contact us.