How-to configure Oracle Database monitoring

Most of the time, with every application, there comes with the Database setup and most of the time, it’s Oracle (being the biggest player in the DB industry). Fundamentally, (1) it requires a Oracle client to be installed on the machine as a native client. (2) A valid account and privileges to the Oracle V$ tables that holds statistics. (3) Ensure that you can properly query from the Controller using the SQL tools and extract data from the V$ table and you should be fine with the setup. In this article, we will be providing the a typical connection to the Oracle database for monitoring (i.e. we will not be focusing on counters directly related for analyzing database performance).

Let’s go through an overview for implementing the Oracle DB. Basically, we are doing in this sequence: Read the rest of this entry »

How-to configure Sybase monitoring

To configure Sybase database monitoring, we will require ASE Monitoring Server (not the ASE) to be installed on the Controller (refer to “How does the monitoring work in LoadRunner?” for monitoring concepts). Furthermore, we will require an additional DLL in Controller for it to work. From the Monitor Reference, the DLL is named, libct.dll. That is for version 12. While in version 15, it’s named libsybct.dll. ASE in short for Adaptive Server Enterprise is a database product from Sybase. To get the latest copy of the ASE server can be obtained from the Sybase website. Read the rest of this entry »

How-to record and replay ESRI ArcGIS Desktop (ArcMap)?

This article provides a basic understanding that you can use in recording and replaying of the ESRI ArcGIS Desktop (ArcMap) communicating with ArcGIS Sever. GIS stands for Geographical Information System which examples are Google Maps and Yahoo Maps. There are four approaches I figured out to conduct the load testing using LoadRunner. Again, we need to grasp some concepts on how LoadRunner works in recording and replay in “Which protocol to use?” and how we can apply onto this technology. Basically, they consist of (1) loading of the SOAP/HTTP traffic, (2) replaying of the actual Web Service, (3) replaying of the methods and assemblies and (4) replaying of the scripts created in Visual Studio using Visual Studio AddIn and ArcGIS SDK.

We will go through the approaches in LoadRunner and briefly touch on the similar options available in SilkPerformer. Read the rest of this entry »

Does LoadRunner support JMS recording?

Depends; In order to answer the “depends”, we need to understand some basics of JMS and its relation with LoadRunner. First, JMS can be implemented in two ways: (a) via HTTP/XML or (b) via RMI-Java. Going back to the fundamentals of LoadRunner on the article for protocols, “Which protocol to use?”, its essential to know what’s the communication mechanism in order to select the protocol from LoadRunner. A more detailed description on the different implementations can be found in “JMS over XML-RPC with HTTP protocol” from the TheServerSide.com.

Read the rest of this entry »

Understanding WebLogic (JMX) monitoring

What’s WebLogic (JMX) all about in LoadRunner? If you are not J2EE background professional and caught up in a load test for WebLogic servers, this article will be useful to you as we’ve put together information to help you get a better understanding of JMX (Java Management Extensions). We will be going through the fundamentals of JMX and how it works in together with LoadRunner. We will also be touching on the reference list of available counters provided by WebLogic. If you like to know the configuration details, look out the Monitor Reference that comes together with the installer (which is pretty easy to configure). Read the rest of this entry »