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.

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
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...

26
Jul
Webinar: Save up to 60% by upgrading to SQL Server 2017

Running on an older version of SQL Server and worried about not meeting compliance or falling out of support? We’ve seen that around 60% of existing SQL Server databases are running on versions of SQL Server that are out of support or extended support.   Upgrading to the latest version of SQL Server not only ensures you...