jaganeee - Friday, November 3, 2017 1:07 AM
One option on 2008 is to use a Reply Trace. It does have some requirements and takes a bit to get working correctly so research it if you go down that direction. Here are a couple of links to get you started:
Replay Traces
Using the REPLAY feature within SQL Server Profiler
There are a lot of third party products that also do similar testing. You may also want to just do some general stress testing. Adam Mechanic developed a free tool, SQLQueryStress quite awhile back but it's still fairy popular. In case you want to check that tool, it's up on GitHub:
SQLQueryStress
Sue