Articles & Content

Archives

Diagnosing & Curing? Lock, Wait and Performance Bottlenecks (E14)

Topic: 2010 NA

Subtopic: DB2 for LUW



DATE: 2010-5-14 (09:45 AM - 10:45 AM)
SPEAKERS: Alexander Kopac (Home Depot)

Do you as a customer wait 15 seconds for a web application to fail to respond and then move on to the next competitor? Timeouts, Lock Waits, Deadlocks, Lock Escalations & Application & Database ?Design Flaws? routinely cause Application Locking & performance snags. Here are real life customer experiences that visit issues such as selecting data types, filtering thru mountains of monitoring parameters/tuning knobs, & viewing various logs. We'll see the ?pick of the litter? performance parameters to investigate, see simple techniques for predicting constraint issues, & RI juggernauts. Learn how to spot index/log bottlenecks, ?lack of preparation? issues, rollback/commit snags, and look for the ?common/unnecessary? application SQL miscodes.

EXP. LEVEL: Beginner

OBJECTIVES:

Finding performance bottleneck issues: Locks, Deadlocks, Escalations, Waits & Design Flaws

Looking for potential snags: Triggers, Constraints, and Men's Disease (Fear of Commitment) Oh My!

Lock Reduction techniques & calculating how much lock contention is too much

Tuning Knobs and Parameters in the Toolbag

Tricks & Techniques



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.