Is there a good stress test tool for SQL?  Looking for soemthing simple to
use.  Would be very nice to have one that could give hypothetical
information.  For example what happens is I add more ram.

Thanks
Greg

I have on ejust here, don´t know if it´s possible to give it away... It was
a tool from the SQL Server Ressource Kit :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro01/html/sql01f1.asp

It is called "SQL LOad Simulator"

But ohter possibilies are listed here:

http://www.windowsitpro.com/Article/ArticleID/14177/14177.html


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---

Show quoteHide quote

Two tools from Microsoft, SQLIOStress and SQLIO are great:

http://msmvps.com/epprecht/archive/2004/07/24/10591.aspx

Show quoteHide quote

IF there is an application that uses your SQL Db, you can use WAST or
"Application Center Test (ACT)" to Drive the application, hence stressing
the SQL Db.

That is what I've done in the past.

As long as you run the exact same stress script everytime and capture the
exact same counters, etc this can provide very useful information.


Greg Jackson
PDX, Oregon

Variable Number of Parameters
how to know if a DEFAULT exists or not
how do I search for duplicate values in normalized data ?
Query's in Query Analyzer sometimes extremely slow
SQL Enterprise Manager Question
Informational Queries
Blank Database Name
Urgent help with error
Optimization job failing
What query is locking a table?