x

Trace Replay Problems

A little background:

I need to record a trace in production and replay in another environment. Production has sensitive data that must be scrubbed from the trace before it can be moved out of that environment.

I've imported the trace into a SQL table, scrubbed the data, and exported for playback to a new trace file. I've also bcp'd into a new trace table.

Whenever I try to replay the scrubbed trace, it does nothing. The replay stops immediately and I get the following output:

 Replay server: servername Total events = 595354 Replayed events = 0 Provider errors = 0 Internal errors = 0 Total errors = 0 Provider hit ratio = 0.00% Internal hit ratio = 0.00% Overall hit ratio = 0.00% Replay time = 0 hr 0 min 0 sec 250 ms 

Per Books Online I've made sure logins match on both servers. The databases also match by name, but not by ID. I've tried replaying both the scrubbed file and table, but get the same results.

I'm about to replay the raw trace on another production machine just to see if it works at all, but ultimately I need a scrubbed trace that can replay elsewhere.

Has anyone done something similar? Or can point out problems I might have missed? Has anyone modified trace data and replayed it successfully?

Thanks.

UPDATE: the trace played back successfully with a few minor errors. I will next attempt a playback with a truncated portion of the trace.
more ▼

asked Feb 24, 2010 at 04:12 PM in Default

robvolk gravatar image

robvolk ♦
140 1 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I tried three times unsuccesfully to alter the DBID values in the trace file by exporting from Profiler to a SQL table, updating, and re-importing the table to Profiler as trace data. Profiler refused to Replay it, but I forgot what it complained about. However, I found it easy to renumber the DBID values of the target databases in my sandbox by DETACHing and reATTACHing them. This made it possible to replay my production trace in the sandbox.

I have not found a credible explanation of the "hit ratio" report. I've seen a guess that it is about cache hit ratios, but I doubt it. ,I tried three times unsuccesfully to alter the DBID values in the trace file by exporting from Profiler to a SQL table, updating, and re-importing the table to Profiler as trace data. Profiler refused to Replay it, but I forgot what it complained about. However, I found it easy to renumber the DBID values of the target databases in my sandbox by DETACHing and reATTACHing them. This made it possible to replay my production trace in the sandbox.

I have not found a credible explanation of the "hit ratio" report. I've seen a guess that it is about cache hit ratios, but I doubt it.
more ▼

answered Feb 26, 2013 at 12:21 AM

ShakyKnees gravatar image

ShakyKnees
50 1 1 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x34
x18
x3

asked: Feb 24, 2010 at 04:12 PM

Seen: 1352 times

Last Updated: Feb 26, 2013 at 12:21 AM