How to Test Microsoft SQL Server Using JMeter(Performance Testing)

This video explains how to carry out performance testing on MS SQL Server Using JMeter
For mySQL • How to Test MySQL Data...
For all tutorials visit: www.kindsontheg...
Subscribe Kindson The Tech Pro UA-cam: bit.ly/2PpJd8Q
Join my group ICS on Facebook: bit.ly/2UULiQj
Follow me on Instagram - / kindsonm
Connect with me on LinkedIn: / kindson
Follow me on Twitter: / kindsonm
Learn about me: www.kindsontheg...
More on: www.datarmatics...
Canon in D Major by Kevin MacLeod is licensed under a Creative Commons Attribution license (creativecommon...)
Source: incompetech.com...
Artist: incompetech.com/
JMeter Tutorials

[@bhushandeshmukh1840]

Superb! I have been searching for a SQL Stress test solution for a long time, did used couple of other open source softwares but JMeter approach seems really a long term solution. Great explanation skills.

[@escapetothesky]

Thank you. Was able to follow along quite well and set it up successfully on my end.

[@KindsonTheTechPro]

Great 😊

[@edgaruvaldogarciavelazquez6417]

You´re the best! For a long time I did search this, thanks so much!

[@KindsonTheTechPro]

Glad I could help!

[@GOLDY-em2vy]

Thank you...its very useful.

[@KindsonTheTechPro]

You are welcome

[@ashisswarn2781]

Very well explained!! Thanks!!

[@Arunkumar-pp8oo]

Great Video sir

[@nateCA]

Great video! Very helpful!

[@thedevilinmask]

How to test a DB which has Windows Authentication?

[@shamilsaleem9444]

Awesome. Thanks a lot!

[@KindsonTheTechPro]

You are welcome !

[@pratheepkumar4218]

Hi , currently I'm working in functional testing. I have 3 years of experience. Is it possible to switch the performance testing role. What's the package . What are the skillset needed.

[@rajatnarang5683]

Hi i am getting a error of cannot load jdbc class i am already add jdbc jars in test plan and lib folders

[@jayperformancetesting6537]

I am getting error cannot create jdbc driver of class

[@vuhoangnam4043]

anyone here I got an error that cracking my head: Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:0a5b5205-a019-4a47-8314-fc65e6566bfe)

[@periscopecinema]

Add " ;trustServerCertificate=true; " to your connection string.. it should resolve this issue...

[@RajnishDubey1988]

Remove the background music, we are already in stress while doing this stress test.

[@agustinandres6451]

I'm getting this error:
Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory (El controlador no pudo establecer una conexión segura con SQL Server con el cifrado de Capa de sockets seguros (SSL). Error: "sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target".
I don't know how to connect the dll auth

[@agustinandres6451]

I solve it with adding this to the url:
encrypt=false; trustServerCertificate=false;

[@vuhoangnam4043]

@@agustinandres6451 I did as you guided but not work, my message is: Response message:java.sql.SQLException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:0a5b5205-a019-4a47-8314-fc65e6566bfe)

[@bahodurmamadjonov3590]

@@agustinandres6451 thanks a lot, it worked for me too, required to add in Database URL after database name!

[@sarathr4495]

Music was irritating

[@KindsonTheTechPro]

@sarathr4495 thanks for the feedback

[@BelmontFPV]

The music is super annoying.