All geek questions in one place

Application Performance Monitoring Tool

I need help to find out if there is any tool that can give below statistics for PowerBuilder application working against Oracle and Sybase. Also indicate if I have missed any other areas that need to be tracked.

1) The time distribution of the entire client event in time consumed by the application, network and database.

2) Details of how much time is spent on the application and which function / method of the application is the main reason

3) Fulfilled # database queries

4) DB IO statistics

5) CPU time per db request

6) Database server memory usage

7) The size of the data transferred between the DB server and the application

+4
source share
3 answers

If you activate profiling in PB Tools / System Options , you can get a trace file for your project after launch, which may include hit counts and timings for performing procedures.

By the way, there are several options, but it just will not help you in memory / I / O consumption, I think you will have to get additional tools for this, I found myself Process Hacker is very useful for this.

After starting to collect data (you need to pass each function that you want to analyze), you have several tools for processing it using the File / New... / Tool helper:

  • View class profiling
  • Profiling Routine View
  • view profiling profiles

They need a little practice to be useful, but to use the Profiling Routine view, I can say that it helps to identify bottlenecks by indicating the time elapsed in the routines (it can be shown individually or summarized), and a number (for identification, for example, code to move outside of loops, etc.).

+4
source

Nagios is an open source tool that can be used to monitor almost everything

0
source

We have added a service to our application for collecting performance data. We call the start function in the service and pass its information about the object, method and operation that we use. We return the event identifier (long) to go to the stop function. When the application closes, it saves the performance data as XML for later analysis. The synchronization service has very low overhead, so it can be used to collect real-world data.

0
source

Source: https://habr.com/ru/post/1381630/

More articles:


All Articles