snippetMinor
Tool to create a TSQL script from a SQL Server 2008 trace file
Viewed 0 times
scripttsqlfile2008createsqlserverfromtracetool
Problem
Are there any tools available to create an executable tsql script from a SQL Server trace file?
Is there an easy manual way?
Is there an easy manual way?
Solution
You could use ClearTrace by Bill Graziano (free) which cleans up trace queries and allows you to sort/filter the trace files and still have a readable tsql from the trace.
Courtesy reference of Brent Ozar's presentation on "Using Perfmon and Profiler" at SQL Bits 2010
Courtesy reference of Brent Ozar's presentation on "Using Perfmon and Profiler" at SQL Bits 2010
Context
StackExchange Database Administrators Q#8029, answer score: 3
Revisions (0)
No revisions yet.