Profiler replay option

microsoft.public.sqlserver.tools

11 May 2007 5:58 PM

FredDBA

using SQL Server 2005 profiler,
I would like to simunlate the Prod activity into another server. It seems
that
when I replay the logs it goes all the way down "as fast as possible"
without regards of the timing. Let's say I trace 3 queries with a 30 secs
delay between them, so I trace for 1m. When I replay this log onto another
server it takes half a second and it's all done.
I do not see any options to allow a replay to respect the timing in which
the trace was recorded. It has the datetime for each line so this should be
an easy thing to do, no? If I remember correctly, I think with SQL Server
7.0 it was possible to do this since it had a replay rate option.

Don't tell me they removed this feature ... please!

Thanks
FredDBA