WDUG Special Events

presents

Bonnie K. Baker

Reduce Your CPU Usage by Tuning your SQL

October 14, 2010

8:00-4:00

West Bend Mutual Insurance Company

The economy is suffering; budgets are being cut; reducing costs is imperative. CPU savings directly translate to cost savings. This seminar will focus on ways to tune SQL to get better performance by reducing Get Pages, Read I/Os, and Sort overhead. Topics include:

1) Designing today's indexes to match you SQL

2) Alternative SQL to get the same answer back faster

3) Unusual solutions to very common problems.

Objective 1: Learn modern techniques to redesign your indexes for better performance
Objective 2: Learn tips & tricks for creating high performance, low CPU SQL
Objective 3: Learn ways to rewrite problem SQL to improve performance & lower CPU
Objective 4: Learn ways to reduce locking CPU & contention & increase availability
Objective 5: Learn unusual, "I never thought about doing that" techniques for improving performance
 
Bonnie Baker specializes in teaching on-site classes for corporations, agencies, & DB2 User Groups.  She offers classes for programmers and DBAs aimed at improving Applications Performance & transitioning gracefully from one Version of DB2 for z/OS to another. She is an IBM DB2 Gold Consultant, an IBM Information Champion, a five-time winner of the IDUG Best Speaker award, and a member of the IDUG Speakers' Hall of Fame. She is best known for her ability to make very complex concepts “simple” through her use of analogies and war stories – and, of course, for writing this "Programmers Only" column. She can be reached at bkbaker@bonniebaker.com or 1-727-895-5920.

Registration forms will be available at the September meeting and online