CODEWITHSUNDEEP
sql-servertestingloaddatabase-connectionconnection-pooling
DomBat
DomBat

Reputation: 2113

Testing multiple connections to SQL Server

We're migrating SQL2005 Enterprise to SQL2012 Enterprise (on a new server too, from WIn2003 to Win2012).

Is there a way to test multiple connections to the database to prove it can take the same load as the previous server?

The application is a website, .Net3.5 with Min and Max pool size set in the connection string.

Upvotes: 0

Views: 796

Answers (1)

Dmitri T
Dmitri T

Reputation: 168207

You can do it via Apache JMeter and next few steps:

  1. Download jTDS JDBC Driver and drop it to /lib folder of your JMeter installation
  2. Restart JMeter
  3. Add Thread Group to Test Plan and configure virtual users and iterations count

  4. Add JDBC Connection Configuration and provide JDBC url, driver class name and credentials

    • Database URL: jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
    • JDBC Driver class name: net.sourceforge.jtds.jdbc.Driver
  5. Add JDBC Request sampler and put your query there
  6. Repeat step 5 for all query types
  7. Add a listener, i.e. Aggregare Report

See The Real Secret to Building a Database Test Plan With JMeter guide for more detailed explanation of database load testing domain.

Upvotes: 1

Related Questions