Questions tagged [load-testing]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers

Best way to model load test for performace requirements of database

For instance, imagine this requirement for a certain query in the database: The database needs to handle L of those queries a year. a% of the queries need to have less than 30ms What is the best way ...
Vitor Figueredo Marques's user avatar
4 votes
1 answer

Performance Regression Testing / Load Testing on SQL Server

What tools or best practices exist to demonstrate a new server instance is "as capable" as an older one? We're moving from an EC2 hosted instance of MS SQL Server to an RDS instance, and ...
Iridescent's user avatar
0 votes
1 answer

How to loadtest network throughput between two systems when one is a cloud database server?

I am troubleshooting query performance issues when running large queries against an AWS Redshift cluster. The majority of the time is spent transferring the data over the network and processing the ...
Appleoddity's user avatar
0 votes
1 answer

Replication testing is a Materialized view Refresh equivalent of continious update?

In my database I have the following a materialized view named materialized_view_test and the data are being feeded from 3 tables: select * from a_table join b_table on ...
Dimitrios Desyllas's user avatar
2 votes
0 answers

How I can find out which postgresql I am connected into when behind a load balancer?

I have the following database replication setup: As you can see I do a master-slave replication and I use aload balancer in order to connect into read-only replicas. So I want to test this setup, ...
Dimitrios Desyllas's user avatar
1 vote
1 answer

How to determine the root cause of a performance spike during a heavy load on DB2?

I am testing the performance of an application that links to a DB2 database engine at the back end. Looking at the transaction timer logs, I see that on the 37'th minute into the test run, ...
DraxDomax's user avatar
  • 129
1 vote
2 answers

mysql performance test

We are planing to test the performance of the new DB server. For that we have the below the plan: get production sql queries replay those sql queries against the different DB I was planing to use pt-...
Trying's user avatar
  • 203
1 vote
1 answer

MongoDB query execution time

I'm using Locustio service as load testing tool for my app. Without details, I'm using the same aggregation query with simulated 100 users, in this case RPS (requests per second) is about 20. In first ...
vadimb's user avatar
  • 125
0 votes
2 answers

Mysql show no more than 5 concurrent connection

I'm performing some load tests on my brand new server Apache/PHP/Mysql (Bitnami LAMP stack ). I'm using AWS with 1 EC2 instance behind a loadBalancer. At the moment I'm using for the tests. ...
Stefano Giacone's user avatar
0 votes
1 answer

Is it possible to generate workload for hammerora (hammerdb for oracle) from AWR tables?

I'm trying to generate workload from our production databases but rather than running a trace file in production, I would prefer using the AWR tables since we have a license for it. Is it possible? ...
Nicolas de Fontenay's user avatar