I’m trying to use Benchmark Factory to load test the Microsoft SQL Server & database that we use with our application.
The computer is running Windows Vista Business and SQL Server 2000. I’ve turned on my SQL services and have the database I want to test on my local server.
I’ve started by creating a ODBC trace file by turning on tracing in Control Panel > Admin Tools > Data Sources (ODBC). Once tracing is turned on, I open our application, connect to our database, open something inside of the application, then stop the trace. (Trying to get a short trace file to start off with.) Next I open Benchmark Factory, Select the option under Microsoft SQL Server to Replay load from an ODBC trace file, select the log file, create the script, and run the job. It begins running and on the first error says:
Started test ODBC Trace (SQL)
Agent(SERVERNAME) Error: ODBC Error (37000,AA) - [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ‘’.
It continues, then says:
Test completed with errors.
** Job finished.
Total Time to perform the job:
Start Time: 11/11/2009 3:55:51 PM
End Time : 11/11/2009 3:59:14 PM
Elapsed : 0 Days 00:03:23.387
This is about all the output I get, it seems like every line has resulted in an error and there is no test data to display.