OpenLink Software Support Page

Troubleshooting Worksheets

System Performance Related - Multi-Tier Drivers

Use this form to gather information which will help OpenLink Product Support better assist you.

System Information

• What product are you using?
  
  

  ---

  
  
  
• What are the names of the files that you downloaded?
  
  

  ---

  
  
  
• What is the product version and release number?
  
  

  ---

  
  
  
• What is the name and version of the Operating System containing your Multi-Tier client components?
  
  

  ---

  
  
  
• Provide the output of uname -a for Linux and other Unix-like machines.
  
  

  ---

  
  
  
• What is the name and version of the Operating System containing your Multi-Tier server components?
  
  

  ---

  
  
  
• Provide the output of uname -a for Linux and other Unix-like machines.
  
  

  ---

Problem Description

• Has this problem always existed?
  
  

  ---

  
  
  
• If this problem is new, describe any changes to the database, network, and machines in this architecture.
  
  

  ---

  
  
  

  ---

  
  
  
• Is this problem associated with heavy load?
  
  

  ---

  
  
  
• Provide Data Source Name Connection Parameters.
  
  

  ---

Server Environment

• What are your database server's kernel tuning parameters?
  
  

  ---

  
  
  
• What is your database server's patch level?
  
  

  ---

  
  
  
• Did you install your server components on the database native server?
  
  

  ---

  
  
  
  • If you answered yes to the above, could you install your server components on a machine that contains the database native client? This could be the same machine or a gateway. (Routing connections through the database native client may speed performance in problem environments.)
    
    

    ---

    
    
    
• What is your database native client version?
  
  

  ---

  
  
  
• Are you establishing a connection to Progress? Is it running in sockets or shared memory?

Problem Isolation

• Is the problem specific to one client machine?
  
  

  ---

  
  
  
• Is this problem specific to one client application?
  
  

  ---

  
  
  
• Do other ODBC drivers outperform OpenLink ODBC drivers?
  
  

  ---

  
  
  
• Is this a LAN, MAN, WAN, or VPN?
  
  

  ---

  
  
  
• Can you quantify the amount of data that is being returned?
  
  

  ---

  
  
  
• What are the data types of the data being returned?
  
  

  ---

  
  
  
• Have you checked the Defer Fetching of Long Data checkbox (for binary data only)
  
  

  ---

  
  
  
• Do you know the cursor modality your application employs?
  
  

  ---

  
  
  
• Set your Data Source's Rowbuffer Size to 1. Test. Set your Rowbuffer Size to 99. Test. Do you see any difference in performance?

Other Considerations

• OpenLink's Single-Tier drivers outperform Multi-Tier drivers. Could you switch?
  
  

  ---

  
  
  
• OpenLink's latest drivers have faster communications layers. If you have an older driver, can you upgrade?
  
  

  ---

  
  
  
• Performance problems may stem from the way you have structured your tables. Can you provide a table schema for a problem table?