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 online 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
    More Blog Articles
    4 min read

    11 API Failure Causes and How To Solve Them

    api failures preview
    Jul 7, 2025

    When an API fails, the consequences ripple quickly through the entire system. Transactions stall, integrations break, and frustrated users flood your support channels. Understanding exactly why API failures happen — and how to fix them — is essential for developers and businesses alike. This article examines the most common reasons behind API failures, explores the […]

    6 min read

    API Mocking: A Complete Guide

    api mocking preview
    Jul 4, 2025

    Waiting for APIs to become available or stable can slow down entire projects. API mocking provides a smart way to avoid these roadblocks by simulating real API responses, keeping your teams productive and ensuring smoother integration down the line. In this guide, you’ll discover exactly what API mocking involves, how it differs from using real […]

    5 min read

    API Endpoint: A Complete Guide

    api endpoint guide preview
    Jun 30, 2025

    Modern applications rely heavily on APIs (Application Programming Interfaces) to communicate and exchange data across different systems. At the heart of this interaction lies the API endpoint — a fundamental concept that defines where and how data exchanges happen. This guide explains clearly what an API endpoint is, outlines its importance, and provides practical insights […]

    8 min read

    gRPC vs. REST: Detailed Comparison

    grpc vs rest preview
    Jun 24, 2025

    Choosing between gRPC and REST can feel confusing, especially if you’re trying to figure out the best way for your applications to communicate. This article breaks down the grpc vs rest comparison clearly, without jargon or confusion. You’ll learn exactly what each protocol is, the advantages and disadvantages of each, and understand why gRPC is […]

  • 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

    • People love to read

    Explore the most popular articles we’ve written so far