This event has ended

SQL Sat.Louisville Pre Con:A Deep-Dive Into Waits-Based Performance Tuning

SQL Saturday Louisville

Friday, July 20, 2012 from 9:00 AM to 4:00 PM (EDT)

Louisville, KY

Ticket Information

Ticket Type Sales End Price Fee Quantity
SQL Saturday Louisville Pre Con Attendance Ticket Ended $99.00 $6.44
Group Registration (Republic Bank attendees only) Ended $900.00 $36.95

Who's Going

Loading your connections...

Share SQL Sat.Louisville Pre Con:A Deep-Dive Into Waits-Based Performance Tuning

Event Details

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. 

 

Language(s):

English

Audience(s):

Database Administrators, Programmers and DBA managers looking to gain a better understanding of Performance Tuning in SQL Server 2005/2008 AND 2012.

Level:

200-300

Technology:

SQL Server 2005/2008/2012

Type:

Course

Delivery Method:

Instructor-led (classroom)

 

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.

    

Have questions about SQL Sat.Louisville Pre Con:A Deep-Dive Into Waits-Based Performance Tuning? Contact SQL Saturday Louisville

When & Where



University of Louisville
School of Business, 2301 S 3rd St
Louisville, KY 40208

Friday, July 20, 2012 from 9:00 AM to 4:00 PM (EDT)


  Add to my calendar

Organizer

SQL Saturday Louisville

http://www.sqlsaturday.com/286/eventhome.aspx

  Contact the Organizer

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.