A Deep Dive Into Waits-Based Performance Tuning with Eddie Wuerch
Friday, November 1, 2013 from 9:00 AM to 4:30 PM (EDT)
Start with a simple proposition: a process is either working or waiting. You can tune the working part, but are you seeing the whole picture? There are many different resources on which your process could be waiting – a lock, memory, disk, CPU, and much more. When a process must wait, SQL Server will log it. There are hundreds of different wait types, and they are a gold mine of data for finding and solving performance problems – and proving the changes worked. Eddie Wuerch takes his extensive experience as a speaker, trainer, mentor, and DBA in one of the largest and busiest SQL Server environments in the world and distills it into a collection of performance tuning topics for DBAs and developers tuning databases of all sizes. After attending this seminar, you will be able to gather wait stats and use them to zero in on performance issues affecting your databases. Stop guessing, start knowing!
Finding Performance Issues
- The Waits and Queues Method
- Monitoring File I/O and CPU Performance
A Survey of Performance Wait Types - What Do They Mean, and How to Use Them to Tune Performance
- I/O Wait Types
- Memory Wait Types
- CPU Wait Types
- Network Wait Types
- Locking/Blocking Wait Types
- Other Useful Wait Types
- Wait Types that don’t indicate problems (and can usually be ignored)
Putting It All Together – Whole-SystemTuning
Course Hardware and Software Requirements Included with the seminar are a collection of tuning and monitoring scripts and a printed copy of all presentations. Attendees will not need to bring laptops, but are encouraged to do so in order to they may try some of the techniques as they are presented.
Scripts, topics, and other content are applicable to SQL Server 2008 and up. Much will apply to SQL Server 2005. Differences in SQL versions as it applies to the material will be highlighted during the day.
About the Speaker Eddie Wuerch is a DBA, developer, trainer, and frequent conference speaker specializing in SQL Server for over ten of the twenty years he has spent in IT. Eddie is currently the tech lead of the DBA team at ExactTarget, a leading SaaS ESP located in Indianapolis. Eddie and his team design, manage, and tune the petabyte of 24x7 SQL Server database clusters that form the foundation of the ExactTarget application. He holds MCITP certifications in SQL Server 2005 and 2008 development and administration, and is a Microsoft Certified Trainer. He blogs occasionally at www.indydba.com and tweets as @eddiew
Refund Policy Cancelations requested before 10:00pm EDT October 18, 2013 will receive a 100% refund Cancelations requested between 10:00pm EDT October 18, 2013 and 10:00pm EDT August 5, 2013 will receive a 50% refund No refunds after 10:00pm EDT Monday, October 28.
To cancel your registration and request a refund, please refer to the contact info listed on your ticket/receipt.
When & Where
SQL Saturday #256
SQLSaturday is free a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Nov 2 2013 at Kalamazoo Regional Educational Service Agency, 1819 East Milham Ave, Portage, MI 49002. Admittance to this event is free, but we do charge a lunch fee of 10.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleages know about the event.
For details and registration about the main event on Saturday, please see