how to simulate concurrent operation? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to simulate concurrent operation?

I wonder there are tools/scripts/tricks to simulate accessing/modifing database by multi-user to estimate the concurrent performance. e.g. to test the correction of lock some rows by programme.
Yes there is tool called SQL 2000 Load Simulator. There is a nice demo here
http://www.microsoft.com/seminar/shared/asp/view.asp?url=/Seminar/en/20010710tnt1-27d3/manifest.xml
quote:Originally posted by tamsun I wonder there are tools/scripts/tricks to simulate accessing/modifing database by multi-user to estimate the concurrent performance. e.g. to test the correction of lock some rows by programme.
great, thx a lot ^_^
Tell us how is that tool, I haven’t done much work on this,. So you can share ur experience amoung us.
quote:Originally posted by tamsun great, thx a lot ^_^
]]>