E02 - SQL Tuning in the Digital World

Session Number: 4320
Track: App Dev
Session Type: Podium Presentation
Primary Presenter: Sheryl Larsen [BMC Software]
Time: May 01, 2017 (01:55 PM - 02:55 PM)
Room: North Exhibit Hall Room F

Speaker Bio: Sheryl M. Larsen is a Sr. DB2 Product Specialist 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 - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Data Management, Managing Database Resources, Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, IT Managers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), SQL and XML Performance
Objective 1: When your monitors find this, what should you do?
Objective 2: What crazy SQL can do for you!
Objective 3: Finding the most expensive query running in the peak
Objective 4: Some old and new tuning techniques
Objective 5: Monetize your MLC savings with compares

Abstract:  The Digital World include all kinds of transactions most of which contain SQL. Trapping and fixing nonperforming SQL has gotten more complicated or has it? The speed at which SQL performance problems need to be resolved has shrunken to .1ms or 0 – meaning that they should never happen. Come learn tips and techniques that can assist you in today’s Digital World.