|
Home > Archive > MS SQL Server > March 2006 > Procedure to Stress Test
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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?
Thanks
| |
| Linchi Shea 2006-03-14, 1:23 pm |
| There 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
>
>
>
| |
| sqlfan 2006-03-15, 3:23 am |
| Check out LoadRunner from Mercury.
|
|
|
|
|