Course Description
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!

Introduction: 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 need to bring laptops.

About the Instructor
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 many multi-terabyte 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.

OTHER COURSE INFORMATION:

Attendees will need to bring laptops.

Internet & Network access are not available.

Food:  Lunch will be provided.

Recommended Hotel:

Courtyard by Marriott Chevy Chase

5520 Wisconsin Ave

Chevy Chase, MD 20815

Phone 1-301-656-1500

Reservations 1-800-321-2211

Online reservations

Cancellation policy:

Cancellations more than 1 month prior to the event will be refunded 100%, 2 weeks prior 50% and within the last 2 weeks prior no refund will be given. Please contact sqlsaturday173@sqlsaturday.com for refund processing.