January 8, 2009 at 1:05 am
Hi Folks,
I tried to replay a trace that ran for 2 hours. The trace took 3 mins to run. Why is the trace taking so fast. The last thing the trace says is
Replay server: AUBRIDESQL01\spare
Total events = 79768
Replayed events = 45987
Provider errors = 2166
Internal errors = 0
Total errors = 2166
Provider hit ratio = 95.29 %
Internal hit ratio = 100.00 %
Overall hit ratio = 95.29 %
Replay time = 0 hr 3 min 46 sec 565 ms
January 8, 2009 at 7:42 am
There are two ways to replay a trace. One where it it waits to mimic the real run time and one where it does not. So for example if the trace was waiting for 15 minutes for a query and doing nothing, one replay method will wait 15 minutes and one will run it immediatly (in sequence of other events) rather than waiting.
January 8, 2009 at 3:50 pm
thanks I'll check it out.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply