I am ready to pull my hair out with this one. I have been tracing a production server for a few days now in the hope to replay the trace on a Virtual server to see if the specifications of the new VM are sufficient.
So, being a good little DBA, I selected the trace for replay (verified that it contained all the events that will be required to replay the trace) and off it went. Being a busy server, it generated about 30GB worth of trace files across about 900 files. I So, I stopped the trace, deleted it, and copied these trace files to the new server.
Using the following code, I loaded the files into a trace table on the database:
SELECT * INTO replay_trace FROM ::fn_trace_gettable('L:\Replay_trace_Trace_replay.trc', default)
eventually it all loaded into the table.
I opened sql profiler, and loaded the trace from the table. when I press "replay - start", I get the following error:
"Unable to replay the current trace since certain events and columns required for the replay are not present" - it then goes on to list every event that the profiler needs for replay.
Now I know all the events have been selected. I verified this by checking the tracefile script, I checked the events in the table, and I took the time to open the gui, and load in just one of the files and selected that for replay, and that was happy to oblige and started replaying immediately.
Its almost as if the profiler isn't recognising the events that are in the table.
Its a SQL Server 2008r2, 64-bit standard edition.
Anyone had this experience before? any advice would be greatly appreciated.
Thanks