Atlassian-log-analysis returning java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLS

[Lesley Freemonth]

Hello,

we are trying to test some database performance issues when we upgrade from 7.3 to 8.5.3. we are trying to use the atlassian-log-analysis-0.1.1.jar as referenced Here to generate a comprehensive output but we are hitting a snag.

here is the code we are using

D:\JIRA>.\jre\bin\java -cp D:\atlassian-log-analysis-0.1.1.jar;.\lib\mssql-jdbc-7.2.1.jre8 ^
com.atlassian.util.benchmark.JIRASQLPerformance ^
JIRADBUSERNAME JIRADBPASSWORD ^
jdbc:sqlserver://;serverName=uswegpsqld09;portNumber=1433;databaseName=jiradb com.microsoft.sqlserver.jdbc.SQLServerDriver ^
> db-perf-test.txt

 The error we receive is this.

Usage: java com.atlassian.util.benchmark.JIRASQLPerformance user password url driverClass [noOfRuns]
Exception in thread "main" java.lang.IllegalArgumentException: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at com.atlassian.util.benchmark.ConnectionFactory.<init>(ConnectionFactory.java:21)
at com.atlassian.util.benchmark.JIRASQLPerformance.main(JIRASQLPerformance.java:40)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.atlassian.util.benchmark.ConnectionFactory.<init>(ConnectionFactory.java:17)
... 1 more

I am at a loss for what to do next. just an FYI, the SQL server is on a different VM than the Application server. when we run the equivlenet code on the old application server, which has the SQL server installed together on the same VM, it runs perfectly fine. 

What am i doing wrong?

[Gonchik Tsymzhitov]

hm, driver has not been recognized. 

Also, uploaded the code here for the easier test it

https://github.com/AUGSpb/atlassian-support-benchmark