This experiment system is composed of three machines: SQLServer, TPCServer and TPCClient. There is a 1GB TPC Benchmark Database on SQLServer. We assume that you have installed Microsoft .NET Version 2002 on your TPCServer and TPCClient.

To run the experiment, first copy the source code to both your TPCServer and TPCClient, and then do the following steps:

1. set Path
On both TPCServer and TPCClient, Add these to the path:
C:\WebservicePerf\bin;
C:\WINNT\Microsoft.NET\Framework\v1.0.3705;
C:\Program Files\Microsoft Visual Studio.NET\vc7\bin;

2. Add Environment Variables on TPCClient
Variable Name: DSS_DIST
Variable Value: C:\WebservicePerf\bin\dists.dss
Variable Name: DSS_QUERY
Variable Value: C:\WebservicePerf\TPCBenchmark\queries

3. Generate the configuration files on both sites
(a). Modify the file C:\WebservicePerf\TPCBenchmark\config\ClientController.config, put your TPCServer name in url.
(b). Modify the file C:\WebservicePerf\TPCBenchmark\config\TPCBenchmark.conf, put your TPCServer name in the ServiceHost item.
(c). Run C:\WebservicePerf\TPCBenchmark\config\ConfigFileGen.exe to generate the configuration files, using command line: ConfigFileGen -f TPCBenchmark.conf

4. On TPCServer site, modify the file C:\WebservicePerf\TPCBenchmark\TPCServer\TPCServer.cs:
private static readonly string ourConnectionString = "User ID=DATABASE_ACCESS_ACCOUNT; Password=DATABASE_ACCESS_PASSWORD;initial catalog=DATABASE_NAME;data source=SQLSERVER_NAME; Connection Timeout=6000;Max Pool Size=1000";

5. Compile
(a). On both sites, use makefile to compile the cs file in the following directories: ChannelInitializer, NZipCompressedSinks, XMillCompressedSinks, TrafficMonitorSinks. Use command line:
nmake clean
nmake
(b). On TPCServer, compile the cs files in directory C:\WebservicePerf\TPCBenchmark\TPCServer
(c). On TPCClient, compile the cs files in directory C:\WebservicePerf\TPCBenchmark\client
(d). Copy the file TPCServer.dll to the directory of C:\WebservicePerf\TPCBenchmark\client on TPCClient

6. Start SQL Server on SQLServer machine

7. Run the experiment on one specific configuration
Execute the file C:\WebservicePerf\TPCBenchmark\TPCServer\server.exe on TPCServer, and execute the file C:\WebservicePerf\TPCBenchmark\client\client.exe on TPCClient.
Usage:
-c[t|h] Using TCP or HTTP channel
-f[b|s|x|cb|cs] Using BINARY, SOAP, XMillCompressedSOAP, NZipCompressed BINARY or NZipCompressed SOAP formatter;

8. Run the experiment on all the configurations
Execute the file C:\WebservicePerf\TPCBenchmark\TPCServer\runserver.exe on TPCServer, and execute the file C:\WebservicePerf\TPCBenchmark\client\runclient.exe on TPCClient.

9. Output
*.time.log files: The response time of query10 are listed followed by the average response time.
*.traffic.log files: Bytes of request, bytes of response and bytes of request&response are listed.

Download software