This event has ended

SQL Saturday #291 Pre-Seminar: Better Performance Through Parallelism with Adam Machanic

Data Education

Friday, April 25, 2014 from 9:00 AM to 4:30 PM (EDT)

Addison, IL

SQL Saturday #291 Pre-Seminar: Better Performance...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Pre-Seminar Attendee Ended $150.00 $0.00

Share SQL Saturday #291 Pre-Seminar: Better Performance Through Parallelism with Adam Machanic

Event Details

 

Better Performance Through Parallelism

 

Today's server hardware ships with a truly massive amount of CPU power. And while SQL Server is designed to automatically and seamlessly take advantage of available processing resources, there are a number of options, settings, and patterns that can be exploited to optimize parallel processing of your data. This full-day seminar starts with an overview of CPU scheduler internals from the perspective of both Windows and the SQL Server Operating System (SQLOS). Next, you will learn about intra-query parallelism, the method that SQL Server uses to break up large tasks into many smaller pieces, so that each piece can be processed simultaneously. You will come to understand how to read parallel query plans and how to interpret parallel wait statistics, as well as best practices for the various parallelism settings within SQL Server. Finally, you will be introduced to techniques for exploiting parallelism at the query level: patterns that can help the optimizer do a better job of parallelizing your query. After attending this seminar, you will be in full control of your CPUs, able to compel your server to use every clock tick to your end users' advantage. 

This session is intended for mid-level to advanced DBAs and DB developers. 

Courseware booklets, lunch, and morning/afternoon coffee included.

 

Session Outline

 

Module 1: History and Theory

 

  • CPU evolution over time
  • Heat and dissipation
  • Moore’s Law
  • Amdahl’s Law
  • Gustafson’s Law
  • How this all fits together

 

Module 2: Windows Process/Thread Internals

 

  • Processes
  • Threads
  • Context switching
  • Quantums
  • Clock interrupts
  • Affinity

 

Module 3: SQL Server Scheduler Internals

 

  • SQLOS workers and schedulers
  • Waits and queues
  • Important DMVs

 

Module 4: Query Processor Parallelism

 

  • Parallel iterators
  • Non-parallel iterators
  • Row distribution strategies
  • How to read and mine data from parallel query plans

 

Module 5: Controlling Parallelism at the Query Level

 

  • Ideal parallel query patterns
  • Parallelism inhibitors and workarounds
  • The mathematics of "super-scaling" parallel queries

 

Module 6: Server Settings that Influence Parallelism

 

  • Affinity masks
  • Worker threads
  • MAXDOP
  • Cost threshold
  • Resource Governor
  • OLTP vs. OLAP vs. mixed workload considerations

 

Module 7: Monitoring Parallel Processes

 

  • Parallel task architecture and the Tasks DMV
  • Parallel waits and the Waiting Tasks DMVFinding out how much work is being done
    • CXPACKET
    • EXECSYNC
    • LATCH_EX
  • Finding parallel and serial plans in the cache

---------------------------------------------------------------------------------------------------------------------------------------

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive.

Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including SQL Server 2008 Internals (Microsoft Press, 2009) and Expert SQL Server 2005 Development (Apress, 2007).

Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

Have questions about SQL Saturday #291 Pre-Seminar: Better Performance Through Parallelism with Adam Machanic? Contact Data Education

When & Where


DeVry University--Addison
1221 North Swift Road
Addison, IL 60101

Friday, April 25, 2014 from 9:00 AM to 4:30 PM (EDT)


  Add to my calendar

Organizer

Data Education

Data Education is a full-service training company, specializing in courses targeting DBAs, developers, and business intelligence professionals. Data Education brings the experts in the database field to its students, from bestselling SQL Server authors to the nation’s premier business intelligence consultants.

  Contact the Organizer
Terms and Conditions: If Data Education cancels the course, you will receive a 100% refund. Registration is fully transferable. If you cancel your registration with more than 30 days notice, Data Education will refund the fee minus $35 for processing. If you cancel your registration with between 16 and 30 days notice, Data Education will refund 75% of the fee. If you cancel your registration with between 7 and 15 days notice, Data Education will refund 50% of the fee. Cancellations will not be allowed as of 6 days before the beginning of the course.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.