We are sorry, the event "SQL Server Tuning Tips #2" has already expired.
What is it about performance tuning that makes it so difficult? Solutions Consultant Gary Jerep will provide insight into why query and index optimization is so challenging. He’ll also demonstrate the Quest Software approach to tuning, so you can see ho
You’ll see how DBAs can better understand changes occurring to their database servers, as well as how DBAs can provide performance-focused dashboards to developers to enhance collaboration between teams
Azure DevOps is the go-to platform for Microsoft shops looking for a single-vendor solution for developing, testing, deploying and hosting their applications.
Query tuning is key for SQL Server performance. But root-cause identification and resolution can be challenging and time consuming.
Guidance on resolving the wait types CXPACKET and CXCONSUMER.
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.
Learn Brent’s tips to fix deadlocks. He’ll discuss tables in long transactions and why you need to work through them in a consistent order and touch them as few times as possible; then, he'll rewrite a stored procedure that's having deadlocking problems.