Start>All Programs>Microsoft SQL Server 2005>Performance Tools>SQL Server Profile>File>New Trace
Example:
1. Launch SQL Server Profiler.
2. From the File menu, choose New Trace.
3. Connect to your SQL Server instance.
4. On the General tab, specify the following options:
A. Name of the trace
B. Blank template
C. Save to file and use the default file name
D. Maximum file size of 50 MB
E. Enable file rollover
5. On the Events tab, select the check boxes for the following events:
A. SQL:BatchCompleted
B. RPC:Completed
C. Showplan XML
6. Specify the following additional data columns:
A. CPU
B. Reads
C. Writes
D. Start Time
E. End Time
7. Run the trace.
8. Using SSMS, execute several queries against the AdventureWorks database and
observe what is captured in Profiler.
9. In SQL Server Profiler, stop the trace. Close Profiler.
Start>All Programs>Microsoft SQL Server 2005>Performance Tools>SQL Server Profile>File>New Trace
Example:
1. Launch SQL Server Profiler.
2. From the File menu, choose New Trace.
3. Connect to your SQL Server instance.
4. On the General tab, specify the following options:
A. Name of the trace
B. Blank template
C. Save to file and use the default file name
D. Maximum file size of 50 MB
E. Enable file rollover
5. On the Events tab, select the check boxes for the following events:
A. SQL:BatchCompleted
B. RPC:Completed
C. Showplan XML
6. Specify the following additional data columns:
A. CPU
B. Reads
C. Writes
D. Start Time
E. End Time
7. Run the trace.
8. Using SSMS, execute several queries against the AdventureWorks database and
observe what is captured in Profiler.
9. In SQL Server Profiler, stop the trace. Close Profiler.