DB2 for LUW

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

May 14, 2010 03:00 PM

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

Attachment(s)
pdf file
NA10E14.pdf   3.10 MB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.