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.
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?