Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [load-testing]

11 questions
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 have been tasked with "proving" that the new platform won't…
Iridescent
  • 41
  • 4
2
votes
3 answers

Best way to test index changes outside of production

We have a massive MS SQL Server production environment with thousands of tables in dire need of index tuning & pruning. Any suggestions on the best ways to test proposed changes outside of production? Obviously, we can (and do) stand up a DEV…
Neil Laslett
  • 177
  • 1
  • 1
  • 7
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, hence I connect into my database into postgresql…
Dimitrios Desyllas
  • 873
  • 2
  • 14
  • 30
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, transactions take a very high time to process. This lasts…
DraxDomax
  • 129
  • 5
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-log-player to play the sql queries and use the…
Trying
  • 213
  • 1
  • 3
  • 8
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 30 seconds every query time is about 10-50ms,…
vadimb
  • 125
  • 1
  • 6
0
votes
0 answers

Why load test on postgres database getting worse result while changing default parametes to get better performance?

I want to have a load test on my postgresql database named dvdrental.While using postgres default parameters in postgresql.conf file , my database performance is pretty better than other situations.My node is about 8GB of RAM and 4 cpu cores. The…
mahdi
  • 1
  • 3
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 data in the application. I am not concerned with…
Appleoddity
  • 334
  • 3
  • 18
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 b_table.a_id=a_table.id join c_table on b_table.c_id=c_table.id As you can…
Dimitrios Desyllas
  • 873
  • 2
  • 14
  • 30
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 loader.io for the tests. I'm testing a very simple API that perform this…
Stefano Giacone
  • 111
  • 4
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? Thank you.
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37