App Control: How To Collect a SQL Server Profiler Trace

App Control: How To Collect a SQL Server Profiler Trace

Environment

  • App Control: All Versions
  • Microsoft SQL Server: All Supported Versions

Objective

To capture a SQL Server Profiler trace

Resolution

  1. Launch SQL Server Profiler
  2. When the "Connect to Server" dialog appears, select the server that hosts the das database and click "Connect"
  3. Click "Events Selection" tab
  4. Click Show all columns
  5. Click Column Filters and add DatabaseNamelike das > click "OK"
  6. Click "Run"
  7. Reproduce the issue
  8. Click "Stop Trace"
  9. Click File > Save as > Trace File > Select Location and hit "Save"
  10. Upload the resulting .trc file to the CB Vault.
  11. Once upload is complete, please comment in the case that the files should be available for review.

Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎07-29-2021
Views:
36
Contributors