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
Last activity: Oct 3, 2024, 05:04 AM