Service Management Blog

Enhancing Load Testing Effectiveness: Unleashing the Power of the JMeter Simple Table Server

enhancing-load-testing-effectiveness
6 minute read
Pranay Patel

JMeter Simple Table Server: An Introduction

JMeter is a popular open-source tool used for performance testing, load testing, and functional testing of web applications. One of the lesser-known features of JMeter is the Simple Table Server (STS), which allows you to store and retrieve test data in a simple tabular format. In this blog post, we’ll explore how to implement the STS.

What is the STS?

The STS is a server application that allows you to store and retrieve test data in a tabular format. It provides a simple and easy-to-use interface for creating and managing test data, which can be used in your JMeter test plans. You can store data in tables and use them to simulate real-world scenarios, such as user login credentials, product information, and customer details.

Challenges of using/managing input files locally

  • Manually splitting input file record and distributing it on each node.
  • If you plan to add a new use case, you will have to repeat the same process again.
  • What if you plan to add a new JMeter secondary machine? Now you will have to manage files for each node. For example, 40 files for six nodes are 240 total files.
  • What if you want to update part of your input files?
  • What if your use case has Maker-Checker flow? Managing FIFO(First In First Out) input list in distributed nodes is quite tedious.

A real-world use case scenario

Consider a scenario where you have 40 thread groups that are using unique user logins. Moreover, you have a distributed JMeter setup with five secondary machines. In this case, you will have to manually split users and copy those files to each secondary machine. so, you end up having 200 input files (40 files for each node equals 200).

JMeter Distributed Testing Architecture

Figure 1. [JMeter Distributed Testing Architecture]

Benefits of using the STS

  • Improved test performance: The STS can improve test performance by allowing virtual users to share data. This reduces the need for virtual users to read and write data from external data files, which can cause delays and increase the test execution time.
JMeter Distributed Testing Architecture with STS

Figure 2. [JMeter Distributed Testing Architecture with STS]

  • Easy data sharing: The STS simplifies data sharing between virtual users. Virtual users can easily access and modify data stored in the STS table, making it easier to create complex test scenarios and create, read, update, and delete the table on the fly.
  • Flexibility: The STS can be used with CSV files, which makes it easy to integrate with different types of applications.
  • Realistic test scenarios: The STS enables virtual users to share data, which can create more realistic test scenarios. For example, multiple virtual users can access and update the same data simultaneously, simulating a real-world scenario such as Maker-Checker flow.
  • Centralized data management: The STS provides centralized data management in a single location, which simplifies the management and maintenance of test data.
  • Improved test accuracy: By allowing virtual users to share, access, and modify the same data, you can reduce data inconsistencies and errors and gain complete control on how you read the file, i.e., unique, sequential, or random.

Configuring the STS

Implementing STS can be done in just a few steps:

Step 1: Download and Install JMeter

To use the STS, you must have JMeter installed on your machine. You can download the latest version from the official website and follow the installation instructions.

Step 2: Download the STS Plugin

Once you have installed JMeter, download the STS plugin and install it by copying the JAR file to the “lib/ext” folder in your JMeter installation directory.

Step 3: Configure the STS

After installing the plugin, you need to configure the STS by adding the following properties in the jmeter.properties file.

In this example, I chose the dataset directory location at C:/jmeter_for_sts/dataset. You can select any location.

By default, the port is 9191, which you can change per your requirements.

Sample jmeter.properties file

Figure 3. [Sample jmeter.properties file]

Now we will create a CSV file with test data and upload it to the server (at the above “datasetDirectory” location).

The CSV file should contain the test data in subsequent rows as illustrated below:

Sample csv input file

Figure 4. [Sample csv input file: env1_login.csv]

Now you can execute following command in your browser and it will display the number of records in the file: http://hostname:port/sts/INITFILE?FILENAME=env1_login.csv

Sample output

Figure 5. [Sample output].

Step 4: There are various ways to start the STS. In this example, I am starting by using the simple-table-server.bat file. Go to JMeter’s bin directory and click on the “simple-table-server.bat” file.

Successful startup sample

Figure 6. [Successful startup sample]

Upon successful startup, you will see a screen like the one shown above with the server port number and the location of the file.

It will also load the list of files you specified in the initFileAtStartup parameter in jmeter.properties. As a best practice, always add your input files in the “initFileAtStartup parameter.” Files that are not mentioned will disappear when the STS restarts.

Now, try to access the URL IP address: <port>/sts.

It should give you the output below with all the commands related to the STS.

Welcome page

Figure 7. [Welcome page]

Once you see this page, you have successfully configured the STS.

various commands to interact with STS

Figure 8. [various commands to interact with STS]

How to integrate the STS into your test plan:

Assuming you followed the above steps and your STS is now fully up and running. Let’s try to implement this in your actual test plan. We will practice how one can read the STS data and use it in subsequent requests.

  1. Load the file in memory with the INITFILE command.

INITFILE

  1. Read the file using the READ command and depending upon your choice, you can also read the file through FIRST/LAST/RANDOM commands.

Read command

  1. Using Regular Expression, extract the username and password from the response data.

Regular Expression

extract-the-username

Likewise, you can read other parameters (if you have more column in the files).

  1. Let’s run the script and check the output.

run-script

Row-return

Now you can use these extracted parameters in subsequent requests, as needed.

Conclusion

The JMeter Simple Table Server is a useful feature that allows you to store and retrieve test data in a tabular format. It provides an easy-to-use interface for managing test data and can be used to simulate real-world scenarios in your JMeter test plans. By following the steps outlined in this blog post, you can easily implement the STS and start using it in your performance testing projects.

These postings are my own and do not necessarily represent BMC's position, strategies, or opinion.

See an error or have a suggestion? Please let us know by emailing blogs@bmc.com.

Business, Faster than Humanly Possible

BMC works with 86% of the Forbes Global 50 and customers and partners around the world to create their future. With our history of innovation, industry-leading automation, operations, and service management solutions, combined with unmatched flexibility, we help organizations free up time and space to become an Autonomous Digital Enterprise that conquers the opportunities ahead.
Learn more about BMC ›

About the author

Pranay Patel

Experienced performance test engineer with 9 years of expertise in evaluating and optimizing system performance. Skilled in designing and executing performance tests, analyzing results, and recommending enhancements to ensure optimal software and application performance. Committed to delivering high-quality solutions that meet and exceed performance expectations.