How to create a trace?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
How to create a trace?
Rating:
Take the following steps to create a trace:
- Run SQL Server Profiler from Start > Programs > SQL Server 2005 > Performance Tools > SQL Server Profiler.
- The SQL Server Profiler will be displayed.
- Click the File menu > New Trace.
- In the Connect to Server window, select server name from the Server name drop down list and click the Connect button.
- In the Trace Properties dialog box, specify the properties for the trace.
- The trace will be displayed in the SQL Server Profiler window.
- In the SQL Server Profiler window, click the File menu > Save As. The options for saving the trace will be displayed. Select the option as needed. Here, the trace will be saved in a trace file.
- In the Save As dialog box, specify a name and location for the trace and click the Save button.
- The trace will be saved at the specified location.
Rating:
Was this information helpful?
Other articles
- Tip for server roles.
- What is SQL Server Profiler?
- How to create a computed column?
- What are waits?
- How to use a table variable?