Procedure to Stress Test

Could someone write for exact SQL statment to stress test my tempDB, or
production.db?
(assume physical location is E:\Data\tempdb.MDF)
In order to test exact size of productionDB, should I copy the mdf file,
rename, and attached as different database to do it?
ThanksThere is no single exact SQL statement to stress your database, tempdb or
otherwise. One of the easiest ways is stress a database is to run a variety
of SQL statements using multiple clients concurrently. The more clients you
can run, the more stress you can put on the database, within reason. But of
course your SQL statments could be poorly written so that they end up not
stressing the database but generating just overhead.
Linchi
"MC" wrote:

> Could someone write for exact SQL statment to stress test my tempDB, or
> production.db?
> (assume physical location is E:\Data\tempdb.MDF)
> In order to test exact size of productionDB, should I copy the mdf file,
> rename, and attached as different database to do it?
> Thanks
>
>|||Check out LoadRunner from Mercury.