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 »

Unable to login Administrator account in Windows

Most of the time we have to work with the administrator account on a Windows environment in a load test or setting up of monitors. A common problem that I encountered is that I’m unable to login as an administrator to have full privileges to the machine either if some settings have changed throughout the duration of its usage. In anyway, to login as administrator account, you will need to enable administrator login for the Windows XP. Read the rest of this entry »

Using Ping

To isolate network problems with ping, follow the steps listed which actually starts from the loopback interface, IP address, name resolution, router connectivity, traceroute to remote machines. You will need to run the ping command repeatedly, changing your destination address so that you work your way through each intermediate device to your destination. Read the rest of this entry »

Resolving Vugen/Controller crash or abnormal behaviors

In the event that Vugen/Controller crashes or behaves abnormally, the official vendor has provided two documents to assist the user in troubleshooting the problem for each component separately. The documents are rather out-dated but well, better than nothing, is still relevant in some sense. Below are the links to the resources: Read the rest of this entry »