The DBA Fundamentals VC offers training and support to individuals interested in a solid DBA foundation.
Next Meeting

Tue, Sep 08 2015 12:30 (UTC+10:00) Brisbane


SQL Server Performance Tuning: Controlling Parallelism

RSVP: https://attendee.gotowebinar.com/register/5640490620784338177

SQL Server Performance Tuning: 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.


Robert is a SQL Server Certified Master, MVP, and experienced DBA, evangelist, speaker, writer, and trainer. He has worked with SQL Server for 15+ years. He recently worked for Outerwall, Idera Software, and Microsoft. He served as PM for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft. He currently works as a principal database architect at DB Best Technologies. Robert is co-founder and co-leader of the PASS Security Virtual Chapter.

PASS SUMMIT 2015 

- 10/26/15 - 10/30/15 -  

Use Discount Code VC15GBQ6

SAVE $150.00

 

JOIN PASS then add our Virtual Chapter to your list

Please join this chapter by creating a user account.  This can be accomplished by clicking here.  All registered users will be emailed detailed instructions prior to each meeting.  Thanks!  


Be a Speaker!

Share your knowlede and skill, become a speaker.  If you would like to speak at a future DBA Fundamentals event, please send us an email and we'll get back to you.  We are looking for professionals with level 100 presentations in a wide variety of database administration topics.  We look forward to hearing from you!!

 

Email:  present@dbafundamentals.com