Revival of the SQL Tuner

Download PDF

Session title: Revival of the SQL Tuner

Session abstract: The pool of DBAs with SME knowledge of SQL tuning has shrunk dramatically while the number of SQL statements needing attention has grown and will continue to grow. DB2 performance tooling can help identify what needs to be tuned.  But what do you do then?This presentation will help fill the skills gap by reviving the role of an SQL Tuner.  Specifically, you will learn what access paths are good for what types of queries, what indexes are best, and how to change the DB2 optimizers mind.

Speaker biography: Sheryl M. Larsen represents Worldwide Db2 Z Solutions at BMC. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL Tuning and has performed detailed Db2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in Db2, has published many articles, white papers and co-authored a book, Db2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest Db2 User Group –, an IBM Z Champion, and a member of the Northern Illinois University Computer Science Alumni Council.