IEQS: Immersion Event on Solving Common Performance Problems with Query Store

Live Online: May 22-24, 2018


Overview

The Query Store feature was introduced in SQL Server 2016 and it’s a game-changer for data professionals.  Have you ever…

  • …had that emergency where you’re informed “The database is slow! It was fine yesterday! Nothing changed!”?
  • …wished for a query’s baseline metrics so that you could quickly compare pre- and post-upgrade performance?
  • …flailed about querying DMV after DMV to figure out the *real* problem with performance?

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.

Instructor: Erin Stellato.

For a detailed agenda click HERE.

If you need help justifying training to your organization, we can help you:

Select Quotes From Past Attendees of Erin’s SQLskills Classes

  • “Extremely pleased with the course. FAR exceeded my expectations.”
  • “Well worth the time and expense to attend. Would highly recommend this to others.”
  • “I though this was extremely worthwhile. I have been a DBA for a few years and this was a great refresher for a lot of things I don’t do very often but should.”
  • “Found class extremely helpful and plan to take the next one.”
  • “Great course – very informative – very great instructors – I am sure to be back!”
  • “I was familiar with all of the topics in this course, but barely understood most. I feel I will be able to begin to do all of the things I need to take simpler tasks from our DBAs to allow them to focus on the more advanced tasks. That was exactly my goal for taking this class.”
  • “Great course. Good new info for me, plus refresher on other info. Thanks!”
  • “Both Erin and Jon have a vast knowledge of not only SQL Server & tools, but also effective presentation.”
  • “Thanks for taking the time to better my knowledge of SQL and allow me to better my career.”

Event details:

  • The class will be streamed live through three WebEx meetings and you will receive an email invitation to the WebEx meetings during the week before the class. You will be prompted to download the WebEx application when connecting to the first meeting. Note: your name will appear on the WebEx participant list in the event recordings.
  • Class will be spread over three days, from Tuesday, May 22nd, 2018 through Thursday, May 24th, 2018.
  • Detailed agenda for each day (all times are in Pacific Standard Time)
    • 10am to 11:30am: morning session
    • 11:30am to 12pm: morning Q&A
    • 12pm to 12:30pm: break
    • 12:30pm to 2pm: afternoon session
    • 2pm to 3pm: afternoon Q&A
  • You will receive a PDF of the lecture content. Additionally, after the event ends, we will provide all possible demo content and any electronic whiteboard slides on our website as a zip file.
  • The class will be recorded and you will receive streaming access to the recordings for six months, including all audio and video, plus the chat window questions in real-time.

Pricing details:

  • Full price for this online Immersion Event is US$795.
  • Past attendee price: If you’ve attended a live, online Immersion Event in the past, you can register any time for US$695. Please contact us for instructions.

Cancellation/transfer policy:

  • Your class registration can only be canceled up to 1 calendar week before the day the class begins, and the cost will be refunded minus a US$50 administration fee (and 5% credit-card processing charges).
  • Registrations can be transferred to a colleague to attend the class, up to one day prior to the first WebEx meeting and at no cost, as long as we are notified of the new attendee’s name.
  • A no-show registration (the attendee does not attend the class) is not eligible for a transfer or refund.

Registration details:

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.

Questions?

If you have any questions, please contact us.