Fault Finding in a Progress Application

Duration

• 1 Day

Prerequisites

• Familiarity with Progress 4GL
• Familiarity with Relational Databases
• Familiarity with the OS (Unix / Linux / Windows) and the available utilities.

Course Description

Machine running slowly? Database performance apparently slow? Some of the time? All of the time? This course aims to present to experienced Progress developers and Database Administrators key tools and techniques to find, fix and most importantly prevent application issues.

Topics

Key topics in this course include

• Performance Tuning – The Basics
  • Processor
  • Memory
  • I/O Bandwidth
  • Network
• Performance on PC based Unix systems
  • Hardware
  • O/S tuning
  • Network
  • Progress Tuning
• Performance on a Windows system
  • Hardware
  • O/S tuning
  • Network
  • Progress Tuning
• Storage areas for database performance
• 4GL Application Tuning
  • Why and when
  • Code and Index Analysis
  • Profiler

Objectives

This seminar will enable developers and administrators to make the most of their investment in Progress.

This course will provide developers with the skills foundation to enable them to examine their system for bottlenecks whether those bottlenecks are resource based or code induced. It will introduce various tools to examine system resources and program performance.

Customers who have attended the course will return with:

• An increased confidence in their usage of Progress
• The ability to monitor their systems
• The ability to be proactive in their system tuning to prevent poor performance
• The ability to react to poor system performance

Applicable Progress Version

• All

Delivery Mechanism:

• Instructor Led