|ID||Task||Directions and/or screenshot|
|6a||Profiler: Open a new session to start the analysis portion.
Open Data Set: Open the trace data by navigating to File | Open | Trace File or Trace Table menu.
|6b||Connect to Server: When connecting to a Trace Table, connect to the SQL Server with the captured Profiler data.|
|6c||Source Table: Navigate to the correct database, owner and table with the data.|
|6d||Loaded Data: The data will then load in the Profiler screen.|
|7a||Performance Monitor: In order associate Performance Monitor data with Profiler, click on File | Import Performance Data.
In the 'Open File' interface, navigate to the Performance Monitor file.
|7b||Performance Monitor Counters: Once the file is read, all of the corresponding counters are read and loaded.
Select the needed counters and press the OK button to load this Performance Monitor data.
|7c||Both the Profiler and Performance Monitor data will then be in the same interface.|
|8a||Performance Monitor Configuration: To begin analysis, deselect the counters to fine-tune the data displayed in the Performance Monitor window. Basically, you are reducing the number of counters so only those needed for analysis are displayed.
Click in the graph and highlight a portion of the data to zoom in on a smaller period of time.
To zoom back out to the entire time period, right click on the graph and select 'Zoom Out' or 'Show All Data.'
|8b||Profiler Configuration: Right click on the Profiler window and select 'Properties' on the 'Events Selection' and deselect the counters to fine-tune the selected data.|
|9||Data Association: With a manageable set of data, it is possible to scroll through the Profiler data. A thick vertical red bar associates it with Performance Monitor to correlate the two metrics.|
|10||Research and tuning||
Continue to review the data based on a best-practices perspective from both the Profiler and Performance Monitor to find performance issues.
Associating SQL Profiler and Performance Monitor data
Part 1: Configuring Profiler and Performance Monitor
Part 2: Capturing data
Part 3: Associating and analyzing data
|ABOUT THE AUTHOR:|
| Jeremy Kadlec
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also the SearchSQLServer.com Performance Tuning expert. Ask him a question here.
Copyright 2006 TechTarget
More information from SearchSQLServer.com