Go back to all articles

Database Volume Testing

Mar 28, 2019
2 min read

Database volume testing is a type of testing where the system is tested based on large volumes of data.

Challenge

Minimizing the risks related to performance degradation, possible breakdowns or failures under loads that are caused by increases of data in the database by promptly discovering performance problems in the system’s operability, localizing the “bottlenecks” and providing recommendations for their resolving during volume testing.

Deliverables

The report on volume testing includes:

  • Information about changes in the system performance with increased data volumes within the parameters of the IT system response speed: response times of user operations (under different loads) and server-loading resources (CPU, Memory, I/O)
  • Analysis of the “bottlenecks” in the system operation and recommendations for improvements to the architecture and infrastructure of the system

Scope of work

  • 01
    Creation of load testing methods
  • Collection and analysis of production environment statistics
  • Coordination of the performance requirements
  • Determination of business processes and load scenarios
  • Determination of components for reliability testing
  • Description of the interactions with the external systems
  • Calculation of the intensity and determination of the load profiles
  • Description of the requirements for the DB volumes
  • Creation of a test plan
  • 02
    Creation of a test model
  • Development of load scripts
  • Development of external system emulators
  • Creation of load scenarios
  • Creation of scripts for generation/depersonification of the database
  • Creation of data pulls
  • Guides for conducting the test
  • 03
    Test preparation
  • Checking the operability of the test environment
  • Installing the testing tool on the load stations, such as those featured in this load testing overview.
  • Tuning the monitoring tools
  • Conducting trial tests
  • 04
    Conducting trials
  • Launch tests for checking the system reliability in accordance with the load scenarios
  • Shutdown/restart of the chosen system components
  • Launch tests to check the fail-safety of the system
  • Results analysis
  • 05
    System analysis
  • Analysis of the bottlenecks in the system performance
  • Analysis of the influence of a shutdown/restart of the chosen components on the business processes
  • Analysis of the system restoration time after a shutdown/restart of the chosen components
  • Preparation of the recommendations for changes in the system architecture and infrastructure or the development of relevant regulations

Service Limitations

This testing is not functional and is not intended to discover functional bugs. However, all discovered functional defects will be noted and presented to the customer.

Related Services:

Tools and licences

Table of contents

    Related insights in blog articles

    Explore what we’ve learned from these experiences
    15 min read

    Top 10 Load Testing Tools for 2025: The Deep Dive

    best load testing tools preview
    Sep 9, 2025

    Effective testing is all about choosing the best load testing tool, which is just right for you. Top performance testing tools help simulate virtual users and execute test scripts. As the software market is full of various options ranging from open-source to premium, it’s difficult to find the best load testing tool for your business. In this article, we will share our list of top software load testing tools and take a closer look at their pros and cons.

    4 min read

    Website Load Testing Tutorial for QA Engineers

    website load testing with pflb preview
    Sep 8, 2025

    Performance testing is no longer reserved for specialized engineers. In the AI era, QA professionals can extend their functional testing skills to include load testing because new tools automate the most challenging aspects. PFLB offers an AI‑powered load testing platform that eliminates manual scripting and data analysis, letting you build realistic tests and receive detailed […]

    9 min read

    Why Your Software Needs a Performance Testing Strategy?

    why your software needs a performance testing strategy preview
    Sep 5, 2025

    Building software is one thing. Making sure it performs well when real people depend on it is another. An app might look great in development, pass internal reviews, and even impress beta testers, but the real test comes when it faces unpredictable traffic, poor connections, or heavy workloads. A well-planned performance testing strategy removes the […]

    9 min read

    PageSpeed Insights A Complete Guide

    pagespeed insights preview
    Sep 2, 2025

    When a page loads too slowly, people leave before they’ve even seen your content. For businesses, that means missed opportunities and lower visibility in search results. PageSpeed Insights, the tool from Google, was built to highlight exactly why a site is slow and what can be done about it. Instead of guessing, you get a […]

  • Be the first one to know

    We’ll send you a monthly e-mail with all the useful insights that we will have found and analyzed