Database performance testing?

Hi all,

I don’t have a readily available idea on how to test database performance. Has anyone implemented anything like this? The closest idea that I have been introduced was to look at the Query Store that is available in SQL Server. My issue with it is that I have to manually still try to pull the charts and manually click ‘save as’ to get the CSV file that has the data.

2 Likes

I’ve used JMeter with JDBC requests.

Here’s a small tutorial on how to do it:

https://www.sqlshack.com/performing-a-load-test-on-sql-server-using-apache-jmeter/

Should get you up & running.

Also going to add: Apache JMeter - User's Manual: Generating Dashboard Report To make a fancy HTML report.

Hope it helps!

Kind regards
Kristof

2 Likes

Hello KristOf,

Thanks for your reply! I have not checked JMeter yet. I may have forgotten to mention that (most unfortunately) the application under test does not have any exposed endpoints. My initial instinct when presented with the problem was to use Locust (I’m more familiar with Python so I thought I’d go that route), but upon learning that there are no exposed endpoints the idea evaporated pretty quick. Does JMeter hit the database directly or does it perform a load test via the API?

Edit: Ok so it does look like Locust also may still be on the table. I just peeked on a Medium article describing that as well. Create custom clients in Locust.io to test database performance | by Aritra Nayak | Analytics Vidhya | Medium

Regards,
Kevin

2 Likes

JMeter supports many protocols such as

  • Web: HTTP, HTTPS sites ‘web 1.0’ web 2.0 (ajax, flex and flex-ws-amf)
  • Web Services : SOAP / XML -RPC.
  • Database via JDBC drivers.
  • Directory: LDAP .
  • Messaging Oriented service via JMS.
  • Service: POP3 , IMAP , SMTP .
  • FTP Service.

You could run the performance test from the same machine/server if that would work or the same network.

2 Likes

@f00dog : You can go for jmeter, loctus , gatling.
Just see your requirement and your familiarity with tool.

If all are new then go for Jmeter and if you want to need to extend Jmeter and looking for something paid that go for https://www.blazemeter.com/