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
  • 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

  • LoadRunner
  • Apache JMeter
  • MS Visual Studio
  • IBM Rational Performance Tester
  • Silk Performer
Table of contents
Let us know about your needs
We can provide multiple performance testing services and a lot more than that if the situation needs a far more complex approach.
Get a quote You’ll hear back from our tech account manager in one day if not sooner

Related insights in blog articles

Explore what we’ve learned from these experiences
More Blog Articles
11 min read

How Do Businesses Benefit from Frontend Performance Testing?

how do businesses benefit from frontend performance testing preview
Apr 15, 2024

Crucial bottlenecks are usually backend-related. That’s  why backend performance testing is generally regarded as a must. However, only 1% of companies perform frontend performance testing. They don’t consider that to achieve the best business results, one should combine the two types.  Let’s prove it. We will define their differences, emphasize the importance of conducting backend […]

11 min read

Roles and Responsibilities of Performance Tester

performance testing roles and responsibilities in a nutshell
Apr 9, 2024

The core of efficient performance testing is an experienced, certified and well-structured team of professionals, who have already worked in similar projects, and learned all the peculiarities of QA testing types, and protocols.  If consciously chosen, they can evaluate a product, test its behavior under a load, check its response time, etc., and thus, empower […]

11 min read

Tips for Efficient Web Application Performance Testing

tips for efficient web application performance testing
Apr 4, 2024

Performance testing is one of the most challenging components of web application testing. But it is worth it: if done right, performance testing can forecast product behavior and its response to user’s actions with an impressive amount of detail and precision. Irrelevant web performance test data or wrong metrics chosen during testing cost companies a lot of money and effort, while not monitoring your web application performance at all can lead directly to a crash, say, on Black Friday, if you are not prepared to handle an increased number of concurrent users. Business or product owners needn’t know exactly how to performance test a website, but it’s useful to have a basic understanding of procedures that you pay for. From this post, you can learn what web application performance testing is, when it should be done, and how. Then, you will be able to make an informed choice whether to hire testing specialists or run testing sessions on your own.

15 min read

Top Tools for Developers in 2024

top developers tools
Apr 2, 2024

The ratings of the best software development tools are time-sensitive: new tools emerge every now and then. Monitoring and mastering them is a full-time job, and sometimes a waste of time, too, since some oldies but goldies remain chosen by the team.  Having done all the hard choices for you, we are sharing our list […]

  • 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

    • People love to read

    Explore the most popular articles we’ve written so far