Analyze and Optimize PowerBuilder and Database Performance

Set up Performance Analysis

• Setup for PowerBuilder Apps
• Setup for Oracle (Direct Access to the DB)
• Setup for Oracle (No Access to the DB)
• Setup for SQL Server (Direct Access to the DB)
• Setup for SQL Server (No Access to the DB)

Database Performance Tuning

• Largest Tables by Row Count
• Largest Tables by Volume of Data
• Most Frequently Executed Objects at Runtime
• Most Referenced Objects by Code

• Optimizing SQL Server Performance
• Identify Slow Database Objects
• Get a Query Execution Plan (SQL Server)
• Get a Query Execution Plan (Oracle)
• Optimize a DB Slow Object
• Optimize a Business Process
• Optimize Slow SQL Queries
• Identify the Missing Index

PowerBuilder Performance Tuning

• Find Slow Code and Bottlenecks in your PB App
• Improve the User Experience of your PB App
• Focus on frequently used objects
• Optimize a Chain of calls
• Using PowerBuilder Code Profiling

Use Cases

• Perform a General Review of a PowerBuilder application
• Improve a Specific Feature in a PowerBuilder application