Select Page

Working with HP Diagnostics

Chuck Ezell | | April 16, 2014

Working with HP DiagnosticsWe’ve introduced many different ways in which you can profile your application code. There’s a particular tool Datavail’s Chuck Ezell has used to proactively profile code: HP Diagnostics.

The tool allows users to be proactive and returns very useful information in an easily digested visual format.

With LoadRunner’s load testing capabilities, HP Diagnostics allows a user to undertake both a full application analysis and a server diagnostics analysis. The user can also use Java profilers or probes that can be configured to save the results for eventual analysis.

Being Selective a Must

Ezell says because this tool can consume too much of a server’s resources, a user needs to carefully select the environments in which they should be used.

“We’ve chosen not to use this in a production environment. The ability and the feature of being able to use this product as a proactive tool was diminished with the fact that the more you instrument, the more you attach to JVMs, the more server-intensive the monitoring process becomes,” Ezell said.

The instrumentation process also poses another particular challenge: If specific problems you’re monitoring in the profiling process don’t appear, you could think the code is fine when it isn’t, says Ezell.

The issue could be that it may not have been correctly instrumented. Instrumentation poses several challenges to users, claims Ezell.

Starting up Can Be Difficult

The initial process of using HP Diagnostics can be daunting, if not sometimes confusing. Multiple windows pop open during the process, requiring a user to determine which are being used to probe and to monitor. The more probes used, the more windows and more complicated the process can be.

Each Java probe used can take up resources. The more probes employed, the greater the CPU consumption and the more computationally intensive the process can become.

“This is the problem,” says Ezell. “You don’t know what you don’t know. If you’ve got code out there that you want to monitor, you have to make sure that you’re instrumenting things properly and you have to make sure that you’re pointing at the right problem. If you don’t know what the problems are, then you don’t know where to point the instrumentation.”

Drilling Down to the Root Cause

There often are challenges associated with drilling down to the root cause of the problem or problems. The database administrator could see that there has been JVM heap growth as a result of garbage collection, for example. What is causing this? Is it a specific user? Which transaction is involved in the process? These are the sorts of questions a user must understand, says Ezell, to be able to find the root causes of code problems. Sometimes it can be difficult to determine the application context.

But this sort of tool is invaluable, Ezell says:

Here’s an example of what you get: beautiful charts, very powerful information, you can capture all of the SQL data. It can be a great proactive solution. It’s a great visual tool for reactive and proactive firefighting. It maintains history in the form of snapshots and data. Output is saved in snapshots and then you can recall them from history.

This, he says, allows a user to answer questions and immediately identify real problems and patterns if you’ve instrumented it well.

And isn’t that what proactively profiling your application code is all about?

Do you need help in profiling your application code or better maintaining your organization’s database? Datavail can help. Contact us to find out how our experts can customize a solution for your organization’s unique challenges.

Image by bowie15/123RF.

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017
code

Recover a Table from an RMAN Backup in an Oracle 12c

This blog post will is to show a table restore for one table in a container database

Megan Elphingstone | February 2, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS