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

  1. 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
  2. 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
  3. Test preparation
    • Checking the operability of the test environment
    • Installing the testing tool on the load stations
    • Tuning the monitoring tools
    • Conducting trial tests
  4. 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
  5. 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

  • LoadRunner
  • Apache JMeter
  • MS Visual Studio
  • IBM Rational Performance Tester
  • Silk Performer
Table of contents

Related insights in blog articles

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

Software Testing Conferences in 2024

software testing conferences preview
Feb 22, 2024

We have compiled a list of the best software testing conferences to visit in 2024. In this article, we’ll explore the why, what, and how of attending these conferences, shedding light on the latest trends, must-attend events, and tips to maximize your experience. The Software Testing Methods Conference aims to unite academic scientists, researchers, and […]

5 min read

TestCon Europe 2024: Your Gateway to the Future of Software Testing

testcon europe 2024 preview
Jan 30, 2024

TestCon Europe 2024, the premier software testing conference, comes to Vilnius, Lithuania, from Oct 22-25. Join experts and enthusiasts onsite or online to explore the evolving landscape of software testing. Topics include Shift-Left Testing, TestOps, AI-Powered Testing, and more. Don't miss your chance to be part of this enriching experience. Secure your spot today at TestCon's official page and be at the forefront of software testing excellence.

4 min read

DevDays Europe 2024 – Software Development Conference

devdays 2024 preview
Jan 24, 2024

DevDays Europe is the ultimate software development conference that aims to bring together the brightest minds and innovators in the software development community. Join the conference for an immersive experience filled with transformative insights, collaborative opportunities, and the latest cutting-edge technology. The DevDays Europe 2024 will be happening both on-site and online, allowing everyone to join the event in their preferred format.

6 min read

The Road to a Successful Software Release: an Inclusive Checklist

The road to a successful software release checklist
Dec 18, 2023

Releasing software is a multifaceted process that demands meticulous planning and execution. A software release checklist is a structured list of items and tasks that development and operations teams follow to ensure a successful release of a software product. This checklist serves as a comprehensive guide, covering various aspects of the software development life cycle. In a way, it substitutes for a roadmap, helping teams navigate the complexities of releasing software in a controlled and efficient manner. To ensure a triumphant launch, a comprehensive software release checklist is indispensable. In this guide, we will delve into the key aspects that demand your attention before the grand release.

  • Be first to know

    Once a month we’ll be sending you a letter with all the useful insights that we could find and analise