Sample Header Ad - 728x90

Show SQL Execution Plan on Trace Replay

0 votes
2 answers
70 views
I'm using Microsoft SQL Server Profiler to capture production trace data for replay on a dev server to test indexing changes. Capturing the trace is no problem: I am using a the "TSQL_Replay" trace template with the "Showplan XML Statistics Profile" event added. In the original capture, I can see the execution plan in the trace data. The problem is when I replay this trace data on the dev server. I don't see any option to configure the replay trace options. I can check "Display execution time" and get timings for individual queries but I can't see the execution plans that run when the trace is replayed. This is critical for determining how the new indexes are being used. I've tried running a separate parallel trace on the dev server while I replay the original trace, but replays don't seem to be picked up. Any advice on how to measure results when replaying a trace? I've tried playing with both RML Utilities and the Database Experimentation Assistant but haven't figured out how to get either of them working for this use-case.
Asked by Neil Laslett (177 rep)
Sep 30, 2024, 04:38 PM
Last activity: Oct 3, 2024, 05:04 AM