Foglight TechValidate Infographic

In this session, experts discuss how to use SQL Server indexes to make your queries run faster.

Speaker: Brent Ozar

If you've managed database performance, you've come across the wait types CXPACKET and CXCONSUMER. You've seen a lot of conflicting instructions on how to go about fixing them, and you know that setting MAXDOP to 1 isn't the right thing to do. Learn what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and what you can do about it.

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.

Speaker: Janis Griffin

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.

Speaker: Brent Ozar 

The next biggest cause of deadlocks is working through tables in long transactions. You'll learn why you need to work through tables in a consistent order and touch them as few times as possible, then we'll rewrite a stored procedure that's having deadlocking problems.

One day you ‘accidentally’ became a SQL Server DBA… Now you are ‘accidentally’ a multi-platform DBA.  It can be overwhelming. 

What if you could…?

• Ease the transition to your growing and changing environment with consistent workflows regardless of the database platform

Got sunglasses?

Join Quest for an informative webinar

Is current database monitoring solution still struggling to provide answers on why you're having performance issues?