Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

Creating a trace file using Microsoft SQL Profiler

    • Updated:
    • 14 Sep 2015
    • Product/Version:
    • Deep Security 8.0
    • Deep Security 9.0
    • Deep Security 9.5
    • Deep Security 9.6
    • Platform:
    • N/A N/A
Summary
Learn how to generate a trace file using MS SQL Profiler. Creating a trace file is useful when troubleshooting database-related issue.
Details
Public
  1. Run the MS SQL Server Management Studio.
  2. Go to Tools > SQL Server Profiler.
    Navigating to SQL Server Profiler
  3. Provide a name under Trace name.
  4. Use the “Standard (default)” template.
  5. Click Save to File.
  6. Provide the path and filename for the file to be saved.
  7. Adjust the Set maximum file size (MB) accordingly.
  8. Retain the default Enable file rollover.
  9. Click Run to start the trace.
    Configuring trace properties
    Click image to enlarge.
  10. Replicate the issue on hand. Once completed, press the Stop button (red button).
  11. Submit the trace file to Trend Micro Technical Support.
    Trace file sample
    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.
Premium
Internal
Rating:
Category:
Configure; Troubleshoot
Solution Id:
1105063
Feedback
Did this article help you?

Thank you for your feedback!

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.

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


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.


Need More Help?

Create a technical support case if you need further support.