PowerBuilder - Application performance monitoring tool - Stack Overflow current community chat blog Stack Overflow Meta Stack Overflow Careers 2.0 more stack exchange communities Stack Exchange sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site careers 2.0 Stack Overflow Questions Tags Tour Users Ask Question Take the 2-minute tour × Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required. Application performance monitoring tool up vote 2 down vote favorite I need some help to find out if there is any tool that can give below stats for PowerBuilder application running against Oracle and Sybase. Also highlight if I missed any other areas to be monitored. 1) Distribution of entire client event time into time consumed by application, network and database. 2) Details on how much time spend in app and which application function/method is root cause 3) # of DB requests made 4) DB IO stats 5) CPU time per db request 6) DB server memory usage 7) Size of data transferred between DB and app server performance PowerBuilder performance-monitoring share|improve this question edited Nov 17 '11 at 14:39 Terry 4,927614 asked Nov 17 '11 at 6:59 DataArchitect 363 You've got a mix of application metrics (e.g. 1, 2) and database metrics (e.g. 4-6). I suspect you're going to need separate tools to cover each of these domains, and maybe even different tools for each DBMS (although I believe there are some commercial cross-DBMS monitoring tools). – Terry Nov 17 '11 at 14:45 add comment 3 Answers active oldest votes up vote 0 down vote We added a service to our application to collect performance data. We call a start function in the service and pass it information about the object, method, and operation we are timing. We get back an event id (long) to pass to the the stop function. When the application closes it saves the performance data as XML for later analysis. The timing service has very low overhead, so it can be used to gather real-world data. share|improve this answer answered Nov 18 '11 at 17:57 Hugh Brackett 2,141414 add comment up vote 3 down vote If you activate the profiling in the PB Tools / System Options you can get after running a trace file for your project that can include the hit counters and timings for the routines executions. BTW, there are several options, but it just won't help you for the memory / I/O consumption I think, you'll have to get additional tools for that, I found myself Process Hacker very useful for that. After a run to collect the data (you need to pass on each feature that you want to analyze), you have several tools to process it through the File / New... / Tool assistant : Profiling class view Profiling Routine view profiling trace view They need a little practice to become useful but for using the Profiling Routine view, I can tell that it helps much to point the bottlenecks by telling both the time passed in routines (it can be shown individually or summarized) and the number of times they are called (to identify for example the code to move outside of loops, and so on). share|improve this answer answered Nov 17 '11 at 10:22 Seki 5,22121629 The existing tools to look at Profiling traces don't do summations in the way you're asking. However, there are PowerScript functions to look at Profiling data, so you could scan a profiling file and aggregate the data you're after. – Terry Nov 17 '11 at 14:41 add comment up vote 0 down vote Nagios is an open source tool which can be used to monitor almost everything share|improve this answer answered Nov 17 '11 at 7:02 Vinit 1,015222 add comment Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Stack Exchange Post as a guest Name Email required, but not shown Post as a guest Name Email required, but not shown discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged performance PowerBuilder performance-monitoring or ask your own question. asked 2 years ago viewed 828 times active 2 years ago Community Bulletin event Welcome the new moderators! – BYOB blog Podcast #55 – Don’t Call It A Comeback Related 836 How do I improve the performance of SQLite? 1 performance monitoring tools for multi-tenant web application 6 What tools does your company use to manage application performance of asp.net applications? 4 Any open source software for monitoring MySQL performance? 2 monitoring application (CPU and cache usage) on single Linux box with 80 cores 1 Extend and customize a performance monitor 5 Performance monitoring/metrics in .NET app 1 Identifying poor performance in an Application 0 Monitoring performance of server using .NET 0 what's wrong with my monitoring script Hot Network Questions What is the cause of centripetal/centrifugal force? Images with all colors Word that means "more accepting of other cultures"? Pi Calculation Code Golf Do Collections.unmodifiableXXX methods violate LSP? How to change operator symbols in truth table Program that creates larger versions of itself (quine-variant) Should I list skills on my résumé if I have no interest in using them again? Should I tell my co-workers that branch manager uses drugs (crack) at the office? Errors when plotting Exp[-x]/x for large values of x When should you stop asking your PhD advisor to do advisor like things? Why is the MiB suit the last suit Jay will ever wear? Metal dust/shavings in food from knife wear? where is `cd` located? Why is my C# program slower than my Python program? Where do airshow pilots practice? What is the origin and / or standardness of the term "bang account"? Is there any information on the (external) etymology of "Gandalf"? Named numbers as variables Can you still battle a monster even if it will not pursue you? When taking clients out for drinks, how to behave when I cannot drink? How long should one wait to see if they got the job? How to respond to a "we'll call you when the position opens" response, when you see the position opened? How to draw the figure in tex? more hot questions question feed about help badges blog chat data legal privacy policy jobs advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science Other Stack Overflow Server Fault Super User Web Applications Ask Ubuntu Webmasters Game Development TeX - LaTeX Programmers Unix & Linux Ask Different (Apple) WordPress Answers Geographic Information Systems Electrical Engineering Android Enthusiasts Information Security Database Administrators Drupal Answers SharePoint User Experience Mathematica more (14) Photography Science Fiction & Fantasy Seasoned Advice (cooking) Home Improvement Personal Finance & Money more (12) English Language & Usage Skeptics Mi Yodeya (Judaism) Travel Christianity Arqade (gaming) Bicycles Role-playing Games more (21) Mathematics Cross Validated (stats) Theoretical Computer Science Physics MathOverflow more (7) Stack Apps Meta Stack Overflow Area 51 Stack Overflow Careers site design / logo © 2014 stack exchange inc; user contributions licensed under cc by-sa 3.0 with attribution required rev 2014.2.26.1402 Stack Overflow works best with JavaScript enabled