We are sorry, the event "Partner University: Foglight DB + Evolve - Manage, Monitor, and Evolve Hybrid Datacenters " has already expired.
View expert tips for IT managers and IT architects. Get insights into agile development, DevOps and the cloud, and IT trends in a fragmented market.
Speaker: Brent OzarIf 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 DaveExecution 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: 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.
Got sunglasses?Join Quest for an informative webinarIs current database monitoring solution still struggling to provide answers on why you're having performance issues?
In this on demand session, we’ll demonstrate how Quest’s suite of SQL Server database management, monitoring and performance tuning tools can help customers keep uncertainty at bay in their SQL Server environment on-premises and in Azure.
Quest has the technology solutions your customers need to connect, manage and secure a remote workforce.