Course:                       A Deep-Dive Into Waits-Based Performance Tuning

BY:                               EDDIE WUERCH

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 and manage 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 an MCT. 

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. After attending this session, 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

-              Trace is Dead in SQL 2012: Intro to XEvents

-              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.

OTHER COURSE INFORMATION:

Food: refreshments/coffee in the morning and boxed lunch in the afternoon will be provided.

Further information regarding room number of the event and a lunch preference survey will be sent out closer to the event.

Parking: the closest parking garage is at the speed museum for $6 a day. We will make best effort to provide parking passes. There is also plenty of parking on streets.

Cancellation policy: no cancellations/refunds/exchanges allowed except if event is cancelled for any reason. Full payment of $99 is due at the time of registration.

FOR ALL OTHER INQUIRIES PLEASE EMAIL SQLSATURDAY122@SQLSATURDAY.COM.

tHANK YOU.