Query/Workload Generator

Hello,

- Is any body aware of a random workload/query generator such as the
TPC-H query generator (QGEN) ? I am looking for a query generator that
takes a schema as an input, and produces several queries.

I need it mainly for performance evaluation. the generator I am looking
for should produce SELECT queries, including joins, and not only INSERT
INTO, DELETE, UPDATE queries such as the "SqlQueryGenerator" at
http://www.tucows.com/preview/297930

Thanks

Regards,
Abdur-RahmanThe SQL 2000 Resource Kit has a tool called DB Hammer (or something
similar) which you can use to generate workloads. But I've never used
it myself, so I can't tell you if it's as easy as just pointing it at a
schema.

A general problem with tools which generate artificial workloads is
that they may not reflect your real workload patterns very well -
there's usually no way for the tool to know which tables or procs are
most frequently accessed. So another approach you might consider is
using Profiler to get a workload trace, then replay it in a test
environment while you gather whatever performance information you need.

Simon|||The SQL 2000 Resource Kit has a tool called DB Hammer (or something
similar) which you can use to generate workloads. But I've never used
it myself, so I can't tell you if it's as easy as just pointing it at a
schema.

A general problem with tools which generate artificial workloads is
that they may not reflect your real workload patterns very well -
there's usually no way for the tool to know which tables or procs are
most frequently accessed. So another approach you might consider is
using Profiler to get a workload trace, then replay it in a test
environment while you gather whatever performance information you need.

Simon