Open JMeter and create a skeleton test plan as shown below with two Thread Groups – one Thread Group for a database query using Microsoft Driver and another Thread Group for a database query using the jTDS driver.
Unpack the driver to a convenient local folder on your client after downloading. The jTDS driver may be downloaded from the following link: Once downloaded, unpack the driver to a convenient local folder on your client. If you’re using Java 7, then choose version 4.0 or 4.1 for download: You’ll need Java 8 if you wish to use the 4.2 or 6.0 JDBC drivers from Microsoft. The Microsoft JDBC Driver may be downloaded from the following location:
To be perfectly honest, I’m posting this not because the process is particularly complicated or cumbersome – rather it’s largely for my own reference so that when I need to do this again in a year or two I’ll have my own quick start reference. In the steps which follow I’ll show the basic setup necessary for using JMeter with two alternate JDBC drivers: The Microsoft JDBC Driver for SQL Server, and the open source jTDS JDBC Driver for SQL Server. This blog entry shows how configure JMeter to run a simple query against a SQL Server database.
0 kommentar(er)
