Write Benchmark Scripts

In general, you have to write special benchmark scripts rather than rewriting applications as benchmarks.

To write the benchmark script:

Volume is critical in performance simulation. A script roughly equivalent to an application, running at the normal production volume for that application, is usually better than a script functionally matched to an application, but running at only half the volume.

If workload is based on client PCs issuing Transact-SQL, you can use performance monitoring tools, available in the market, to capture data streams.