1. Click Start, point to Programs, click Microsoft SQL Server 20XX (your version), click Performance Tools, and then click SQL Server Profiler.
2. On the File menu, click New Trace… to open the ‘Connect to Server’ dialog box.
3. In the Server name box, type the name of the SQL Server.
4. In the Authentication list, click SQL Authentication.
5. Type the system administrator user name and the password, and then click Connect to open the Trace Properties dialog box.
6. Key a trace name. Click the Events Selection tab, and then click to select the Show all events check box in the lower-right corner.
7. Select the server event classes to trace:
a. Expand Cursors, and then click to select the following check boxes:
b. Expand Errors and Warnings, and then click to select the following check boxes:
•Missing Column Statistics
c. Expand Locks, and then click to select the following check boxes
•Lock: Deadlock Chain
d. Expand Performance, and then click to select the following check boxes:
e. Expand Sessions
•ExistingConnection (may already be selected by default )
f. Expand Stored Procedures and click to select the following checkboxes:
•RPC:Completed (may already be selected by default )
Note By default, the RPC: Completed check box should be selected. Do not click to clear the RPC: Completed check box.
g. Expand TSQL, and then click to select the following check boxes:
•SQL:BatchCompleted (may already be selected by default )
Note By default, the SQL:BatchCompleted check box should be selected. Do not clear the SQL:BatchCompleted check box.
8. Click Organize Columns, and then make sure that the following columns appear in the Organize Columns dialog box:
•NT User Name
•DB User Name
9. Do not filter by user. We can do that on our end, as we like to see what else is running a the same time. But indicate which user it was when you return the trace file to us, otherwise it is assumed that the 'sa' user was used.
10. Click Run to run the trace and to capture SQL Server processes.
11. On the File menu, click Stop Trace to stop the trace.
12. On the File menu, click Save As, and then click Trace File.
3. Name the file, and then save the file.