• Topic
  • Discussion
    • SupportWeb.WorksheetMTperformance(Last) -- Owiki? , 2016-08-19 14:59:38 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2016-08-19 14:59:38

    Troubleshooting Worksheet -- Multi-Tier Driver, System Performance

    Use this form to gather information which will help us 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?



    CategoryWebSite CategorySupport CategoryWorksheet CategoryUDA

    Referenced by...