Parallelism is a key factor in the performance of large queries. It allows SQL Server to perform a large operation quickly and yet at other times can appear to hinder performance. It is a complex topic that can often be difficult to troubleshoot and tune. This session will explain the how parallelism works, why it is good, and when it is bad. Some of the key takeaways will be:
Robert L. Davis is a Microsoft MVP, SQL Server 2008 Certified Master, an experienced DBA, evangelist, speaker, writer, trainer, and consultant. He is the Principal DBA with Outerwall, Inc. and consults part-time via SQL DBA Master. He has worked with SQL Server for more than 13 years, including recent stints as a Sr. Product Consultant and Chief SQL Server Evangelist for Idera Software, Program Manager for the SQL Server Certified Master Program at Microsoft Learning, and as a production DBA at Microsoft.