Select Page

Working with HP Diagnostics

Author: Chuck Ezell | | April 16, 2014

We’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.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

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