Database Load testing using Jmeter..!!

Elements used:
    1. JDBC connection Configuration
    2. JDBC request
    3. Graph result
    4. View result tree
    5. View result in table
Detailed Steps:
To configure JDBC with Jmeter, first download the JDBC driver from this Link and then paste the driver JAR file under Jmeter/lib folder. Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
1. Thread Group: -
    a. No. of threads: - 10
    b. Ramp-Up period: - 0
    c. Loop Count: - 3
2. JDBC Connection Configuration
    a. Variable name: - jdbcconnect
    b. Connection Pool Configuration
        i. Max number of connections: - 0
        ii. Pool Timeout: - 10000
        iii. Idle Cleanup interval (ms): - 60000
        iv. Auto Commit: - True
        v. Transaction Isolation: - DEFAULT
    c. Connection Validation by Pool
        i. Keep-Alive: - True
        ii. Max Connection age (ms): - 5000
        iii. Validation Query: - Select 1
    d. Database Connection Configuration
        i. Database URL: - jdbc:sqlserver://192.168.0.209\sqlexpress;DatabaseName="(name of database)";
        ii. JDBC Driver class: - com.microsoft.sqlserver.jdbc.SQLServerDriver
        iii. Username: - " "
        iv. Password: - ***********
3. JDBC Request
    a. Variable name: - jdbcconnect
    b. Query type with table name.
4. Listener
    a. Table
    b. Tree