August 17, 2011 at 10:17 am
I have set up a profiler trace for capturing execution plans of a queries in a workload, but when I export it to a script, the settings under the "Events Extraction Settings" tab are not included in the script.
I have set the trace to save XML Showplan events separately, and I'm capturing the "Showplan XML Statistics Profile" event.
How can I include the settings under the "Events Extraction Settings" tab in the trace definition script?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
August 22, 2011 at 12:31 pm
I still haven't figured this out; any ideas anyone?
Here is a link that describes how I am doing this through SQL Profiler UI:
http://msdn.microsoft.com/en-us/library/ms179321(v=SQL.100).aspx
However, when I attempt to save it as a trace script, the settings for saving the query plans as files are not available in the resulting script.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply