call us toll-free +1 855 855 3600
 
Home > Videos > SQL Server performance tuning by controlling parallelism

SQL Server performance tuning by controlling parallelism

 

Author: admin

 

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.

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