 | Level: Intermediate Andres Voldman (voldman@ca.ibm.com), Software Engineer, IBM Daniel Owusu-Afari (danieloa@ca.ibm.com), Software Engineer, IBM
30 Apr 2008 This tutorial shows you how to tune a typical J2EE application for
performance by analyzing database usage and by using the Rational® Application Developer Java Profiler to identify costly operations.
In this tutorial
In this tutorial, you will troubleshoot a typical performance situation in a sample
Web store. First, you will use SQL tracing to validate whether the page is using the
database efficiently and you will learn how to look at the results from the
application and database perspectives. Secondly, you will learn to map SQL statements to Java™ code and you will use
the Java Debugger to discover where the code is executed, which allows you to
identify flaws in the design. Next, you will use the Java Profiler to
pinpoint operations that take the most time and to identify
repetitive execution. Finally, with the knowledge of the application you gained, you will make
recommendations to improve the performance of the category page.
Objectives - Learn about performance costs from a database perspective.
- Learn the benefits of using a Java profiler to identify coding inefficiencies.
Prerequisites
This tutorial is written for Java programmers. You need to be familiar with J2EE application development in a Rational Application
Developer environment. Basic DB2 database skills are also required.
System requirements
- Microsoft ® Windows® XP® machine with 2GB RAM as a single host environment for the software stack
- IBM® DB2® Enterprise Server Edition V9.5
- IBM Rational Application Developer for WebSphere® Software V7.0 with a WebSphere Application Server V6.l test server
Duration
Approximately 2.5 hours
Formats html, pdf
|  | |  |