How to create a database trace for WATS support team

This article applies to WATS on-premises only

In some cases, the WATS support team may require a trace to investigate an issue. This article briefly describes this process.

Starting SQL Server Profiler

Windows Server 2019 or later, with SQL Server tools installed:

• Press the Windows button
• Type “Profiler”
• Choose SQL Server nn Profiler, where nn is the version number, for instance 2014.

Starting a trace

When SQL Server Profiler has opened:

• File
• New trace…
• Enter the server name/credentials for your database server, and connect

In the Trace Properties dialog box

• You may enter a name for your trace
• Use the template: TSQL_SPs
• Go to the Events Selection Tab
• Press Column Filters button to open the Edit filter dialog
• Select TextData
• Expand Like
• Type the information provided by the support technician
• Check the “Exclude rows that do not contain values” box
• Click OK to close the Edit filter dialog
• Press Yes in the warning dialog box
• Press Run

Now, reproduce the error/situation that the support technician should investigate.

To stop and save the trace file:

• Press the red stop button on the toolbar.
• File
• Save As
• Trace File
• Save the file, and send it to the support technician