Summary
Learn how to generate a trace file using MS SQL Profiler. Creating a trace file is useful when troubleshooting database-related issue.
Details
- Run the MS SQL Server Management Studio.
- Go to Tools > SQL Server Profiler.
- Provide a name under Trace name.
- Use the “Standard (default)” template.
- Click Save to File.
- Provide the path and filename for the file to be saved.
- Adjust the Set maximum file size (MB) accordingly.
- Retain the default Enable file rollover.
- Click Run to start the trace.
Click image to enlarge.
- Replicate the issue on hand. Once completed, press the Stop button (red button).
- Submit the trace file to Trend Micro Technical Support.
Click image to enlarge.
Note: Install the SQL Server Management Tools if SQL Server Profiler is not present under the Tools option.
For more information, refer to this Microsoft KB article: Install SQL Server Management Tools.