e-testing Blog

Performance Testing of Student Record Systems: an e-testing guide

mortar board image

by Swapna Komatineni

Student Record Systems (SRS) are the cornerstone of any Higher Education establishment’s IT infrastructure. With many more HE institutions offering their students increased online access to these systems for selecting course modules, viewing their personal information and obtaining their results, the user experience is more important than ever.

The story so far

e-testing have worked with several UK Universities to assist with specialist performance testing of their applications, often before the launch of a new service. This guide is based on our experience of testing SITS: Vision, an off-the-shelf package developed by Tribal Group plc, used by most UK Universities.

We have carried out performance testing for various Universities on different areas of the system, including Online Registration, Module Registration and a simulation of results day.

Here we focus on a test we have run for Module Registration and outline the process we went through and the methods we used to simulate expected usage on the application.

Step 1 – Planning

The first step is always planning. Our team worked with the project team to define the scenarios to test, as well as the expected numbers of concurrent users. For the Module Registration process, this involved identifying three typical combinations of courses and associated modules, making up diets – representing low, medium and high complexity.

Step 2 – Creating Scripts with Apache JMeter

Once agreed, we then created three different scripts, one for each diet. Each needed data – this was carried out by the university in the test lab, after obfuscation of data had been run, in order to protect sensitive personally identifiable information.

The following steps were scripted, using Apache JMeter:
• Login
• Navigate to Module Registration from the Homepage
• Select the Modules of choice for the course selected
• Confirm Module Selection
• Submit Choices
• Logout

Step 3 – Parameterisation, Correlation, Assertion & Timers

Once initial scripts had been recorded, the following activities were undertaken in order to enable the scripts to run as real users:
1. Parameterisation – hook in to data items so that each run can select different data items from a spreadsheet of data.
2. Correlation – items that need to be dynamically inserted into running scripts were identified so that the scripts would run successfully, for example session ID’s.
3. Assertion – Assertions help to define success criteria of the particular request by matching the returned values with the expected values to make sure our scripts are working fine and doing what is expected.
4. Timers – think times were inserted and made variables in order to cater for variable think times to more accurately simulate user activity.

These are dealt with separately below:

1. Parameterisation

The process of replacing the hard-coded user defined values with the variable is called parameterisation.

As we used different student records from SITS during registration, we parameterised all of the data which should be filled by the students in real time, as shown below:

 

image 1

2. Correlation

Correlation is one of the most important concepts in performance scripting, which deals with the dynamic values like session ID, request verification tokens etc. which are generated by the server.

Below are some of the main correlating values used:

  • JsessionID
  • Nkey
  • Isscode

As well as these, we also correlated Module Code to take the advantage of passing random module instead of always using the same one value.  These are shown in the graphic below from JMeter:

SITS image 2

3. Assertions

 JMeter includes a valuable feature called assertions.  Assertions help to define the success criteria of the particular request by matching the returned values with the expected values to make sure our scripts are working fine and doing what is expected.

In the example below, we were trying to check for the text “Thank you for registering your modules”. When the scripts executed, the request will be marked as ‘Pass’ only if that text is included in the response, or else the request will fail which means the user received an unexpected page, which will need to be debugged, based on the server response.

SITS image 3

4. Timers

This element of JMeter allows the simulation of real-time behaviour in terms of the request delays to the server, as all actual users of the application will not perform the actions at and in the same time when it is made live.

Uniform random timer is one of the timers, which delays all the requests with the random time interval between the given range.

For example, in the screen shot below, before clicking on Confirm Modules, constant delay offset is set to 10000ms and the maximum delay as 5000ms, meaning the requests will be delayed randomly between the time range of 10 to 15Sec.

SITS image 4
Step 4 – Test Execution

Once the scripts were completed, test scenarios were designed to execute them with given/required number of users.  In this test, we executed several simulations; Debug Test, Normal Load Test, Peak Load Test, Stress Test & Soak Test, which have different objective to achieve.

  • Debug Test: to make sure that all systems and data are set up and working correctly including monitoring
  • Normal Load Test: simulates the system working on any typical day/hour. It acts as a benchmark for response times when the system is operating under typical conditions
  • Peak Load Test: to test the peak hour usage of the application
  • Stress Test: to identify the limits of the system under test
  • Soak Test: to see how the system copes over time, particularly in managing resources at normal operational volumes with spikes in use up to peak load levels

We also normally recommend some manual exploratory testing is conducted at a given point in the test.  This is oriented around features not scripted and in particular areas which may be of particular risk such as running reports or other queries that may be database intensive.

Step 5 – Listeners

Listeners help to view the results of the test execution in different formats such as tree, table, graph or log file. There are built in and plug-in listeners available in JMeter.

The below aggregate report shows the response times and the error % from the data obtained from the test.  We can see that the average response time of the first request was >30 Sec, which was highlighted to the project team, to confirm the SLA for that particular transaction.

SITS image 5

Step 6 – Results

Once the tests were run, data analysis was carried out on the results:

The images below show how the data is displayed in JMeter after the test execution. The ‘Active threads over time’ graph shows the user load during the test for each of the script.

SITS image 6
The ‘Response times’ graph shows how they are achieved over the test duration:

SITS image 7

  • Based on the results, specific transactions were identified where response times were spiking under load, in order to identify areas of the system for possible improvement
  • The response times were correlated against server and network resources, in order to identify bottlenecks
  • Several changes were made to the infrastructure; tests were re-run after each change. The modifications included hardware configuration and database indexes
  • Once the tuning had been completed, a final test proved the level of concurrency the system would be able to support, as well as the anticipated response times from each of the transactions tested

______________________________________________________________________________

e-testing is fast establishing itself as the ‘go to’ testing consultancy for Universities and Colleges. We have tested student record systems for a number of prominent HE institutions; references are available on request.

Please contact us to discuss your requirements, we would be happy to explain in detail how we can help, and provide you a no-obligation quotation.  You can find us on G-Cloud here, or contact us.

CLICK HERE FOR UPDATES

Subscribe to our RSS feed and get the latest updates in your inbox weekly

logo