926
Part VII: Monitoring and Auditing
- Configure Profiler with the right set of trace events. They must include the start
and end time data columns so that Profiler can integrate the two logs later. Script
the trace to T-SQL code. Close Profiler. - Manually start the Counter Log. Execute the T-SQL trace code to start the server-
side trace. - Exercise the server with the code and load you want to analyze.
- When the test is complete, stop both the Counter Log and the server-side trace.
- Open Profiler, and then open the saved trace file.
- Use the File ➪ Import Performance Data menu command to import the Counter Log.
Profiler responds to the import by adding a pane that displays the System Monitor graph,
as shown in Figure 38-4. Select a Profiler event or a time in the System Monitor graph; the
two stay in sync.FIGURE 38-4
SQL Server Profi ler can integrate Performance Monitor data and move through the events
in sync.c38.indd 926c38.indd 926 7/31/2012 10:04:20 AM7/31/2012 10:04:20 AM
http://www.it-ebooks.info