Skip to main content


developerWorks  >  WebSphere | Rational  >

Validating performance in a J2EE application

Using SQL tracing and the Rational Application Developer Profiler

developerWorks

Level: Intermediate

Andres Voldman (voldman@ca.ibm.com), Software Engineer, IBM
Daniel Owusu-Afari (danieloa@ca.ibm.com), Software Engineer, IBM

30 Apr 2008

Register now or sign in using your IBM ID and password.

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


Share this....

digg Digg this story del.icio.us del.icio.us Slashdot Slashdot it!


Back to top


Document options

Document options requiring JavaScript are not displayed


My developerWorks needs you!

Connect to your technical community