Mastering SQL Trace Using Profiler - Microsoft SQL Server 2012 Performance Tuning - page 5

6. Click on the Events Selection tab. On this screen, the events that are predefined

for the Standard (default) trace template are selected and shown in grid. Check
the Show all events check box to show all events.

7. Navigate through the Events list until you find Stored Procedures event category.

Expand Stored Procedures event category if it is collapsed. Uncheck the checkbox for
RPC:Completed event and check the checkbox for SP:Completed event. Uncheck the
Show all events checkbox to show only selected events. The screen should now look
as shown in following screenshot:

8. Click on the Run button to start the trace.
9. Now open SQL Server Management Studio and establish a connection to the same
SQL Server.
10. In query window, type the sample T-SQL statements as shown in following script and
then execute them by pressing the F5 key:
USE AdventureWorks2012
GO

SELECT DB_ID()
GO

EXECUTE sp_helpdb