Creating a trace file using Microsoft SQL Profiler

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.
Replicate the issue on hand. Once completed, press the Stop button (red button).
Submit the trace file to Trend Micro Technical Support.

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.

Rating:

Category:

Configure; Troubleshoot

Solution Id:

1105063

Feedback

Did this article help you?

Thank you for your feedback!

What was the problem with this article?

The image(s) in the article did not display properly.

The article did not provide detailed procedure.

The article is hard to understand and follow.

The video did not play properly.

The article did not resolve my issue.

Others. Please specify.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

Thanks for voting.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.