Articles & Content

Archives

D08 - Zen and the Art of Database Performance

Topic: 2015 EMEA

Subtopic: DB2 for LUW



Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session, we'll go through a step-by-step, decision tree-based approach for tackling performance problems. We start by identifying the core area of the bottleneck - is it time spent processing, or time spent just waiting? Then, by using DB2's powerful monitoring interfaces, we refine our diagnosis, drilling down layer by layer. This logical, efficient approach not only helps us get to root cause, but it does so in a way that avoids wasting time by "trying random stuff" which isn't likely to help. Based on a prior & highly successul IDUG session of the same name, this presentation has been completely revised and updated for 2015, using the latest levels of DB2 LUW.



Click Here to Download

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