webinar: SQL Server performance tuning by controlling parallelism

Parallelism seems like it should be one of those things that the query engine takes care of for us, but it does require some care and tending from time to time. The default server configurations are no longer adequate for controlling parallelism, and DBAs need to know how to tweak the settings to make it run optimally. When parallelism goes awry, it can cause severe performance problems. Sometimes only for a specific query, sometimes it can hurt performance server-wide. To add a little complexity to the mix, parallelism can also be controlled by query hints and Resource Governor. Understanding how these three options for setting the Max Degree of Parallelism interact and who wins when they conflict is critical in being able to understand how to control it.

banner SQL Server Performance Tuning

This webinar was recorded on September 8, 2015 for the SQL PASS DBA Fundamentals Virtual Chapter by Robert Davis (@sqlsoldier).

Tell us a little about you first

RELATED RESOURCES

26
Sep
Snack Bite: Top 3 reasons to run SQL Server 2017 on Linux

In this 9-minute snack bite video, Bill Ramos talks about the top three reasons why you’d want to consider moving from existing versions of SQL Server running on the Windows platform to SQL Server 2017 on Linux....

26
Jul
Webinar: Top 3 reasons to run SQL Server 2017 on Linux

In this 52-minute webinar recording, Bill Ramos talks about the top three reasons why you'd want to consider moving from existing versions of SQL Server running on the Windows platform to SQL Server 2017 on Linux. You'll learn how SQL Server 2017 on Linux meets your enterprise high availability, performance, and security requir...