Pour bénéficier d’une expérience Web optimale, utilisez Internet Explorer 11 ou version ultérieure, Chrome, Firefox, ou Safari.

Quest Database Training Days Fall Series

Interactive performance tuning sessions delivered by industry experts, Brent Ozar, Janis Griffin and Pinal Dave

Back by popular demand, the biggest names in database technology will again be providing hands-on database performance training. You’ll have another opportunity to learn from Microsoft Certified Master Brent Ozar, Oracle ACE Janis Griffin and Performance Tuning Expert Pinal Dave about the most challenging and in-demand topics for SQL Server and MySQL.

In this jam-packed 5-session lineup, here’s what we’ll be covering:

  • Indexing for edge case performance – when you really need to push the performance envelope
  • Top tips for MySQL performance tuning – a repeatable methodology for query tuning
  • Avoiding deadlocks with query tuning – learn how to work through tables in a consistent order
  • Top 3 execution plan mistakes and how to avoid them – learn what to believe and what to ignore
  • Demystifying CXPACKET and CXCONSUMER – cut through the confusion and learn what to do
  • …and more

Use the checkboxes to select the events you wish to attend, then complete the form to register.

Sélectionner vos événements


a la demande

Nov.

9

If you've managed database performance, you've likely encountered the wait types CXPACKET and CXCONSUMER. With so much conflicting advice on how to address these issues, it’s easy to make the wrong call—like setting MAXDOP to 1, which isn't always the right solution. In this session, Brent Ozar will guide you through what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and the steps you can take to fix it.

Topics that will be discussed include:

  • The role of CXPACKET and CXCONSUMER wait types in SQL Server
  • Understanding query parallelism and when it goes wrong
  • Best practices for managing and optimizing parallel queries
  • Practical solutions for resolving issues without compromising performance

Speaker:

  • Brent Ozar, Microsoft Certified Master

a la demande

Oct.

27

Speaker: Pinal Dave

Execution plans are the first-place database professionals go to tune their query, but they often provide misleading information. The science behind query optimization is knowing what to believe and what to ignore from the execution plan. You’ll learn the 3 biggest issues with the execution plan and tips and tricks to overcome them easily and efficiently to ensure better performance.

a la demande

Oct.

15

Deadlocks can be a significant challenge in SQL Server, causing delays and impacting overall performance. In this session, Brent Ozar shares his expert tips for fixing deadlocks. Learn why it’s crucial to handle tables in long transactions consistently and minimize the number of times you touch them. Brent will walk you through the process of rewriting a stored procedure that's experiencing deadlocking issues, providing practical insights to help you manage and resolve deadlocks effectively.

Topics that will be discussed include:

  • Understanding the causes of deadlocks in SQL Server
  • Best practices for managing tables in long transactions
  • Rewriting stored procedures to avoid deadlocks
  • Practical techniques for consistent and efficient query execution

Speaker:

  • Brent Ozar, SQL Server Performance Tuning Expert

a la demande

Sept

29

Oracle ACE Director Janis Griffin reveals how to simplify MySQL query tuning. See how to monitor and review the execution plan. Then, look at the table, column and index information to understand selectivity to find the driving table. Finally, find performance inhibitors. With her tips, you’ll perform MySQL query tuning quickly and easily.

Sélectionnez un ou plusieurs webcasts auxquels vous souhaitez participer avant de vous inscrire.

Veuillez patienter...

triangle-down check
En téléchargeant, vous vous inscrivez pour recevoir des e-mails marketing de notre part. Pour vous désinscrire, veuillez suivre les instructions figurant dans notre politique de confidentialité.

Site protégé par reCAPTCHA. Consultez les conditions d’utilisation et la politique de confidentialité de Google.