Performance Testing and Engineering

http://eyeontesting.com/questions/1272/an-operation-was-attempted-on-something-that-is-no.html

In this blog, I’ll tell you how to load test the oracle database using loadrunner. There are different ways to achieve it and one simple way is writing SQL queries in vugen script. In this blog I’m going to tell how to connect to database, how to execute query and how to disconnect. I will be using lr_db functions to achieve this. Loadrunner help is very useful with details about lr_db functions. Connect to Oracle database: lr_db_connect("StepName=Connect",         "ConnectionString=Provider=OraOLEDB.Oracle; dbq=10.xx.xx.xx:1540; Data Source=XXXX; Persist Security Info=True; User ID=username; Password=password",         "ConnectionName=OracleDB",         "ConnectionType=OLEDB", LAST ); SQL statement: lr_db_executeSQLStatement("StepName=PerformQuery",                 "ConnectionName= OracleDB",                 "SQLStatement=SELECT * FROM \"TableName\" ",                 &q

Here are the top 7 Command tools which are very useful to monitor and debug Linux System Performance which are frequently used command line to monitor Linux system performance. TOP - LINXU PROCESS MONITORING It display CPU usage, Memory usage, Swap Memory, Cache Size, Buffer Size, Process PID, User, Commands and much more. It also shows high memory and cpu utilization of a running processess. The top command is much userful for system administrator to monitor and take correct action when required. Let’s see top command in action. # top VMSTAT – VIRTUAL MEMORY STATISTICS Linux VmStat command used to display statistics of virtual memory, kernerl threads, disks, system processes, I/O blocks, interrupts, CPU activity and much more.  # vmstat TCPDUMP – NETWORK PACKET ANALYZER Tcpdump one of the most widely used command-line network packet analyzer or packets sniffer program that is used capture or filter TCP/IP packets that received or transferred on a specific