see if this tool can simulate some load on the database

http://www.quest.com/benchmark_factory/

I think they allow you to download a trial copy.

Disclaimer : I have never used it.

BTW, if you use the tool (and may be buy it ).. and like it, please post a review for us here, so that we all can learn from your experience/