Quest Database Training Days Fall Series

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

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.

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

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.