How to capture a SQL Profiler Trace and export results.

How to capture a SQL Profiler trace, and then export the results.

Procedure Steps

1. Log into SQL Management Studio and select Tools > SQL Server Profiler.  
2. Log into the SQL Server database as a user with permission to perform a trace.
3. Select the Events Selection tab and then click [Column Filters].
4. Configure the filters to show what you want to see in the trace. Helpful items include ApplicationName, LoginName, and ClientProcessID. For example, if you want to capture traffic between the LS Communication Server and the database, you could use ApplicationName Like lnlcomsrvr.exe.
   
5. Click [OK], then click [Run]. The trace starts.
6. Reproduce the issue then stop the trace using the buttons at the top of SQL Profiler.
7. Save the file as a Trace File for review and send the file to LenelS2 Technical Support Group.

Applies To

• SQL Management Studio
• SQL Server (all supported versions)

Additional Information

For additional information on permissions required to perform a SQL Profiler Trace, see the following Microsoft document:

https://docs.microsoft.com/en-us/sql/tools/sql-server-profiler/permissions-required-to-run-sql-server-profiler?view=sql-server-2017

Copyright © 2022 Carrier. All rights reserved.