hvermaak (6/5/2013)
Open profiler,File, new trace.
Connect to your sql server.
Use the template -> select Tuning
select save to file -> choose a location with sufficient space
I would strongly recommend not running Profiler GUI against a production server that's already under load. The GUI can have a severe impact on the target server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability