Microsoft has a link to a free utility for stress testing SQL Server installations here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;231619
You can also create a trace using Profiler while your application is running, capture this information, and then reload it into Profiler for analysis. Take a look at the Monitoring Server Performance subject in SQL Server Books on line.
Hope this helps.
My hovercraft is full of eels.