Intro
Most Synergize transactions are database queries that run in the back end of SQL. When processing documents within Synergize becomes slow, there is the possibility that there are performance issues within SQL that need to monitored. Running the SQL Profiler trace will allow administrators to determine what Synergize transactions are occurring when issues are being reported.
Purpose
To setup SQL Profiler to trace information about SQL activity.
Steps
- From SQL server, launch SQL Server Profiler
- From the menu, select File > New Trace
- Enter your credentials or choose Windows authentication
- In the Events Selection Tab of the Trace Properties dialog, check the checkboxes:
- Show all events
- Show all columns
- Click the Column Filters button
- Select the DatabaseName from the left pane and on the right pane, expand the Like node as see in images below
- Enter the Repository Name and click OK
- In the Trace Properties Dialog, uncheck all Events that are selected by default then check the following events under TSSQL:
- SQL: StmtCompleted
- SQL: StmtStarting
- If you need deadlock information, check these events under Locks
- Deadlock graph
- Lock: Deadlock Chain
- Lock: Deadlock
- Click Run to get the tracing started immediately
Use the Stop button after a deadlock is reported by the testing program.
Occasionally, if the trace becomes too large (more than 100000) click the erase icon to start from the beginning.
To save the trace, click File > Save As… from the menu.
If there are any issues with this, contact support at 905-881-6071 ext. 290 or email support@microdea.com.