1. Before applying jmeter to pressure, there is an important port that needs to be manually found. This port is to be used in the third section.
Start--Program--microsoft SQL Server 2008r2--Configuration tool--sql Server Configuration Manager
Go to SQL Server configuration Manager, click on the SQL Server Network Config--mssqlserver protocol, select the right side of TCP/IP, right--Properties--click on the "IP Address" tab of TCP dynamic port
2. Download on-line: Sqljdbc4-3.0.jar into the jmeter lib directory;
3. Set the database url:jdbc:sqlserver://ip:port;databasename=dbname when setting the JDBC Connection setting in the JMeter
4. The JDBC driver class is constant, Com.microsoft.sqlserver.jdbc.SQLServerDriver
5. Username,password settings are correct.
6. JMeter when processing query statements, quotation marks are used only in single quotes and should be consistent with quoted single quotes in the database.